Page 1 of 1
Reading from oracle table on remote server
Posted: Wed Apr 14, 2004 2:38 pm
by raj4756
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
Posted: Wed Apr 14, 2004 2:50 pm
by kcbland
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.
Posted: Wed Apr 14, 2004 3:26 pm
by shawn_ramsey
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.
Posted: Wed Apr 14, 2004 3:32 pm
by kcbland
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.
Posted: Wed Apr 14, 2004 3:57 pm
by shawn_ramsey
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.