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 appears where you set up the connection to the server and database, including authentication.

  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. Click the Databases tab to view the databases settings.
    3. Under Relational Connections, click 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, type a name to identify the connection.
  4. Click OK.

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