Page 1 of 1
Difference between Dynamic RDBMS, ODBC and OCI Loader
Posted: Sun Mar 22, 2009 10:59 pm
by shalini11
Hi All,
Could you pls explain what's the difference between Dynamic RDBMS and ODBC and OCI Loader. Also which stage is preferable and when?
I have used only Oracle enterprise stage as of now so dont have any idea about these stages.
Will it be faster using Dynamic RDBMS instead of OE stage?
Thanks
Posted: Mon Mar 23, 2009 12:27 am
by ray.wurlod
Dynamic RDBMS stage is nothing more than a wrapper - the DBMS type determines whether an ODBC driver, an OCI function, a Sybase OC function, etc., gets called.
It will never be faster than the equivalent native interface because it is nothing more than an additional layer of software.
But it's more convenient, particularly for folks like PeopleSoft, where the database type is not known a priori.
Posted: Mon Mar 23, 2009 12:56 am
by shalini11
Sorry, I am not able to view your full answer.
Some premium content button is displayed. Could tou pls tell how can I view your answer
Based on versions
Posted: Mon Mar 23, 2009 1:50 am
by sureshreddy2009
Hi
We have so many sources sqlserver, oracle, db2, informix ..etc
initially we have OCI stage, with this stage we will connect up to particular databases, for example older datastage versions can not connect to oracle 10g, because at that time that verison of oracle is not developed, so with OCI stage we can connect up to some versions of databases based on the datastage version, this is having rich performance, so for avoiding this we have ODBC stage, from this we can connect to any type of database and any version, because this is related to system and it connects based on system connection, but this is poor performance, for avoiding all these we have Dynamic RDBMS, it is more popwerful for connecting with any version and with any database and it is having great performance, final conclusion is
1.if ur OCI stage supports your database version use OCI
2.if not suports go for Dynamic RDBMS
3.if any of the stage can not supports for connecting certain databases then go for ODBC stage.for example ODBC stage is used for connecting Excel and MsAccess
hope this will useful
Thanks
Posted: Mon Mar 23, 2009 2:32 am
by shalini11
Thanks a lot for clearing my doubts.
Posted: Mon Mar 23, 2009 10:15 am
by chulett
shalini11 wrote:Sorry, I am not able to view your full answer.
Some premium content button is displayed. Could tou pls tell how can I view your answer
By purchasing a Premium Membership:
premium_membership.php
Re: Based on versions
Posted: Mon Mar 23, 2009 10:20 am
by chulett
sureshreddy2009 wrote:initially we have OCI stage, with this stage we will connect up to particular databases, for example older datastage versions can not connect to oracle 10g, because at that time that verison of oracle is not developed, so with OCI stage we can connect up to some versions of databases based on the datastage version, this is having rich performance, so for avoiding this we have ODBC stage, from this we can connect to any type of database and any version, because this is related to system and it connects based on system connection, but this is poor performance, for avoiding all these we have Dynamic RDBMS, it is more popwerful for connecting with any version and with any database and it is having great performance
This is simply... incorrect... on many different levels.
The OCI stage is a 'native' stage and thus connects to Oracle using the Oracle client software installed on the server. There's no issue connecting to 10g if the correct client is used, even in older versions. The days of ODBC automatically meaning "poor performance" are
long gone and there's no magical "power" or "great performance" in the DRS stage, something Ray notes in his post.
Posted: Tue Mar 24, 2009 2:39 pm
by cppwiz
At the IBM on Demand conference last October, three DataStage engineers presented a session about which stages were the fastest. They stated the Oracle and DB2 Connector stages were the best, followed by either the ODBC or native stages. They specifically stated the ODBC stages were now as fast as the Oracle Enterprise or DB2 Enterprise native stages. There was supposed to be a "Connector Job Migration Tool" released to help migrate from the old stages to the new connector stages for the best performance. Has anyone seen that tool?
For reference, the session at IoD was TSB-1001 - "Expert: Mastering Database Connectivity with InfoSphere Information Server."