Create an ODBC Connection

  1. In the Workflow Manager, click. Connections. .
  2. Select. Relational. from the list. The.
  3. Select. Type. as. ODBC.
  4. Click. New. . The.
  5. Configure the following relational connection properties: Relational Connection Property. Description. Name.
  6. Click. OK. .

How do I add an ODBC connection?

Add an ODBC data source

  1. Click Start, and then click Control Panel.
  2. In the Control Panel, double-click Administrative Tools.
  3. In the Administrative Tools dialog box, double-click Data Sources (ODBC).
  4. Click User DSN, System DSN, or File DSN, depending on the type of data source you want to add.
  5. Click Add.

How connect Postgres database to Informatica?

Configuring a PostgreSQL Connection

  1. In the Workflow Manager, click. Connections. Relational. . The. Relational Connection Browser.
  2. Click. New. . The. Relational Connection Editor.
  3. Enter a name for the PostgreSQL connection.
  4. Enter the PostgreSQL connection attributes.
  5. Click. OK. to create a PostgreSQL connection.

How do I access ODBC connection?

Click the Windows “Start” button and then click “Control Panel.” Click “System and Security.” Click “Administrative Tools” in the list of utilities. Double-click the icon labeled “Data Sources (ODBC).” A list of DSNs display.

What does ODBC stand for?

Open Database Connectivity
ODBC [Open Database Connectivity] [return to previous page] ODBC is a standard database access method developed by Microsoft Corporation.

What is ODBC connection in Informatica?

ODBC means Open Database Connectivity and it is a middle-ware or an interface that connects to various databases. In Informatica, ODBC connection is used to import source and target database table from database and add these source definitions to repository.

How do I create a new database connection in Informatica?

  1. Launch the Informatica Workflow Manager.
  2. Connect to the repository.
  3. Select Connections >Relational.
  4. Click Add, and then select ODBC.
  5. If your source database is on SQL Server, create a connection using the following values:
  6. If your target database is on SQL Server, create a connection using the following values:

How to create ODBC connection in Informatica?

Creating ODBC Connection Informatica ODBC connection for Source and Target can be made from System DSN tab, navigate to Start | Settings | Control panel | Administrative tools | Data sources (ODBC) | System DSN | Click on add for new connection.

How do I connect to ododbc?

ODBC connection for Source and Target can be made from System DSN tab, navigate to Start | Settings | Control panel | Administrative tools | Data sources (ODBC) | System DSN | Click on add for new connection.

How to create source ODBC connection in Oracle?

Creating source ODBC connection. To create new ODBC source connection, click on Add button. Select DataDirect 7.1 Oracle Wire protocol driver for which you want to set up a data source. Click on Finish button. Enter the following details to create new ODBC connection. Data Source Name : SCOTT_ODBC_Oracle.

How to add ODBC connection using DataDirect drivers?

Enter User ID. Test connection and enter username and password of the Oracle database as shown below. Finally click on Ok button. Informatica always recommends to use Datadirect drivers for importing the source and targets. To add ODBC connection using Datadirect drivers follow the steps given below.