DataArts Architecture Data Migration

Constraints

• Before importing tables/entities in ER modeling, and dimensions, fact tables, and summary tables in dimensional modeling, ensure that a data connection has been created in Management Center and is available.
• Time filters, and data in the Review Center and Configuration Center cannot be imported or exported. You must synchronize them manually before migrating other data.
• You can import a file as large as 4 MB and export a maximum of 500 tables at a time.

Exporting Table Data from the Old Workspace

Log in to the console, access the DataArts Architecture module of the old workspace, and perform the following operations to export processes, subjects, lookup tables, data standards, ER modeling tables/entities, dimensions/fact tables, business metrics, technical metrics, and summary tables.

Exporting processes

1. On the DataArts Architecture page, choose Processes in the left navigation pane.
2. Click Export above the list to export all processes. After the export is successful, you can obtain the exported .xlsx file.
   Figure 1 Exporting processes
   

Exporting subjects

1. On the DataArts Architecture page, choose Subjects in the left navigation pane.
2. Click Export above the list to export all subjects. After the export is successful, you can obtain the exported .xlsx file.
   Figure 2 Exporting subjects
   

Exporting Lookup Tables

1. On the DataArts Architecture page, choose Lookup Tables in the left navigation pane.
2. Select the lookup tables to export, click More above the list, and select Export from the drop-down list box to export the selected lookup tables. After the export is successful, you can obtain the exported .xlsx file.
   Figure 3 Exporting lookup tables
   

Exporting Data Standards

1. On the DataArts Architecture page, choose Data Standards in the left navigation pane.
2. Select the data standards to export, click More above the list, and select Export from the drop-down list box to export the selected data standards. After the export is successful, you can obtain the exported .xlsx file.
   Figure 4 Exporting data standards
   

Exporting ER modeling tables/entities

1. On the DataArts Architecture page, choose ER Modeling in the left navigation pane.
2. Access a logical or physical model and export tables/entities in the model. This section uses logical model demo as an example.
   Figure 5 Accessing the model
   

3. Select the tables/entities to export, click More above the list, and select Export from the drop-down list box (you are advised to select Table for Export). After the export is successful, you can obtain the exported .xlsx file.
   Figure 6 Exporting ER modeling tables/entities
   

4. In the subject list, select other models and repeat Step 3 to download tables/entities of other models.
   Figure 7 Exporting tables/entities of other models
   

Exporting dimensions/fact tables

1. On the DataArts Architecture page, choose Dimensional Modeling in the left navigation pane.
2. On the displayed Dimensions page, select the dimensions to export, click More above the list, and select Export from the drop-down list box. After the export is successful, you can obtain the exported .xlsx file.
   Figure 8 Exporting dimensions
   

3. Click the Fact Tables tab, select the fact tables to export, click More above the list, and select Export from the drop-down list box to export the selected fact tables. After the export is successful, you can obtain the exported .xlsx file.
   Figure 9 Exporting fact tables
   

Exporting business metrics

1. On the DataArts Architecture page, choose Business Metrics in the left navigation pane.
2. Select the business metrics to export, click More above the list, and select Export from the drop-down list box to export the selected metrics. After the export is successful, you can obtain the exported .xlsx file.
   Figure 10 Exporting business metrics
   

Exporting technical metrics

1. On the DataArts Architecture page, choose Technical Metrics in the left navigation pane.
2. Click the Atomic Metrics, Derivative Metrics, and Composite Metrics tab, respectively, select the metric to be exported, click More in the Operation column, and select Export. After the export is successful, you can obtain the exported .xlsx file.
   Figure 11 Exporting technical metrics
   

Exporting summary tables

1. On the DataArts Architecture page, choose Dimensional Modeling in the left navigation pane.
2. Click the Summary Tables tab, select the summary tables to export, click More above the list, and select Export from the drop-down list box to export the selected summary tables. After the export is successful, you can obtain the exported .xlsx file.
   Figure 12 Exporting summary tables
   

Importing Table Data to the New Workspace

Log in to the console, access the DataArts Architecture module of the new workspace, and perform the following operations to import processes, subjects, lookup tables, data standards, ER modeling tables/entities, dimensions/fact tables, business metrics, technical metrics, and summary tables.

Importing processes

1. On the DataArts Architecture page, choose Processes in the left navigation pane.
2. Click Import above the list. In the displayed dialog box, select and upload the process file to import.
   Figure 13 Import processes
   

3. After the file is uploaded, the system automatically starts importing it. After the file is imported, the import result is displayed.
   Figure 14 Successful process import
   

Importing subjects

1. On the DataArts Architecture page, choose Subjects in the left navigation pane.
2. Click Import above the list. In the displayed dialog box, select and upload the subject file to import.
   Figure 15 Importing subjects
   

3. After the file is uploaded, the system automatically starts importing it. After the file is imported, the import result is displayed.
   Figure 16 Successful subject import
   

