Welcome > Use the Transformation Designer > Manage Databases > Relational Databases > Create a Relational Database

Create a Relational Database

After you have created a relational connection, you can set up the database.

  1. Open the Add New Database 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 Databases, click Add.
  2. Start creating the database by following these steps:
    1. In the Database Name field, type a name to identify the database.
    2. In the Database Type group, select Relational Database.
    3. Click OK.

      The Properties window for the database appears.

  3. In the Connection field, select the relational connection that connects to the database.
  4. In the Table or View Name field, select the table or view you want from the list.
  5. Click Refresh to open or update the data in the Table Records area below.

    The Table Records area provides a read-only preview of the first 50 records of the referenced table or view.

    Note If there is a problem with either the Connection or the Table or View Name, an error icon Database error icon displays. Hovering over the icon provides more information about the specific error.
  6. Click OK to accept the changes.

    The Properties window for the database closes.

  7. Optionally, click OK to close the Project Settings window.
  8. Save the changes to your project.