Talend community forum / [resolved] TOS and Progress OpenEgde - Can it be done?

mhedrich · 2010-11-11 14:41:12

Hi -

We want to use TOS 4.1.1 to move data from a Progress OpenEdge database to Oracle. Is TOS capable of doing this? Any special setups, requirements, etc?

Thanks

shong · 2010-11-12 08:54:21

Hello
For Progress OpenEdge database, you can use generic JDBC component, there are some special components for Oracle, such as tOracleInput. Here is a related topic:
http://www.talendforge.org/forum/viewto … ?pid=25537

Best regards
Shong

mhedrich · 2010-11-30 14:30:20

Thanks for the info -

Still can't connect with JDBC -

Here are the current settings which result in "impossible to initialize the connection".

General JDBC

jdbc:datadirect:openedge://10.1.111.101:4000;databaseName=SUBS

C:\Progress\OpenEdge\java\jdbc.jar;C:\Progress\OpenEdge\java\progress.jar

com.progress.sql.jdbc.JdbcProgressDriver

Basically not sure which .jars, .dlls, etc. are needed and in what locations.

Thanks

shong · 2010-12-01 02:52:30

Hello
It seems the class name is wrong, try this:
com.ddtek.jdbc.openedge.OpenEdgeDriver

Here is a beginner guide to OpenEdge SQL via ODBC, JDBC
http://www.progress.com/progress/produc … /dmsdv.pdf

Best regards
Shong

Announcement

Unanswered posts

#1 2010-11-11 14:41:12

[resolved] TOS and Progress OpenEgde - Can it be done?

#2 2010-11-12 08:54:21

Re: [resolved] TOS and Progress OpenEgde - Can it be done?

#3 2010-11-30 14:30:20

Re: [resolved] TOS and Progress OpenEgde - Can it be done?

#4 2010-12-01 02:52:30

Re: [resolved] TOS and Progress OpenEgde - Can it be done?

Board footer