Document Center

    AnalyticDB for MySQL

    • Release Notes
      • Announcements
      • Release notes
    • Product Introduction
      • What is cloud-native data warehouse for MySQL
      • Scenarios
      • Benefits
      • Editions
        • Cluster Edition
        • Specifications
      • Features
      • Terms
    • Solutions
      • Real-time BI analytics for the Internet, e-commerce, and gaming industries
    • Pricing
      • Billing methods
      • Billing details about specifications changes
      • Impact of expiration and overdue payments
      • Renewal
    • Welcome
      • Instructions for new AnalyticDB for MySQL users
      • Instructions for database developers
    • Quick Start
      • Limits
      • Create an AnalyticDB for MySQL cluster
      • Configure a whitelist
      • Create a database account
      • Create a database
      • Apply for or release a public endpoint
      • Connect to a cluster
      • Synchronize data
    • Billing Management
      • Change the billing method from pay-as-you-go to subscription
      • Manually renew an AnalyticDB for MySQL cluster
      • Automatically renew an AnalyticDB for MySQL cluster
    • Cluster Management
      • Set a maintenance window
      • Delete a cluster
    • Account And Permission Management
      • Account types
      • Permission model
      • Database accounts and permissions
      • RAM users and permissions
      • Authorize the service account
      • Reset the password of a privileged account
    • Database Connection
      • Tool compatibility
        • Compatibility overview
        • Navicat Premium
        • DBeaver
        • DBVisualizer
        • SQL WorkBench/J
        • DataGrip
        • Superset
          • Test environment
          • Test scope
        • Oracle Golden Gate
      • Use the MySQL command-line tool to connect to AnalyticDB for MySQL
      • Use a business system to connect to AnalyticDB for MySQL
        • Java
        • Druid connection pool
        • Python
        • PHP
        • C# for macOS
        • Go
      • Use a client to connect to AnalyticDB for MySQL
        • DBeaver
        • Navicat
        • SQL WorkBench/J
        • DBVisualizer
      • Enable PrepareStatement for a client in different programming languages
    • Backup And Recovery
      • Restore a cluster
      • View a backup set
    • Data Integration
      • Data base
        • Use DTS to synchronize data from ApsaraDB RDS for MySQL
        • Use DTS to synchronize data from DRDS instances
        • Use external tables to import data from or export data to MySQL
          • Import MySQL data to AnalyticDB for MySQL
          • Export data from AnalyticDB for MySQL to MySQL
        • Use DataWorks to synchronize data from ApsaraDB RDS for MySQL
          • Overview
          • Configure an ApsaraDB RDS for MySQL connection
          • Configure an AnalyticDB for MySQL connection
          • Configure the source and destination connections for a synchronization task
        • Use DataWorks to synchronize data from Oracle
          • Configure an Oracle connection
          • Configure an AnalyticDB for MySQL connection
          • Configure the source and destination connections for a synchronization task
        • Use DataWorks to synchronize SQL Server data
          • Configure an SQL Server connection
          • Configure an AnalyticDB for MySQL connection
          • Configure the source and destination connections for a synchronization task
      • OSS
        • Use DataWorks to import data from OSS
          • Configure an OSS connection
          • Configure an AnalyticDB for MySQL connection
          • Configure the source connection and destination connection for a synchronization task
        • Use external tables to import data from or export data to OSS
          • Export data from AnalyticDB for MySQL to OSS
          • Import data from OSS to AnalyticDB for MySQL
      • Big data
        • Use DataWorks to import data from Apache Hadoop
          • Configure an HDFS connection
          • Configure an AnalyticDB for MySQL connection
          • Configure the source and destination connections for a synchronization task
        • Use DataWorks to import data from EMR
          • Configure an AnalyticDB for MySQL connection
          • Configure the source and destination connections for a synchronization task
          • Configure an HDFS connection
        • Use DataWorks to import MaxCompute data
          • Configure a MaxCompute connection
          • Configure an AnalyticDB for MySQL connection
          • Configure the source and destination connections for a synchronization task
        • Use external tables to import or export MaxCompute data
          • Import MaxCompute data to AnalyticDB for MySQL
      • Log data
        • Use Logstash to collect log data in real time
      • Local data
        • Use the LOAD DATA statement to import local data
      • Submit import or export tasks asynchronously
    • Data Security
      • Configure a whitelist
      • Configure SQL audit
    • Data Warehouse Development
      • Use DataWorks to schedule AnalyticDB for MySQL tasks
      • Use Kettle to synchronize local data to AnalyticDB for MySQL
    • Data Visualization
      • FineBI
      • Quick BI
      • Yonghong BI
      • DataV
      • Tableau
      • QlikView
      • FineReport
      • Power BI
    • Monitoring And Alerts
      • Set an alert rule
    • Performance Test
      • TPC-H tests
        • Preparations
        • Create TPC-H OSS external tables
        • Create TPC-H tables
        • Import data
        • Query data
    • Best Practices
      • Schema design
      • Write, update, delete, and import data
      • Best practices for traffic control
      • SQL statement optimization
      • Advanced feature optimization
    • SQL Manual
      • Data types
      • Multi-value column
      • Data definition statements
        • CREATE DATABASE
        • CREATE TABLE
        • ALTER TABLE
        • Full-text search
        • CREATE VIEW
        • DROP DATABASE
        • DROP TABLE
        • DROP VIEW
      • Data manipulation statements
        • INSERT INTO
        • REPLACE INTO
        • INSERT SELECT FROM
        • REPLACE SELECT FROM
        • INSERT OVERWRITE INTO SELECT
        • UPDATE
        • DELETE
        • TRUNCATE TABLE
        • SHOW PROCESSLIST
        • KILL PROCESS
      • SELECT
        • Syntax
        • WITH
        • GROUP BY
        • HAVING
        • JOIN
        • LIMIT
        • ORDER BY
        • Subqueries
        • UNION, INTERSECT, and EXCEPT
      • CREATE USER
      • GRANT
      • REVOKE
      • Query users
      • RENAME USER
      • DROP USER
      • SHOW
      • JSON
    • System Functions
      • Geometry functions
      • JSON functions
      • Bit functions and operators
      • Date and time functions
      • Arithmetic operators
      • String functions
      • Variable-length binary functions
      • Aggregate functions
      • Control flow functions
      • Window functions
      • Numeric functions
    • Performance White Paper
      • Overview
      • Test methods
        • Test environments
        • Test scenarios
        • Test method
        • Test metrics
      • Test results
      • Performance test guide
        • Build data structures
          • AnalyticDB for MySQL
          • MySQL
          • Presto
          • Apache Spark
          • Apache Impala
        • Initialize data
          • Construct data
          • Import data
        • TPC-H dataset
    • FAQ
      • Monitor the disk usage
      • Commonly asked questions about data synchronization when you use DTS
      • Obtain the AccessKey pair of an account
    • API Reference
      • List of operations by function
      • Request syntax
      • Signature method
      • Common parameters
      • RAM authorization
      • Cluster management
        • DescribeDBClusters
        • DescribeDBClusterAttribute
        • ModifyDBClusterMaintainTime
        • DescribeAutoRenewAttribute
        • ModifyAutoRenewAttribute
        • ModifyDBClusterDescription
      • Log management
        • DescribeSlowLogRecords
        • DescribeSlowLogTrend
      • Region management
        • DescribeRegions
      • Network management
        • AllocateClusterPublicConnection
        • DescribeDBClusterNetInfo
        • ReleaseClusterPublicConnection
      • Account management
        • CreateAccount
        • DeleteAccount
        • DescribeAccounts
        • DescribeOperatorPermission
        • GrantOperatorPermission
        • ResetAccountPassword
        • RevokeOperatorPermission
      • Backup and recovery
        • DescribeBackupPolicy
        • DescribeBackups
      • Security management
        • DescribeDBClusterAccessWhiteList
        • ModifyDBClusterAccessWhiteList
      • Monitoring management
        • DescribeDBClusterPerformance
      • Appendix
        • Cluster status
    • SDK Reference
      • SDK reference
 
All Products
Search
  • Document Center
  • AnalyticDB for MySQL
  • Data Integration
  • OSS
  • Use DataWorks to import data from OSS
  • Configure the source connection and destination connection for a synchronization task

This Product

  • This Product
  • All Products

    Configure the source connection and destination connection for a synchronization task

    Document Center
    Download PDF

    Configure the source connection and destination connection for a synchronization task

    Last Updated: May 20, 2020

    To synchronize data from OSS to AnalyticDB for MySQL, you can follow the steps for configuring synchronization tasks.

    For more information, see Use DataWorks to synchronize data from ApsaraDB RDS for MySQL.

    Previous: Configure an AnalyticDB for MySQL connection Next: Export data from AnalyticDB for MySQL to OSS

    How helpful was this page?

    What might be the problems?

      More suggestions?

      Thank you! We've received your feedback.
      Free Trial Free Trial