DSXchange

Hi,

I am trying to figure out how to set up a connection between the DataStage Server and a Database server. For example, I have an Oracle Db installed on a different server, if I want to use the OracleConnectorPX stage to connect to that DB server, what should I do to connect to that server. Thanks in advance.

You should read the manual.

You should also talk to your Oracle DBA to get the appropriate Oracle Client installed on your server.

I see the .odbc.ini which is used to define a datasource and being used in the ODBC Stage, but for a particular Stage like OracleConnectorPX Stage or Netezza Enterprise Stage, how can I use these stages to connect to that corresponding database.