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
- 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
- On the DataArts Architecture page, choose in the left navigation pane.
- Click the Dimensions or Fact Tables tab. Then, click Reverse Database above the list.
Figure 2 Selecting an object
- 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.
- 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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.