DSXchange

We have jobs developed in DataStage7.5 using ORAOCI9 to connect to Oracle 9i database. Now, we are upgrading Oracle from 9i to 11g R2.

I would like to know whether DataStage7.5 and ORAOCI9 are compatible with Oracle 11g R2 or is there any work arounds?

Thanks

I would think it should work but you'll need to try it to see what issues, if any, you face. Stick with using your 9i Oracle client with the OCI9 stage to connect to the 11g instance.