Help Center/ DataArts Studio/ User Guide/ DataArts Architecture/ Common Operations/ Reversing a Database (Dimensional Modeling)
Updated on 2022-09-23 GMT+08:00

Reversing a Database (Dimensional 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 Studio console, locate an instance and click Access. On the displayed page, locate a workspace and click DataArts Architecture.

    Figure 1 DataArts Architecture

  2. On the DataArts Architecture page, choose Models > Dimensional Modeling in the left navigation pane.
  3. Click the Dimensions or Fact Tables tab. Then, click Reverse Database above the list.

    Figure 2 Selecting an object

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

    Table 1 Parameters for reversing a database

    Parameter

    Description

    Subject

    Select a subject from the drop-down list box.

    Data Connection Type

    Type of the database to reverse.

    Data Connection

    The name of the 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

    DWS or POSTGRESQL mode. This parameter is displayed only for DWS and POSTGRESQL data connections.

    Update Existing Table

    The import operation can be used to create a table or update an existing table. It does not delete a table.

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

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

  5. Click Yes to start reversing the database. After the operation is complete, you can view the result on the Last Reverse tab page or perform the reverse operation again.