Introduction to Data Export
Main Features
Flexible Data Format Options
The data export function supports a variety of common data formats: CSV (comma-separated value), SQL, TXT, and JSON files. You can select the format that best suits your workflow as per your needs.
Multiple Export Types
You can select Full Table or SQL Result Sets for export. Alternatively, you can enter SQL statements or query statements for custom export, so that only the data you need is exported. This avoids unnecessary information redundancy.
Large-Scale Data Export
To ensure high-efficiency and high-quality data export, a maximum data amount of one million rows is supported. For MongoDB/DDS data sources, up to 100,000 rows of data can be exported.
User-Friendly Interface
The user interface of the data export function is designed to be simple and intuitive, making it easy to use, even if you do not have technical expertise.
Application Scenarios
• Business reporting and analysis: By exporting data, you can generate comprehensive business reports and perform data analysis, providing management with the basis for decision-making.
• Data migration: When changing systems or platforms, data export can help you migrate your old data to the new system.
• Data backup: The data is exported to a readable format as an emergency backup, safeguarding against data loss.
• Data sharing and cooperation: After data export, you can share data with partners or teams, fostering collaboration and driving project progress
• Data analysis and mining: Exporting data to an analytic tool helps you gain deeper insight into your data and uncover potential patterns and ideas.
Submitting Export Tasks
Prerequisites
• You have obtained permission to export the target database.
• When the organization is in the Basic Version, make sure that the target database has been logged in.
Procedure
1. Log in to the DMS Console.
2. On the left navigation bar, click Development Space > Data Export to go to the Data Export Management page.
3. Click the Data Export button, and the page for filling Data Export order appears. See Table 1 below for the content to be input in the order.
4. After filling out the data import order, click the Assess button to evaluate the current export task. The estimated number of exported rows and the estimated time required for export are provided for reference only.
5. Click the Submit button to finish creating the data export order.
6. When the organization is in the Basic Version, the data export task enters the task execution stage.
7. When the organization is in the Enterprise Version, the data export order enters the pre-check, approval process, and task execution stages in sequence.
Table 1 Description of Order Inputs
Input | Description |
Database/Schema | The database/schema selection list. The data comes from database instances added in Data Source Management > Instance Metadata. The supported database types include MySQL, PostgreSQL, SQLServer, DRDS, MongoDB, and DDS.
|
Export Type | For non-MongoDB and DDS data sources, Full Table or SQL Result Sets can be selected. If Full Table is selected, you need to select the table; if SQL Result Sets is selected, you need to enter the SQL query statements. For MongoDB and DDS data sources, you can select either Set Export or Query Result Set Export. If Set Export is selected, you need to select the set; if Query Result Set Export is selected, you need to enter a find-type statement. |
Export File Type | CSV (comma-separated values), SQL, TXT, and JSON are supported. You can select the format that best suits your workflow as per your needs. |
Order Description | Please enter the order description. |
² Note
When the SQL statement involves only one table, and the table is global or there is no primary key condition in where, DRDS defaults to returning a maximum number of 1,000 rows. This attribute is controlled by the sqlMaxLimit parameter, which can be modified in the DRDS console.
Data Export Order List
Prerequisites
Log in to the DMS Console.
Precautions
The Data Export Order List page displays only the orders that you have submitted.
Procedure
1. Log in to the DMS.
2. On the left navigation bar, click Development Space > Data Export to go to the Data Export Order List page.
Function Introduction to the Data Export Order List Page
Order Query
Enter the query condition and click the Query button for the query.
Data Export
Click the Data Export button to add a new data export task
Details
Locate the target order in the order list and click the Details button in the Operate column. On the opened Order Details page, you can view the details of the target order.
The Data Export Order List page contains four sections: basic information, task status, pre-check, and approval process.
Basic Information
The table below describes the Basic Information section:
Content
Description
Order Type
Displays the data export type of the order.
Creator
Displays the user who created the order.
Order Status
Displays the current order status.
Order Number
Displays the unique ID generated by the system for the order.
Create Time
Displays the time the order was saved to the system.
Last Operation Time
Displays the last time the order status was updated.
Database/Schema Information
Displays the target database/schema information corresponding to the export task.
Export Type
Displays the type designated by the export order, which can be selected when creating an export order.
Table Name
Displays the database table name designated by the export order, which can be selected when creating an export order.
Export File Type
Displays the file type designated by the export order, which can be selected when creating an export order.
Order Description
Displays the description information, which can be filled in when creating an export order.
Task Status
Displays the status and execution time of the data export task. The status includes created, successful execution, execution in progress, and execution failure. When a task execution fails, you can click 
on the failed task to see the reason for the failure.
Pre-check
Displays the pre-check details for the data export order, including connection check and permission check.
Approve
Displays the approval process details for the data export order. When the organization is in the Basic Version, after you submit a data export order, the data export task will be executed directly without going through the approval process. As such, no approval process information is required to be displayed. When the organization is in the Enterprise Version, after you submit the data export order, it needs to go through a preset approval process before executing the data export task. As such, the specific approval process information will be displayed.
Retry
For abnormal orders, you can select whether to retry based on the reason for the abnormality. If required, click the Retry button to retry.
Download
When the order status is completed, the Download button appears. Click it to download the order. When you hover your mouse over the Download button, you can view the real-time download progress.
² Note
Once the file is exported, it remains valid for 24 hours. Make sure that you download it within this validity period.