Using Datastage to load Oracle
Moderators: chulett, rschirm, roy
Using Datastage to load Oracle
We currently use Datastage to load data from Universe files into SQL Server. We would like to begin loading the Universe files into Oracle. The only option is see is the ORABULK. Is there any documentation on how to set up jobs to load Oracle? I have tried ORABULK and ODBC but failed. Any assistance is greatly appreciated.
In your version, you should have an OCI and an OCI8 stage to load into Oracle 7 and 8, respectively. They are optional plugins, so if you don't seem them then they probably weren't loaded when your server was installed.
You can go back and rerun the install script, which will allow you to add new plugins or you can use the dspackinst function to do it as well, if you are familiar with that.
You can go back and rerun the install script, which will allow you to add new plugins or you can use the dspackinst function to do it as well, if you are familiar with that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers