Reading from oracle table on remote server

raj4756 · Post by **raj4756** » Wed Apr 14, 2004 2:38 pm

Hello All,

I have a job in DataStage that reads from an Oracle table that is on a remote server. What kind of connectivity is it using to connect to Oracle i.e SQL NET , DB LINKS or ODBC ??

Thanks.

Raj

kcbland · Post by **kcbland** » Wed Apr 14, 2004 2:50 pm

In a parallel job, you're using OCI, so it's sqlnet. In a Server job, using an OCI stage, it's also sqlnet. Using an ODBC stage obviously is ODBC.

shawn_ramsey · Post by **shawn_ramsey** » Wed Apr 14, 2004 3:26 pm

kcbland wrote:In a parallel job, you're using OCI, so it's sqlnet. In a Server job, using an OCI stage, it's also sqlnet. Using an ODBC stage obviously is ODBC.

A little more clarification with the ODBC. If you are using the Wire Protocol ODBC drivers it is ODBC, if not then the ODBC driver calls the OCI.

kcbland · Post by **kcbland** » Wed Apr 14, 2004 3:32 pm

The poster is on DS 6.0, so they should be using the wire protocol drivers. For those on earlier releases, yes, the ODBC piggybacks the OCI.

shawn_ramsey · Post by **shawn_ramsey** » Wed Apr 14, 2004 3:57 pm

Ascential provided both the Wire and Non-Wire drivers with the Windows version and I would assume it is the same with the Unix version.