Skip to end of metadata
  • Created by Former user, last modified by Former user on Oct 07, 2008
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Work in progress.... but here are some links:

http://forums.pentaho.org/showthread.php?t=51035

http://forums.pentaho.org/showthread.php?t=57018

http://www.progresstalk.com/

Instructions for Progress 9.1(C/D and probably more versions)

 Copy your JdbcProgress.dll and Procli92.dll files from your Progress installation to the C:\Windows\System32 folder.

 Copy jdbc.zip and progress.zip from your Progress installation to the libext folder of your PDI installation and rename both files .jar

 All you need now is to connect to your database, load PDI and set the database type to Generic database, in the generic tab use a format like the following:

Url: jdbc:jdbcprogress:T:myserver:mydatabase:mydatabase
Driver Class: com.progress.sql.jdbc.JdbcProgressDriver

Where myserver is the name of your server, and mydatabase is the name of your database.

In the General tab enter your database username and password, probably SYSPROGRESS and hit the test button. You should get an Ok message.

I had a 45x speed up over the ODBC drivers, so its worth pursuing.

One word of warning though, the JDBC drivers seem to have a huge memory leak, when I tried downloading a lot of data is crashes Kettle at around 10M rows with an out of memory error, the trials and tribulations of closed source drivers I guess.

  • No labels