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
Progress Vs DataStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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
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
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn