Batch import objects for Intelligent Data Modeling - DataWorks

Use the Batch Import tool in Intelligent Data Modeling to create multiple objects at once — data models, Data Standards, and more — by uploading a filled-in Excel template. This eliminates the need to create objects one by one.

Prerequisites

Before you begin, make sure you have:

Access to DataWorks Intelligent Data Modeling
An .xlsx file prepared according to the downloaded template

Limitations

Supported file format: .xlsx only
Maximum records per import task: 30,000
Maximum file size: 10 MB

Go to the import page

Log on to the DataWorks console. In the top navigation bar, select a region. In the left-side navigation pane, choose Data Development and O&M > Data Modeling. Select your workspace from the drop-down list and click Go to Data Modeling.
On the Data Modeling page, click General Tools in the top navigation bar. The Import Tasks page appears. From here, create a new import task or manage existing ones.

Create an import task

Note

The UI for creating an import task varies by object type. The steps below use a data domain import as an example.

On the Import Tasks page, click Create Import Task.
On the Confirm Import Type tab, select the object type to import. Download the corresponding template, and fill it in according to your data. After selecting a type, click Preview to see which fields are required before downloading.

On the Data Import tab, upload your filled-in .xlsx file and preview the data. To spot naming conflicts before committing, filter the preview to show only objects whose names already exist in DataWorks. Configure the following options based on your import type:

Import Mode: Controls what happens when an object in the file has the same name as an existing object in DataWorks.

Option	Behavior
Overwrite	Replaces the existing object with the imported one
Skip	Leaves the existing object unchanged and skips the duplicate

Import Status:

Value	Behavior
Import and Save	Imports and saves the data without creating a new version
Import and Submit	Imports the data and submits it as a new version

Note

The available Import Mode and Import Status options depend on the selected import type. Not all options appear for every object type.

导入数据

On the OK tab, review the import results. Click View More Details next to a Data Domain to open its edit page. If the import failed, check the error details, fix the issues in your file, and retry the import.

Manage import tasks

On the Import Tasks page, view and filter all past import tasks.

Area	Description
1	Filter tasks by creation date, type, or Creator.
2	View each task's status, the number of successfully imported objects, and the total number of objects in the task. Click View Details for the full task breakdown.

Import Status values:

Succeeded — all objects in the task were imported successfully.
Failed — all objects failed to import. Check the error details to identify the cause.
Partially Successful — some objects failed. If the succeeded count is lower than the total, either some objects failed or duplicates were set to Skip in Import Mode.

Next steps

After the import completes, go to the pages of the imported objects to continue development.