Reversing a Database (Dimensional Modeling)

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