4. After the import is successful, click Publish. The subject status will change to Published.

Importing lookup tables

1. On the DataArts Architecture page, choose Lookup Tables in the left navigation pane.
2. Click More above the list and select Import from the drop-down list box. In the displayed dialog box, select and upload the lookup table file to import.
   Figure 17 Importing lookup tables
   

3. After the file is uploaded, the system automatically starts importing it. After the file is imported, the import result is displayed.
   Figure 18 Successful import of lookup tables
   

4. After the import is successful, click Publish. The lookup table status will change to Published.

Importing data standards

1. On the DataArts Architecture page, choose Data Standards in the left navigation pane.
2. If you access the Data Standards page for the first time, you will be prompted to customize the data standard template. Edit the data standard template for the new workspace by referring to the Standard Templates page of Configuration Center in the old workspace, and then click OK.
3. Click More above the list and select Import from the drop-down list box. In the displayed dialog box, select and upload the data standard file to import.
   Figure 19 Importing data standards
   

4. After the file is uploaded, the system automatically starts importing it. After the file is imported, the import result is displayed.
   Figure 20 Successful import of data standards
   

5. After the import is successful, click Publish. The lookup table status will change to Published.

Importing ER modeling tables/entities

1. On the DataArts Architecture page, choose ER Modeling in the left navigation pane.
2. If no ER model has been created, a dialog box is displayed, asking you to create a hierarchical governance model. Create an SDI and a DWI model for the new workspace by referring to the ER Modeling page of the old workspace, and then click OK.
   Figure 21 Creating a hierarchical governance model
   

3. If a logical model has been created in the old workspace, click to create a logical model in the new workspace.
   Figure 22 Creating a logical model
   

4. Access a logical or physical model to import tables/entities to the model. This section uses logical model demo as an example.
   Figure 23 Accessing the model
   

5. Click More above the list and select Import from the drop-down list box. In the displayed dialog box, select and upload the table/entity file to import.
   Figure 24 Importing ER modeling tables/entities
   

6. After the file is uploaded, the system automatically starts importing it. After the file is imported, the import result is displayed.
   Figure 25 Successful import of ER modeling tables/entities
   

7. In the subject list, select other models and repeat Step 5 to Step 6 to import tables/entities to other models.
   Figure 26 Importing tables/entities to other models
   

8. After the import is successful, click Publish. The lookup table status will change to Published.

Importing dimensions/fact tables

1. On the DataArts Architecture page, choose Dimensional Modeling in the left navigation pane.
2. On the displayed Dimensions page, click More above the list and select Import from the drop-down list box. In the displayed dialog box, select and upload the dimension file to import.
   Figure 27 Importing dimensions
   

3. After the file is uploaded, the system automatically starts importing it. After the file is imported, the import result is displayed.
   Figure 28 Successful dimension import
   

4. Click the Fact Tables page, click More above the list, and select Import from the drop-down list box. In the displayed dialog box, select and upload the fact table file to import.
   Figure 29 Importing fact tables
   

5. After the file is uploaded, the system automatically starts importing it. After the file is imported, the import result is displayed.
   Figure 30 Successful import of fact tables
   

6. After the import is successful, click Publish. The lookup table status will change to Published.

Importing business metrics

1. On the DataArts Architecture page, choose Business Metrics in the left navigation pane.
2. Click More above the list and select Import from the drop-down list box. In the displayed dialog box, select and upload the business metric file to import.
   Figure 31 Importing business metrics
   

3. After the file is uploaded, the system automatically starts importing it. After the file is imported, the import result is displayed.
   Figure 32 Successful import of business metrics
   

4. After the import is successful, click Publish. The lookup table status will change to Published.

Importing technical metrics

1. On the DataArts Architecture page, choose Technical Metrics in the left navigation pane.
2. Click the Atomic Metrics, Derivative Metrics, and Compound Metrics tab, respectively. Click More and select Import. In the displayed dialog box, select and upload a technical metric file.
   Figure 33 Importing technical metrics
   

3. After the file is uploaded, the system automatically starts importing it. After the file is imported, the import result is displayed.
   Figure 34 Successful import of technical metrics
   

4. After the import is successful, click Publish. The lookup table status will change to Published.

Importing summary tables

1. On the DataArts Architecture page, choose Dimensional Modeling in the left navigation pane.
2. Click the Summary Tables page, click More above the list, and select Import from the drop-down list box. In the displayed dialog box, select and upload the summary table file to import.
   Figure 35 Importing summary tables
   

3. After the file is uploaded, the system automatically starts importing it. After the file is imported, the import result is displayed.
   Figure 36 Successful import of summary tables
   

4. After the import is successful, click Publish. The lookup table status will change to Published.

Verifying the Migration

Check whether the models and table data imported to the new workspace are consistent with those in the old workspace. If they are consistent, the migration is successful.