Can ODBC stage used for an Oracle stage?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
LavanyaRamesh007
Participant
Posts: 42
Joined: Mon Apr 21, 2008 1:49 am

Can ODBC stage used for an Oracle stage?

Post by LavanyaRamesh007 »

Can ODBC stage replace Oracle stage..? Oracle also used ODBC connection.. what s the difference between them?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sure, you can use ODBC to connect to Oracle. Oracle itself does not use ODBC but rather leverages the Oracle client over sqlnet. ODBC can also leverage the same Oracle client or can use a wired driver so that the client is not required. Thick versus thin, in other words.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply