Convertigo Mobility Platforms comes with several JDBC drivers already configured such as Oracle, MySQL or IBM DB2. However, it is possible to add any JDBC driver. We can also use postgresql to record analytics. For this, we have to install postgresql driver.There are steps in order to add a new JDBC driver to Convertigo configuration.
We assume postgresql is still installed and we can use an account with rights like create tables, write records...
First, you have to download the jar file (in this case : postgresql-9.4-1201.jdbc4.jar) and copy the .jar file in :
We need to restart convertigo server have the modification taken in account.
Then, we will configure analytics with the convertigo web administration console
Open the convertigo web administration console with your administrator account and go in config-> Analytics
we have to configure the differents fields :
Let the others fields with their default values. Save your configuration by click on update configuration
You have to create database c8oanalytics in postgresql. Use standard postgresql tool to create the base and give rights.The tables will be created with the first connection from convertigo.