Page 1 of 1
Progress Vs DataStage
Posted: Fri Feb 26, 2010 1:48 am
by senthilt1
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
Posted: Fri Feb 26, 2010 1:58 am
by ray.wurlod
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.
Posted: Fri Feb 26, 2010 2:34 am
by LNarayan
Thanks Ray for the Info.
Posted: Fri Feb 26, 2010 3:41 am
by sagi
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
Posted: Sun Feb 28, 2010 4:35 pm
by vmcburney
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.