Accesing oracle10g database in Datastage 7.5.2

dodda · Post by **dodda** » Fri Jul 31, 2009 5:20 am

Hi all,

I need some help regarding the accessing of Oracle10g database in Datastage 7.5.2

And my job is datastage serverjob. Can i use ORACLEOCI stage to access the Oracle10g database. or Any plug-in's i have tio install to access.

I appreciate your help.

chulett · Post by **chulett** » Fri Jul 31, 2009 5:24 am

Yes, you can use the OCI stage in a Server job to access 10g, that's what it is there for. The setup steps are documented - an Oracle client on the DataStage server and changes to your dsenv file are all you need.

dodda · Post by **dodda** » Fri Jul 31, 2009 7:09 am

Thanks for the reply.

Could you please provide the setup steps. And also give information about dsenv file.

chulett · Post by **chulett** » Fri Jul 31, 2009 8:03 am

As I said, it's documented. Refer to the Plug-In Installation and Configuration Guide pdf which is the InstConf.pdf in your Docs directory. There are also specific ones for the Oracle stages as well.