All analytics data being tracked at the proxy are stored and fetched from the analytics database for processing. To enable data storage and processing, a third a third Party installation of PostgreSQL DB Server is required. The sections below illustrate the PostgreSQL configuration.

...

1. Download PostgreSQL from https://www.postgresql.org/download/.
2. Install PostgreSQL (9.6 or a higher version) on the machine where the Analytics Database is to be created.
3. Create a preferred username, set a password and create the database.
4. Download the PostgreSQL JDBC driver for JVM from https://jdbc.postgresql.org/download/postgresql-42.2.2.jar.
5. Provide the jar path in the server.conf file at FIORANO_HOME/esb/server/bin.
   
   
   Figure 1: Providing the jar path in the server.conf file

Configuring the Analytics Database

Certain changes need to be made to the Fiorano setup for the Analytics database to connect to the PostgreSQL. This can be done using any one of the following ways:

• From the configuration file
• From eStudio
• From the API Dashboard

From the configuration file

...

1. Go to the Server Groups section in the API management dashboard Admin module.
2. Select the environment (Server Group) for which the Analytics database needs to be configured and provide values.
   .
3. Provide the values for the Analytics Database Configuration properties; other than the credentials for the JDBC driver, provide values for the below:
   • Try Reconnect Interval: Interval (in secs) after which the Stored Procedure tries to reconnect with the DB in the event of a connection loss.

   • Auto Reconnect: Select true or false to specify whether the Stored Procedure should try for an automatic reconnection with the DB or not.

     Info
     The changes get updated in the apidb.cfg file.

   Tip
   Refer the Configuring Analytics Database section for more details.

   • Image Modified
     Figure 4: Analytics DB properties in the Server Groups section in the Administration section of API Dashboard

Configuring the Mail Server to receive Analytics notifications

For receiving Analytics notifications, the Mail Server section can be configured in the Admin module of the API Management dashboard. 

Refer the Mail Server section to see the properties that need to be updated.