Page 1 of 1
Accessing Oracle 10g
Posted: Mon Nov 27, 2006 8:09 am
by somashekar_mb
Dear All,
Is it possible to access Oracle 10g database through DynamicRDBMS stage? if yes, is there any constraints compared to Oracle stage? currently our project uses Oracle 9i database and now planning for migrate to 10g. we are using DataStage Server edition 7.5.1.A
Regards
Som
Posted: Mon Nov 27, 2006 8:37 am
by chulett
Welcome aboard! :D
Is it possible to access Oracle 10g database through DynamicRDBMS stage? Yes, certainly.
If yes, is there any constraints compared to Oracle stage? Hmm... not sure there are any constraints, per se, but then I don't see any advantages. The reason the DRS stage was 'invented', AFAIK, was the thought that jobs could built using it accessing Database A and then easily switched to Database B with just the flick of a switch. PeopleSoft, Oracle, Informatica, yada yada. The reality of it isn't quite so simple.
The one issue that jumps to mind are the use of '?' Parameter Markers ala the ODBC stage rather than the numbered markers (:1, :2) the OCI stages would use. Personally, I find the OCI way much more powerful and easier to use over the positional markers.
Other than that, I
believe the two stages are equivalent. But then I don't use the DRS stage. I'll let others who have actually used both chime in with more specifics.
Posted: Fri Dec 01, 2006 9:31 am
by somashekar_mb
Hi Chullet,
Thanks for the Information.
Regards
Som