what the difference between using ODBC and oracle

LavanyaRamesh007 · Post by **LavanyaRamesh007** » Tue Aug 12, 2008 4:13 am

what the difference between using ODBC and oracle stage. What are the factors that needs to be considered to choose it?

ray.wurlod · Post by **ray.wurlod** » Tue Aug 12, 2008 4:34 am

ODBC uses ODBC protocols (ODBC being a standard invented by Microsoft originally). Oracle stages use Oracle Client Interface (OCI) protocols.

The difference between "using" them is simply which one you choose to emplace in your job design.

Jasti · Post by **Jasti** » Tue Aug 12, 2008 4:39 am

Oracle Enterprise Stage is specifically for Oracle Database where as the ODBC is for Open Data Base Connectivity.
There are some other Database stages like DB2/UDB, TeraData, Informix, Sybase.. etc which are Vendor specific and are designed to have good performance for that perticular database.
Relatively the performance of ODBC stage is less but we can use it for accessing various databases like Progress for which we do not have specific stages in DataStage..

chulett · Post by **chulett** » Tue Aug 12, 2008 6:46 am

I tend to stick with native interfaces over ODBC 100% of the time. That's just my preference, mostly because you don't have as many options with ODBC. And the whole concept of 'ODBC is less performant' is pretty much an urban myth, especially in this day and age.