› Use Transformation Designer › Manage databases › Relational databases › Create a connection to a relational database

Create a connection to a relational database

Use the procedure in this topic to create a connection to a relational database.

The first step in setting up a relational database is to set up the connection. After creating the connection, a Configure window is displayed where you set up the connection to the server and database, including authentication.

Procedure

  1. Open the Add New Connection window by following these steps:
    1. On the Project tab, in the Configuration group, select Project Settings Project Settings icon.
    2. Select the Databases tab to view the databases settings.
    3. Under Relational Connections, select Add.
  2. In the "Select a connection type" field, select the type of relational database you are using:

    • Microsoft SQL Server

    • ODBC

    • Oracle

  3. In the Name field, enter a name to identify the connection.
  4. Select OK.

    The Configure Connection window for the type of database you selected is displayed.

More info