I was wondering if I can run a job to execuse an AIX script from ODI. I was looking thru ODI Utilitiies "OdiOSCommand" and "OS Command" - But, I couldn't see where to specify the Server Name. I do see the "Command to Execute" which is good, but I need to tell it which server this command resides in. Unless there is another ODI utility I can use..?
1.) You will need to create an agent on the AIX box on which the script needs to be executed.
2.) If thats not possible, then on the machine on which the "agent" is deployed, the script should live. This script should then ssh/rsh into the AIX box in question and execute it there.
I can confirm second option to work i.e. for Sun Solaris.
We are using an ODI Agent on a Windows box and are calling putty's plink.exe to connect and run a *.sh on the Solaris box. Just make sure you first connect manually with the same windows user under which the Agent's-Windows-Service is running to accept SSH connection first (key).