Connect to Progress using the Database connector in Jitterbit Integration Studio

This page details how to connect to Progress using the Database connector.

Follow the steps below to configure and use the Progress JDBC driver on each Jitterbit private agent within a private agent group:

1. Download the Progress database JDBC driver (openedge.jar).

2. Stop Jitterbit services by running StopServices.bat in your private agent home directory. The private agent root directory is usually in one of these default locations:

   • Windows (Harmony): C:\Program Files (x86)\Jitterbit Agent\

   • Windows (v5.x): C:\Program Files (x86)\Jitterbit Integration Server\

   • Linux: /opt/jitterbit

3. Copy the JAR file to this recommended folder path: <JITTERBIT_HOME>/tomcat/drivers/lib/, replacing <JITTERBIT_HOME> with the private agent root directory.

   Caution

   You may also have JAR files located in <JITTERBIT_HOME>/tomcat/webapps/axis/WEB-INF/lib/; however, this directory may be overwritten if you upgrade your private agent. Instead, we recommend placing any drivers you install in <JITTERBIT_HOME>/tomcat/drivers/lib/.

4. Add these lines to JdbcDrivers.conf file in your private agent home directory:

   <Driver>
   <Name>Progress OpenEdge</Name>
   <Class>com.ddtek.jdbc.openedge.OpenEdgeDriver</Class>
   <Subprotocol>datadirect:openedge</Subprotocol>
   </Driver>
   

5. Restart Jitterbit services by running StartServices.bat in the private agent home directory.

6. During configuration of the Database connection, specify these inputs:

   • Driver Type: Select JDBC.

   • Driver: Select the Progress OpenEdge driver.

   • Use Connection String: Under Optional Settings, select this checkbox.

7. Connection String: Under Optional Settings, enter the manual connection string with the appropriate host, port, and database name:

   jdbc:datadirect:openedge://localhost:7777;databaseName=jb
   

8. On successful connection, you should be able to view the tables and views during Database activity configuration.