Updated on 2022-09-23 GMT+08:00

Reversing a Database (ER Modeling)

You can import tables from databases of other data sources to a specific ER model.

Prerequisites

You have collected metadata from databases in DataArts Catalog so that the system can synchronize tables to DataArts Catalog later. Otherwise, the synchronization tasks may fail. See Task Management for details.

Importing a Table to a Model by Reversing the Database

  1. On the DataArts Architecture page, choose Models > ER Modeling in the left navigation pane.
  2. On the model overview page, locate the target model, click the model card, and click Reverse Database in the upper part.

    Figure 1 Reverse Database dialog box

  3. In the Reverse Database dialog box, set the parameters.

    Figure 2 Setting parameters for reversing the database
    Table 1 Parameters for reversing a database

    Parameter

    Description

    Subject

    Select a subject from the drop-down list box.

    Data Connection Type

    If you reverse tables to a logical model, select a required data connection type from the drop-down list box.

    If you reverse tables to a physical model, the data connection type of the current model is displayed.

    Data Connection

    The name of the data connection. Select the required data connection.

    If you want to reverse a database from other data sources to an ER model, you must create a data connection in Management Center to connect to the data source. For details on how to create data connections, see Creating Data Connections.

    Database

    The name of the database. Select a database from the drop-down list box.

    Queue

    This parameter is displayed only for DLI data connections. Select a DLI queue.

    Schema

    This parameter is displayed only for DWS data connections.

    Update Table

    Whether to update the existing table if the table to be imported already exists in the ER model. When a table is imported, the system checks whether the table exists according to the table code. During the import, only table creation and update are allowed.

    • No: If you select this option, the existing tables will not be updated.
    • Yes: If you select this option, the existing tables will be updated. If a table is in the Published state, you must publish the table again after updating it so that the updated table can take effect.

    Data Table

    If you select All, all tables in the database are imported to the ER model.

    If you select Partial, not all tables in the database are imported to the ER model.

  4. Click Yes to start reversing the database.