Setup communication with DS server and Oracle

bensonian · Post by **bensonian** » Thu Jul 10, 2008 9:56 am

Hi

I was wondering if anybody could help me understand 'how to setup communication between DSengine and Oracle' and
'where i can find the .ini file in order to specify the requied info on the unix box'

Any help in this regard would be appreciated.

Thanks

kcbland · Post by **kcbland** » Thu Jul 10, 2008 10:54 am

Communication is handled via ODBC or Oracle client connectivity. If you're on Windoze, ODBC is handled thru the Control Panel on the DS server. For Oracle client connectivity you'll configure the Oracle client on the DS server. To use Oracle OCI you'll use OCI/plugin stages, for ODBC, well, ODBC.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 10, 2008 3:32 pm

The .odbc.ini file is usually in the DataStage Engine directory. Its location is usually stored in the $ODBCINI environment variable.

John Smith · Post by **John Smith** » Thu Jul 10, 2008 10:52 pm

the setup depends on whether your DS server is on Unix or Windows.
Pls refer to your DS documentation. It's in there somewhere.