Database Source Connecting to Progress via JDBC

• Download the Progress Database JDBC Driver (openedge.jar). You can access the driver at https://download.jitterbit.com/support/templates/openedge.jar

• Stop Jitterbit services by running StopServices.bat in your Jitterbit Home directory

• Copy the JAR file to the following recommended folder path: <JITTERBIT_HOME>/tomcat/drivers/lib/, replacing <JITTERBIT_HOME> with your Private Agent root directory. Your 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

  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/.

• Add the following lines to JdbcDrivers.conf file in your Jitterbit Home directory:

<Driver>

<Name>Progress OpenEdge</Name>

<Class>com.ddtek.jdbc.openedge.OpenEdgeDriver</Class>

<Subprotocol>datadirect:openedge</Subprotocol>

</Driver>

• Restart Jitterbit service by running StartServices.bat in your Jitterbit Home directory

• Go to Jitterbit Studio and create a new data source:
  • Pick Progress OpenEdge [JDBC]
  • Enter your credentials
  • Provide the following connection string by providing the appropriate host, port and database name

• Test your connection

Upon successful connection, you should be able to view the tables and views while you create your operations