In "Talend Data Integration" I want to create a connection using JDBC to a Progress OpenEdge database. I have no experience whatsoever with this type of connection.
My ODBC-connections to the same resources work fine, but Talend requires a JDBC connection to function properly.
The connection settings in Talend I have at the moment are:
DB Type: General JDBC
JDBC URL: jdbc:sqlserver://db-name:port;databaseName=**
Driver jar: ??? (which jar-file do I need for OpenEdge?)
Class name: ??? (which class name do I need for OpenEdge?)
User name: *
Password: *
Schema: ??? (don't know what this means...?)
Mapping file: ??? (which xml-file do I need for Progress OpenEdge?)
The jar file(s) you will need to add depends on you OpenEdge version but presuming you're on a relatively recent one you just need $DLC\java\openedge.jar (https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmsdv%2Fjdbc-components.html%23)
Just 2 weeks ago, I presented at the EMEA PUG Challenge on Talend and OpenEdge. Here is the PowerPoint for that talk. It has a lot of information on how to connect via JDBC.
Hope this gets you started properly.
Bob Brennan
IMS, Inc.
[View:/cfs-file/__key/communityserver-discussions-components-files/19/Talend.pptx:320:240]