Import OSS files to DataAgent

You can import Excel and CSV files from Alibaba Cloud Object Storage Service (OSS) into the DataAgent data center for analysis and processing, without re-uploading files that are already stored in OSS.

Prerequisites

DataAgent is activated.
The files to import are stored in an Alibaba Cloud OSS bucket in .xlsx, .xls, or .csv format.
You have created the custom user role CustomRoleForAliyunDataAgentAccessOss as described in Custom User Role Configuration to grant DataAgent the oss:GetObject permission.

Functionality

The data center supports the following actions:

Select a configured OSS bucket.
Browse and select Excel or CSV files from the bucket.
Import the selected files into the data center.
After import, DataAgent automatically analyzes and processes the file content.

Supported file formats

Format	Description
xlsx / xls	Microsoft Excel files
csv	Comma-separated values (CSV) files

Procedure

Log on to the DMS console.
In the top navigation bar, choose Data Agent > Data Center.
On the Data Center page, click OSS Files.
Select the target OSS bucket, then browse and select the files to import.

Note
Only .xlsx, .xls, and .csv files are displayed.
After you confirm the selection, DataAgent imports the files into the data center and automatically reads and analyzes their content.

Permission requirements

To read files from your OSS bucket, DataAgent requires the following minimum OSS permission:

RAM permission	Description
oss:GetObject	Reads file data and retrieves OSS download links.

The following example shows a permission policy for the China (Hangzhou) region:

{
  "Version": "1",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": [
        "oss:GetObject"
      ],
      "Resource": "acs:oss:oss-cn-hangzhou:${your-aliyun-parent-uid}:${your-oss-bucket-name}/*"
    }
  ]
}

Note

Replace ${your-aliyun-parent-uid} with the UID of your Alibaba Cloud primary account.
Replace ${your-oss-bucket-name} with the name of your OSS bucket.

For instructions on creating the custom role, see Configure DataAgent to use custom OSS storage.

Prerequisites

Functionality

Supported file formats

Procedure

Permission requirements

Related documents