Configuration for Database Connection

ashishm · Post by **ashishm** » Mon Aug 13, 2012 12:11 pm

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.

PaulVL · Post by **PaulVL** » Mon Aug 13, 2012 12:28 pm

You should read the manual.

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

ashishm · Post by **ashishm** » Mon Aug 13, 2012 12:42 pm

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.