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. On the Project tab, in the Configuration group, select Project Settings icon Project Settings.
  2. Select the Databases tab.
  3. In the Databases group, select Add icon Add.

    The Add New Database window is displayed.

  4. On the Add New Database window, and perform the following steps.
    1. Enter a Database Name.
    2. From the Database Type list, select Relational Database.
    3. Select OK.

    The relational database properties window is displayed.

  5. In the relational database properties window, configure the following settings.

    Setting

    Description

    Connection

    Select the relational connection that connects to the database.

    Table or View Name

    Once a database is configured and the connection string is successfully tested, a list of available tables and views is displayed.

    Select Refresh to open or update the data in the Table Records area below.

    Table Records

    This 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 relational database properties window closes.

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