List of default relational database connectors
A complete list of all database connectors available in Bonita for the major relational database vendors (e.g. Oracle, MySQL, PostgreSQL…).
This page lists the database connectors provided with Bonita. For some connectors there are special considerations, included in a section below.
If you are configuring a connector to a database that is the same type of database used by Bonita Engine, you are recommended to use the same driver for both, to limit possible conflicts.
Here is the list of database connectors. The links take you to sections of this page giving dedicated best practice information.
To configure a database connector, follow the instructions in the wizard.
If you are using the
terajdbc4.jar, you also need the
tdgssconfig.jar into Bonita Studio and add them to the connector configuration.
terajdbc4.jar as the active driver. To test the connector, you must specify both files. When you configure the process, specify both files in the process dependencies.
Supported versions: This connector supports SQL Server 2008, 2012, 2014 and 2016.
Language encoding: MS SQL Server uses only one encoding at a time. To avoid errors when creating the database, please do the following when using alternative languages:
Define the encoding:
Choose the language from the list
Save the configuration
Using a named instance: To use a named instance with your connector, you need to retrieve some information from the SQL Server Configuration Manager.
Go to MS SQL Server network configuration.
Go to Protocols for instance (where instance the name of the instance).
In the TCP properties, get the port number.
When you configure the connector, use this port number in the URL. For example:
Two driver jar files are available, and the Driver and URL values to specify in the configuration wizard depend on which jar you use: