Connect to Oracle Using Oracle Connection Manager from Informatica Developer

Connect to Oracle Using Oracle Connection Manager from Informatica Developer

Overview

Overview

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:
  1. Create a
    tnsnames.ora
    file in the Informatica Server and Client machines.
  2. Configure an Oracle connection with the TNS details to read from or write to Oracle from the Developer tool.

0 COMMENTS

We’d like to hear from you!