database - Connecting via JDBC to OpenEdge in Talend -


in "talend data integration" want create connection using jdbc progress openedge database. have no experience whatsoever type of connection.

my odbc-connections same resources work fine, talend requires jdbc connection function properly.

the connection settings in talend have @ moment are:

  • db type: general jdbc
  • jdbc url: jdbc:sqlserver://db-name:port;databasename=**
  • driver jar: ??? (which jar-file need openedge?)
  • class name: ??? (which class name need openedge?)
  • user name: *
  • password: *
  • schema: ??? (don't know means...?)
  • mapping file: ??? (which xml-file need progress openedge?)

edit: using windows 7 on 64-bit machine, using talend open studio data integration version 5.3.0.r101800.

i found solution:

what need set of jar-files provided specific installation of progress openedge. these files, located in folder called "java", not commonly available on internet , should meet exact version using. if necessary, need contact database provider. use these files (you may not find of them depending on version of progress openedge):

  • progress.jar
  • openedge.jar
  • util.jar
  • base.jar
  • pool.jar
  • spy.jar

my url wrong (it still set mysql). instead use:

jdbc:datadirect:openedge://your-server-name:your-port;databasename=your-db-name 

as class name, use:

com.ddtek.jdbc.openedge.openedgedriver 

i left schema , mapping file blank, , worked. luck!


Comments

Popular posts from this blog

c# - DetailsView in ASP.Net - How to add another column on the side/add a control in each row? -

javascript - firefox memory leak -

Trying to import CSV file to a SQL Server database using asp.net and c# - can't find what I'm missing -