...

Installing and configuring PostgreSQL

Fiorano uses PostgreSQL for its analytics data store.

1. Download PostgreSQL from https://www.postgresql.org/download/.
2. Install PostgreSQL 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

...

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

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

From the configuration file

The postgre db Postgre DB details are stored in the apidb.cfg file present at in the $FIORANO_HOME/esb/server/profiles/server1/AMS/conf directory. To configure the database details, make the following changes in the document:

1. Under the section point 2, change the <ip-address>, <port> and <database> variables to the actual desired settings of the above-installed PostgreSQL setup.

   Note
   Ensure usage of a different database for separate installations of API platform.

2. Under point 3 and point 4 of this document, provide the username and password credentials needed to connect to the installed database.
3. Under point 6 and 7, provide the preferred reconnect settings of choice.
4. Go to $FIORANO_HOME/esb/server/bin/server.conf and under the .
5. Under <java.classpath>segment, add the path to the above-downloaded JDBC driver that was downloaded previously, so that the driver gets added to the classpath of the JVM.
   
   
   Figure 2: Analytics DB properties in the apidb.cfg configuration file
   
   

From eStudio

If the configuration is to be done when the When the servers are not running, it the configuration can be done from the Profile Management perspective in eStudio. Perform the following actions for the same:

1. Launch the Profile Management perspective from Window > Open perspective > Profile Management and open the APIMANAGER profile.
2. Right-click the APIMANAGER node and click the DB Configuration for API Management option.

3. Change values in this dialog box as required (refer to the properties in the From the configuration file section above).

   Info
   The changes

   will reflect

   get updated in

   the

   the apidb.cfg

   file

   file.

   
   Figure 3: Analytics DB properties in the DB Configuration for API Management dialog box in eStudio

From the API Dashboard

When the servers are running, the The analytics database can be configured from the API Dashboard itself.

1. Go to the Server Groups section in the API management dashboard Administration Admin module.

2. Select the environment (Server Group) for which the Analytics database needs to be configured and provide values.
   
   

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

   Tip
   Refer the Configuring Analytics Database section for more details.

   
   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

To receive For receiving Analytics notifications, the Mail Server section can be configured in the Administration module Admin module of the API Management dashboard. Refer the Mail Server section to see the properties that need to be updated.