To configure a connection, download the JDBC driver for your platform.
Our application provides access to most drivers certified to integrate with Coginiti. However, if your company prefers to use a different JDBC driver's version, you must add it manually. If that's your scenario, you must use a Generic JDBC driver to set up a database connection.
Coginiti Pro and Team require specific platform drivers to enable users to set up a connection.
⚠️ Only an admin can download a driver for their end users. It is a security concern and guarantees that large organizations stay on the same driver version.
HOW TO EDIT JDBC DRIVERS
- Go to File > Edit Drivers
- Fill in the required fields with valid data.
Notice that only admins see this option.
When setting up a new connection, you can handle the JDBC Driver right within the connection setup dialog. If you're dealing with distributed drivers, their download link will be generated automatically.
You may encounter an error message if your company doesn't permit you to download drivers (jar files), typically supplied from a Maven repository. In this case, you will have to add the driver manually.
HOW TO ADD DRIVERS MANUALLY
- Go to File > Edit Drivers to open the setup dialog
- Click the 'edit drivers panel' link below the Database JDBC Driver field.
- Enter the needed details in the pop-up window.
JBCD Driver name will be automatically filled.
Description – Write a description for your Driver.
Class name – If it does not appear automatically, you can find it in the JDBC reference manual for your platform.
JDBC Driver files – If you select Provided, you'll see a list of drivers we recommend downloading. And if you choose Custom JDBC driver, you can manually add a driver from a private machine.
If you select the wrong Driver, click the "Remove" button and follow the steps above to add the correct Driver.
CUSTOM JDBC DRIVERS
If your company requires custom drivers that Coginiti cannot provide, please follow the instructions below:
- Go to File > Edit Drivers to open the setup dialog
- Click the edit drivers panel link below the Database JDBC Driver field
- Select the Custom JDBC driver option in the JDBC Driver File (s) field.
- Click on Add File(s) and select the Driver file that has been provided to you by your company.
UPGRADING DRIVERS
For security reasons, we do not automatically upgrade user drivers. Therefore, if you want to use a new driver, you must install it manually.
- Go to File > Edit Drivers to open the setup dialog
- Select the connection
- Click Edit JDBC Driver.
⚠️ We recommend downloading the latest Driver. However, be careful with the Driver's version. Updating Coginiti with the new version doesn't mean updating the connection to the latest driver version.