Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

 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

...

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.