• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » TOS with Progress OpenEdge 10

#1 2009-01-20 21:24:31

haubuchon
New member
Registered: 2009-01-20
Posts: 2

TOS with Progress OpenEdge 10

Has anyone tried TOS with OpenEdge 10.1 ?
I'm using it through general JDBC but I had to do some major adaptations:

1. The jdbc driver is containes in 3 jar files and TOS does not seems to allow to specify 3 jars for the driver. I combined all the 3 jars into one jar file but this is a really buggy solution.

2. I had to modify a new mapping files because some datatypes were not reconized.

Anybody else had to go through this or had a better solution ?

Offline

#2 2009-04-24 13:49:44

carl
Guest

Re: TOS with Progress OpenEdge 10

As far as I know the Progress odbc requires 5 jar files, maybe that's the reason for the buggyness

The files are base.jar, openedge.jar, pool.jar, spy.jar and util.jar

#3 2009-04-24 14:10:09

carl
Guest

Re: TOS with Progress OpenEdge 10

No need to make a new jar, just specify mutliple jars.
I can connect using following settings

DB Type : Generic JDBC
JDBC URL : jdbc:datadirect:openedge://host:port;databaseName=DBNAME
Driver jar : c:\progress\oe101c\java\base.jar;c:\progress\oe101c\java\openedge.jar;c:\progress\oe101c\java\pool.jar;c:\progress\oe101c\java\spy.jar;c:\progress\oe101c\java\util.jar
User name : sysprogress
Password (must not be empty) : ******
Mapping file (I didn't enter this value) : mysql_id

#4 2009-05-13 10:13:16

Borowsky
New member
Registered: 2009-05-13
Posts: 2

Re: TOS with Progress OpenEdge 10

Hi !

Where can I find these 5 jar file ? Are they in the installation cd of progress ?

PS : i use OpenEdge 10.0B

Thanks !

Offline

#5 2009-05-18 15:29:43

Borowsky
New member
Registered: 2009-05-13
Posts: 2

Re: TOS with Progress OpenEdge 10

Thanks for your reply ! lol

For your information, with OpenEdge 10.0B, it's not these files but just jdbc.jar and progress.jar which are in $dlc/java directory.

Offline

#6 2012-06-22 21:13:04

tale103108
Member
Registered: 2010-08-10
Posts: 47

Re: TOS with Progress OpenEdge 10

isn't a Class name also required.  I have tried "com.ddtek.jdbc.openedge.OpenEdgeDriver" with no luck.
Any suggestions?

Cheers!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » TOS with Progress OpenEdge 10

Board footer

Powered by FluxBB