Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • Stop Jitterbit services by running StopServices.bat in your Jitterbit Home directory
  • Place driver in:

    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
    Note

    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

Panel
borderColor#FF7C4C
titleColor#FFFFFF
titleBGColor#FF7C4C
titleRelated Articles
Content by Label
showLabelsfalse
max1000
showSpacefalse
sorttitle
cqllabel in ("database","jdbc") and space = "DOC"
Panel
borderColor#00B886
titleColor#FFFFFF
titleBGColor#00B886
titleRelated Topics
Content by Label
showLabelsfalse
max1000
showSpacefalse
sorttitle
cqllabel = "source-overview" and space = "DOC"

HideElements
metastrue

Last updated:  lastmodifieddate