Skip to Content

Convert from an ODBC to a JDBC driver in Jitterbit Integration Studio

Converting a Database connection from using an ODBC driver to using a JDBC driver is usually a straightforward process. You may need to do so if you move a project from running on a private agent using an ODBC driver to a Jitterbit cloud agent group, which haven't supported ODBC drivers since the release of Harmony version 9.8.

If your connection uses the default options, you can quickly convert it following the steps outlined below. However, if you have used the option to specify additional connection string parameters or to construct the connection string manually, you will need to adjust those options to accommodate the differences between ODBC and JDBC.

Jitterbit support is available to help you in converting your connection to JDBC if you require assistance with converting your Database connections or the revision of advanced options.

Convert simple Database connections

To convert a Database connection that currently uses an ODBC driver to one that uses a JDBC driver, follow these steps:

  1. Open the Database connection that uses an ODBC driver. In this example, a connection using the PostgreSQL driver was opened:

    database connection configure ODBC

  2. Test the connection by clicking the Test button to make sure that it works:

    database connection configure test

  3. If the connection was successful, you can proceed with this conversion. If not, fix any errors before continuing.

  4. Check if any additional connection parameters were specified by clicking the Optional settings at the bottom of the configuration screen:

    database connection optional settings

    • If no additional connection parameters were specified beyond the defaults shown above, you can proceed with converting the Database connection following the remainder of these instructions.

    • If there are additional connection parameters specified other than the defaults shown above, see the next section on Converting connections with additional connection parameters.

  5. Change the Driver type to JDBC, then use the Driver dropdown to select the appropriate JDBC driver. In this example, we selected the PostgreSQL JDBC driver.

    database connection configure driver

  6. Test the revised connection by clicking the Test button to make sure that it works:

    database connection configure test

  7. Click the Save Changes button to save the revised Database connection.

Convert connections with additional connection parameters

If your connection uses additional connection parameters beyond the default values shown above, either as Additional Connection String Parameters or the checkbox Use Connection String was checked and the connection string was entered manually, additional work may be required to convert the connection from ODBC to JDBC. For example, the SQL Server ODBC Additional Connection String Parameters might be (to use NTLM Windows Authentication):

integratedSecurity=true

An equivalent SQL Server jTDS JDBC driver Additional Connection String Parameters (to use NTLM Windows Authentication) would be:

useNTLMv2=true

Connection string parameters are specific to the database driver you use (for example, Microsoft SQL, MySQL, PostgreSQL, or Oracle). Review the driver specifications to determine the required parameters. If you require assistance with converting connection strings or parameters for a JDBC driver, contact Jitterbit support.