You can use Oracle Connection Manager to connect to an Oracle database from Informatica Developer.
Oracle Connection Manager is a network solution that serves as an intermediate server or proxy server that forwards connection requests to the Oracle database servers or to other proxy servers. Oracle Connection Manager offers multiple network solutions, including increased scalability, simplified access control, and improved availability.
This article describes the following tasks that you must perform to configure connectivity to Oracle using Oracle Connection Manager from the Developer Tool:
Create a
tnsnames.ora
file in the Informatica Server and Client machines.
Configure an Oracle connection with the TNS details to read from or write to Oracle from the Developer tool.