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 Configuring a Metadata Collection Task for details.

Importing a Table to a Model by Reversing the Database

1. On the DataArts Studio console, locate a workspace and click DataArts Architecture.
2. On the DataArts Architecture page, choose Models > Dimensional Modeling in the left navigation pane.
3. Click the dimension or table tab, select a dimension or table from the drop-down list, and click Reverse Database above the list.
   Figure 1 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 Configuring DataArts Studio Data Connection Parameters.
   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.
   Name Source	Source of the table name or field name after the reverse. The value can be Description or Name. If no description is specified for a table or field, the name is used. Description Name
   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.