Hello, I'm a brand new DataStage consultant and I have some difficulties with this tool
DataStage is installed on server and client part, and I would like now to import tables definition from an Oracle database. What would be the best solution (ODBC, OCI, ?) to import tables defintion and what would be the steps to follow to succeed ?
Thanks,
StephaneG
Import tables definition using OCI
Moderators: chulett, rschirm, roy
Import tables definition using OCI
Last edited by stephaneG on Wed Nov 08, 2006 5:41 am, edited 1 time in total.
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
Import tables definition
Hi ,
You can import table definitions by
Go to DS Manager ===>Import ===>Table Definitions ===>Plug In Metadta Definitions.
Regards,
Suresh N
You can import table definitions by
Go to DS Manager ===>Import ===>Table Definitions ===>Plug In Metadta Definitions.
Regards,
Suresh N
SURESH NARASIMHA
Could be both. You'll need an Oracle client installed on the same server that DataStage is installed on for it to leverage. And then you'll need to configure DataStage so it knows where to find it.stephaneG wrote:Is it something i've not installed? or not parametered correctly?
It's all documented in both the OCI documentation and in the Plug-In Installation and Configuration Guide. It involves making changes to your dsenv file and restarting DataStage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers