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
Accessing Oracle 10g
Moderators: chulett, rschirm, roy
-
somashekar_mb
- Participant
- Posts: 2
- Joined: Tue Nov 15, 2005 6:45 am
- Location: India
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
somashekar_mb
- Participant
- Posts: 2
- Joined: Tue Nov 15, 2005 6:45 am
- Location: India