Skip to end of metadata
Go to start of metadata
  • 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