...
Copy your JdbcProgress.dll and Procli92.dll files from your Progress installation to the libswt\win32 folder of your PDI installationC:\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:
| No Format |
|---|
Url: jdbc:jdbcprogress:T:myserver:mydatabase:mydatabase Driver Class: com.progress.sql.jdbc.JdbcProgressDriver |
...
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.
Another word of warning: The Progress-provided (Data Direct?) JDBC drivers can't cope with the Progress "feature" that allows more data to be stored in a field than is specified in the schema and will just crash when such a record is seen. Had much better luck with the three-tier OpenLink JDBC drivers.