IBM Support

Oracle Wallet support for IBM InfoSphere Information Server

Question & Answer


Question

You do not use OS Authentication but an Oracle Wallet (the Oracle security connection from Oracle version 10), the difference can be significant since, in OS Authentication, you set ORACLE_SID, and then just run sqlplus / in wallet : you have to include your instance and run sqlplus /@mydev You are using the Oracle Wallet in Oracle 10g because, in Oracle 11g, OS Authentication will be obsolete. However, there is a requirement to secure the username and password for the Oracle connection. The desired approach is to use the "OS Authentication" for the Oracle connection and, therefore, you do not need to provide the username or password for the Oracle connection. The above, referenced in the Connectivity Guide for Oracle, is for the Oracle OCI stage for server jobs only. How can you get the same functionality for parallel jobs?

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.5;8.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 April 2025

UID

swg21410953

Page Feedback