DSXchange

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

Hi ,

You can import table definitions by

Go to DS Manager ===>Import ===>Table Definitions ===>Plug In Metadta Definitions.

Regards,
Suresh N

Hello,
When choosing the OCI9 plugin, i get the following

Unable to initialize plugin

Any idea to try and solve this problem?
Is it something i've not installed? or not parametered correctly?

Thanks for your help,
Stephane

stephaneG wrote:Is it something i've not installed? or not parametered correctly?

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.

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.

problem solved.
Thanks a lot for your help