If you are trying to connect DataStage 64bit on Windows to Oracle Database 64bit you probably get error message like this:
|
1 2 |
DataStage was unable to attach to this connector. Error loading connector library ccora11g.dll. %1 is not a valid Win32 application. |
I assume that you have done all prerequisites like set up the environment variables etc. More about prerequisites for Oracle connector in DataStage V11.3 you can find here http://ibm.co/1mu4WGo
This error message you are getting because the DataStage Engine (even in version 11.3) is still 32bit application on Windows. That means, you have to install the 32bit Oracle client and connect to Oracle DB with it. Oracle client have to be installed on the same host as DataStage Engine.