Installing JDBC drivers

Informer ships with standard SQL database drivers for many common database types. To connect to a SQL database that is not supported by default, add a custom JDBC (Java Database Connectivity) driver. These drivers are maintained by the database providers; many are free on the provider's support site, while some are proprietary and require a paid account.

For setting up the Datasource afterward, see the Datasources section.

Windows

1. Download the JDBC .jar from the database provider and place it in the ./java directory inside the Informer install directory (for example, C:\Entrinsik\Informer5\java). Create the folder if it does not exist.
2. Restart the Informer service to apply the change.

Linux (Docker)

1. Under the volumes section of all three Informer containers, add this line if it is not already present:

   - ./java/plugins:/informer/java/plugins

   A container's volumes section then looks like:

   volumes:
     - ./plugins:/informer/plugins
     - ./java/plugins:/informer/java/plugins
     - ./config.json:/informer/config.json

2. Edit config.json and add a javaDir:

   "javaDir": "/informer/java/plugins"

   For example:

   {
     "http": "80",
     "https": "443",
     "javaDir": "/informer/java/plugins",
     "loadBalancer": {
       "rules": [
         { "regex": ".*\\/jobs\\/[^\\/]*$", "url": "http://informer-schedules" },
         { "regex": ".*_(query|run|refresh)+", "url": "http://informer-query" },
         { "regex": "$", "url": "http://informer-api" }
       ]
     }
   }

3. Download the JDBC .jar from the database provider and place it in the ./java/plugins folder in the Informer install directory. Create the folder if it does not exist.

4. Stop and remove each Informer container.

5. Restart the containers to apply the change.