Hi
Where can i get oracle drivers.?Is there a website twhere i can download from.At the moment i am using ODBC.I want to start using Oracle Plugin.
Unix 5.5 and Datastage 7.5.
Thank,
Oracle drivers for Datastage 7.5 unix 5.8
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Right... to use the OCI plug-ins, no 'driver' (per se) is required - that is terminology generally reserved for ODBC. What you need is an Oracle client installed on the DataStage server, and then changes made to your dsenv file so that DataStage knows where everything is.
As Ray mentioned, talked to your DBA for that.
As Ray mentioned, talked to your DBA for that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
There's a difference between the Oracle database and the Oracle client. Just go to Oracle.com and download the Oracle client for your OS and database version. Install the client, setup the tnsnames.ora file to point to your remote Oracle database, configure your DataStage dsenv file to have the Oracle environment variables, restart DataStage and you're done.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle