Import tables definition using OCI

stephaneG · Post by **stephaneG** » Wed Nov 08, 2006 4:19 am

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

suresh.narasimha · Post by **suresh.narasimha** » Wed Nov 08, 2006 5:14 am

Hi ,

You can import table definitions by

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

Regards,
Suresh N

stephaneG · Post by **stephaneG** » Wed Nov 08, 2006 5:31 am

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

chulett · Post by **chulett** » Wed Nov 08, 2006 8:07 am

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.

stephaneG · Post by **stephaneG** » Wed Nov 08, 2006 9:05 am

problem solved.
Thanks a lot for your help