DSXchange

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

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.

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

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