Progress Vs DataStage

senthilt1 · Post by **senthilt1** » Fri Feb 26, 2010 1:48 am

HI All,

could you please suggest me the way to connect Progress Database via DataStage.

Is it possible thro ODBC? Or Is there any other stage that we have in Datastage to connect to the Progress Database.

Thanks,

Senthil P

ray.wurlod · Post by **ray.wurlod** » Fri Feb 26, 2010 1:58 am

There is an ODBC stage for Progress, though it does not ship with DataStage; you will have to obtain it from your progress vendor (or via the web). I am not aware of any dedicated stage type for Progress - certainly none ships with the product, but someone may have created one. None of my clients that use Progress use anything else but ODBC.

LNarayan · Post by **LNarayan** » Fri Feb 26, 2010 2:34 am

Thanks Ray for the Info.

sagi · Post by **sagi** » Fri Feb 26, 2010 3:41 am

Can you let us know whether we would be able to connect to progress database through ODBC enterprise stage?

We tried loading the driver into memory with the help of ivtestlib utility, but it failed with error

"libprocli92.so cannot open shared object file"

Should we install the new libraries for achieving the above connectivity to progress database?
OS - unix
DS version - 8.0

vmcburney · Post by **vmcburney** » Sun Feb 28, 2010 4:35 pm

There are more recent ODBC packs than the one you got with 8.0 - have a look at http://tinyurl.com/dsfixes for instructions on finding hot fixes or a patch for your version of DataStage that reinstalls the ODBC drivers. It looks like it's having problems loading the Progress ODBC library file so check permissions on the directories and files and the PATH settings.