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

Create a relational database

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

Before you begin

Before you can create a relational database, verify that you have created a relational connection.

Procedure

  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. Select the Databases tab to view the databases settings.
    3. Under Databases, select Add.
  2. Start creating the database by following these steps:
    1. In the Database Name field, enter a name to identify the database.
    2. In the Database Type group, select Relational Database.
    3. Select OK.

      The Properties window for the database is displayed.

  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. Select 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.

    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. Select OK to accept the changes.

    The Properties window for the database closes.

  7. Optional. Select OK to close the Project Settings window.
  8. Save the changes to your project.

More info