difference between Dynamic_RDBMS and oracle OCI stage
Moderators: chulett, rschirm, roy
difference between Dynamic_RDBMS and oracle OCI stage
hello friends,
what is difference related to Dynamic_RDBMS stage and Oracle OCI stage.
i mean to say is there any performance gain using Dynamic_RDBMS over Oracle OCI stage or vice-versa, as for example taking oracle database into consideration.
i am curious as i can do all action in Dynamic_RDBMS stage as provided in Oracle OCI stage.
thanks,
sachin
what is difference related to Dynamic_RDBMS stage and Oracle OCI stage.
i mean to say is there any performance gain using Dynamic_RDBMS over Oracle OCI stage or vice-versa, as for example taking oracle database into consideration.
i am curious as i can do all action in Dynamic_RDBMS stage as provided in Oracle OCI stage.
thanks,
sachin
Both use OCI, assuming you set the DRS stage to Oracle rather than ODBC. The 'advantage' of the DRS stage is the alleged ability to switch databases on the fly, which never works out as easily as the brochure says it will. We have Oracle here and use the OCI stages exclusively. With the DRS set to OCI, I don't see there being any performance difference between the two stages.
As an aside, I especially don't like the way the DRS stage uses 'ODBC style' parameter markers rather than the numbered ones OCI does. Bleeck.
As an aside, I especially don't like the way the DRS stage uses 'ODBC style' parameter markers rather than the numbered ones OCI does. Bleeck.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
Hi Chullet,
I too have the same doubt abiout the difference between Oracle OCI and DRS Stages.Apart from this I doubt whether Oracle OCI use native drivers.Please let me know whether any performance difference between Oracle OCI and DRS Stages in DS server 7.X and the database used is Oracle.
I too have the same doubt abiout the difference between Oracle OCI and DRS Stages.Apart from this I doubt whether Oracle OCI use native drivers.Please let me know whether any performance difference between Oracle OCI and DRS Stages in DS server 7.X and the database used is Oracle.
chulett wrote:Both use OCI, assuming you set the DRS stage to Oracle rather than ODBC. The 'advantage' of the DRS stage is the alleged ability to switch databases on the fly, which never works out as easily as the brochure says it will. We have Oracle here and use the OCI stages exclusively. With the DRS set to OCI, I don't see there being any performance difference between the two stages.
As an aside, I especially don't like the way the DRS stage uses 'ODBC style' parameter markers rather than the numbered ones OCI does. Bleeck.
Warm Regards,
Vijay
Vijay
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
Hi Chullet,
I too have the same doubt abiout the difference between Oracle OCI and DRS Stages.Apart from this I doubt whether Oracle OCI use native drivers.Please let me know whether any performance difference between Oracle OCI and DRS Stages in DS server 7.X and the database used is Oracle.
I too have the same doubt abiout the difference between Oracle OCI and DRS Stages.Apart from this I doubt whether Oracle OCI use native drivers.Please let me know whether any performance difference between Oracle OCI and DRS Stages in DS server 7.X and the database used is Oracle.
chulett wrote:Both use OCI, assuming you set the DRS stage to Oracle rather than ODBC. The 'advantage' of the DRS stage is the alleged ability to switch databases on the fly, which never works out as easily as the brochure says it will. We have Oracle here and use the OCI stages exclusively. With the DRS set to OCI, I don't see there being any performance difference between the two stages.
As an aside, I especially don't like the way the DRS stage uses 'ODBC style' parameter markers rather than the numbered ones OCI does. Bleeck.
Warm Regards,
Vijay
Vijay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
OCI stands for Oracle call interface.and Oracle OCI is meant only for Oracle.But how does this doiffer from Dynamic RDBMS Stage(DRS),As both of these stages have to fetch from database. ???ray.wurlod wrote:What DO you think the Oracle OCI stages use?
Hint: what does "OCI" stand for? ...
Warm Regards,
Vijay
Vijay
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
Hi Chullet,chulett wrote:It's an interface and it is what the OCI stage uses exclusively. The DRS stage can use that or ODBC to communicate with Oracle. ...
So you say that Oracle OCI stage has the Interface which DRS does not have in the stage,Is it?
And this is the reason Oracle OCI may take less time to fetch records from source when compared to DRS.
Correct me if i am wrong.
Thank you so much.
Warm Regards,
Vijay
Vijay
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
When set to 'ODBC' it...searches for open database..chulett wrote:No, when set to 'Oracle' the DRS stage uses OCI. When set to 'ODBC' it... well, I'm sure you can figure that one out. ...
Then What is the use of Oracle OCI when DRS can do the same job.
And i also found when using the Oracle OCI stage instead of DRS i got great time saving for load time.!!
Warm Regards,
Vijay
Vijay
I actually meant, when set to 'ODBC' it uses ODBC as the interface.
I personally stick with OCI and don't use DRS as I abhor the "?" parameter markers it uses and don't need the "switch to any other database on the fly!" capability it was built to allow. Plus it has fewer options built into the stage compared to OCI, being somewhat "generic".
I personally stick with OCI and don't use DRS as I abhor the "?" parameter markers it uses and don't need the "switch to any other database on the fly!" capability it was built to allow. Plus it has fewer options built into the stage compared to OCI, being somewhat "generic".
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 14
- Joined: Mon Jan 19, 2009 9:06 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: