Document Center

    AnalyticDB for MySQL

    • Release Notes
      • Announcements
      • Release notes
    • Product Introduction
      • What is AnalyticDB for MySQL?
      • Editions
      • Features
      • Benefits
      • Scenarios
      • Limits
      • Terms
    • Pricing
      • Billing methods and prices
      • Billing details about specifications changes
      • Impact of expiration and overdue payments
      • Renewal
    • Getting Started
      • Use AnalyticDB for MySQL
      • Create an Alibaba Cloud account
      • Create a cluster
      • Create a database account
      • Configure a whitelist
      • Connect to a cluster
      • Create a database
      • Import and query data
    • User's Guide
      • Instructions for new AnalyticDB for MySQL users
      • Database Connection
        • Apply for or release a public endpoint
        • Tool compatibility
          • Compatibility overview
          • Navicat Premium
          • DBeaver
          • DBVisualizer
          • SQL WorkBench/J
          • DataGrip
          • Superset
            • Test environment
            • Test scope
          • Oracle Golden Gate
          • Tableau
          • QlikView
          • Yonghong BI
          • FineBI 5.0
          • FineReport 10.0
          • Scriptella
        • 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
      • Storage plans
      • Data Warehouse Development
        • Use DataWorks to schedule AnalyticDB for MySQL tasks
        • Use Kettle to synchronize local data to AnalyticDB for MySQL
      • Data Visualization
        • FineBI
        • Yonghong BI
        • DataV
        • Tableau
        • QlikView
        • FineReport
        • Power BI
      • Cluster Management
        • Set a maintenance window
        • Resource pool overview
        • Manage resource pools
        • EIUs
        • Scale out resources
        • Query execution modes
        • Modify the configurations of an AnalyticDB for MySQL cluster
        • Delete a cluster
      • Materialized views
        • Overview
        • Create materialized views
        • Refresh materialized views
        • Manage materialized views
        • Query materialized views
        • Customer stories
          • Customer stories of materialized views
      • Data Security
        • Configure a whitelist
        • Configure SQL audit
      • 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
      • Backup And Recovery
        • Restore a cluster
        • View a backup set
      • Monitoring And Alerts
        • View monitoring information of resource pools
        • Set an alert rule
      • Tag management
        • Unbind a tag
        • Filter clusters by tag
        • Bind a tag
    • Developer‘s Guide
      • Welcome
        • Instructions for database developers
      • Data import and export
        • Supported data sources
        • Data base
          • Use DTS to Import Data
            • Use DTS to synchronize data from ApsaraDB RDS for MySQL to AnalyticDB for MySQL
            • Use DTS to synchronize data from DRDS instances
          • Import MySQL data to AnalyticDB for MySQL by using external tables
          • 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 Oracle connection
            • 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
          • Import OSS data to AnalyticDB for MySQL by using external tables
          • Export data to OSS by using external tables
        • Big data
          • Use DataWorks to import data from EMR
            • Configure an HDFS connection
            • Configure a MaxCompute connection
            • Configure an AnalyticDB for MySQL connection
            • Configure the source and destination connections for a synchronization task
          • Import MaxCompute data to AnalyticDB for MySQL
          • Use external tables to export data to MaxCompute partitioned tables
          • Flink AnalyticDB MySQL Connector
        • Message queues
          • Use Logstash to write Apache Kafka data to AnalyticDB for MySQL
            • Overview
            • Use Logstash to write Apache Kafka data to AnalyticDB for MySQL
        • Log data
          • Use Logstash to collect log data in real time
          • Use Log Service to transfer log data to AnalyticDB for MySQL
        • Local data
          • Use the LOAD DATA statement to import local data
        • Submit import or export tasks asynchronously
      • SQL manual
        • Basic data types
        • Complex Data Types
          • Array
          • Map
          • JSON
        • SQL offset table
          • DDL differences
          • DML differences
          • Differences in other SQL features
          • Unsupported data types and operators
        • Data definition statements
          • CREATE DATABASE
          • CREATE TABLE
          • CREATE RESOURCE GROUP
          • CTAS
          • ALTER TABLE
          • CREATE VIEW
          • DROP DATABASE
          • DROP TABLE
          • DROP VIEW
          • TRUNCATE TABLE
          • SHOW
        • Data manipulation statements
          • INSERT INTO
          • REPLACE INTO
          • ALTER RESOURCE GROUP
          • DROP RESOURCE GROUP
          • INSERT SELECT FROM
          • REPLACE SELECT FROM
          • INSERT OVERWRITE INTO SELECT
          • INSERT ON DUPLICATE KEY UPDATE
          • UPDATE
          • DELETE
          • KILL PROCESS
          • SHOW PROCESSLIST
        • Data query language
          • SELECT
            • Syntax
            • LIMIT
            • UNION, INTERSECT, and EXCEPT
            • WITH
            • GROUP BY
            • HAVING
            • JOIN
            • ORDER BY
            • Subqueries
          • Query users
          • CROSS JOIN
        • Data control language
          • CREATE USER
          • DROP USER
          • GRANT
          • RENAME USER
          • REVOKE
        • Data dictionary of the metadatabase
      • System Functions
        • Control flow functions
        • Numeric functions and operators
          • Arithmetic operators
          • Numeric functions
        • Date and time functions
        • String functions
        • Bit functions and operators
        • Geometry functions
          • Operation functions
          • Spatial relation functions
          • Accessor functions
          • Spatial constructor functions
        • JSON functions
        • Window functions
        • Aggregate functions
        • Encryption and compression functions
      • Query Performance Optimization
        • Query process
        • Query execution plans
          • Execution plan generation
          • Execution plan elements
          • Execution plan categories
          • Operators
          • Execute the EXPLAIN statement to query an execution plan
          • Use DMS to query an execution plan
        • Statistics and key metrics for queries
          • Query details page
          • VisualPlan
        • How to locate query performance issues
          • Slow query table
          • Slow query types
          • How to diagnose slow queries
        • Common issues and improvement measures
      • Query throttling configurations
      • API Reference
        • List of operations by function
        • Request structure
        • Request signatures
        • Common parameters
        • RAM authorization
        • Manage the service-linked role
        • Manage the service-linked role for disk encryption
        • Cluster management
          • CreateDBCluster
          • DescribeDBClusters
          • ModifyDBCluster
          • DeleteDBCluster
          • DescribeDBClusterAttribute
          • ModifyDBClusterMaintainTime
          • DescribeAutoRenewAttribute
          • ModifyAutoRenewAttribute
          • ModifyDBClusterDescription
          • DescribeAvailableResource
          • ModifyDBClusterResourceGroup
        • Manage Resource Pools
          • CreateDBResourcePool
          • DeleteDBResourcePool
          • DescribeDBResourcePool
          • ModifyDBResourcePool
          • BindDBResourcePoolWithUser
          • UnbindDBResourcePoolWithUser
        • Elastic Plan Management
          • CreateElasticPlan
          • DeleteElasticPlan
          • DescribeElasticDailyPlan
          • DescribeElasticPlan
          • ModifyElasticPlan
        • Database
          • DescribeTables
          • DescribeAllDataSource
          • DescribeSchemas
          • DescribeTableDetail
          • DescribeProcessList
          • DescribeColumns
          • DescribeTaskInfo
          • DescribeSQLPlan
          • DescribeSQLPlanTask
          • KillProcess
          • DescribeTablePartitionDiagnose
        • Log management
          • DescribeSlowLogRecords
          • DescribeSlowLogTrend
          • DescribeAuditLogConfig
          • ModifyAuditLogConfig
          • DescribeAuditLogRecords
        • Region management
          • DescribeRegions
        • Network management
          • AllocateClusterPublicConnection
          • DescribeDBClusterNetInfo
          • ReleaseClusterPublicConnection
          • ModifyClusterConnectionString
        • Account management
          • CreateAccount
          • DeleteAccount
          • DescribeAccounts
          • DescribeOperatorPermission
          • GrantOperatorPermission
          • ResetAccountPassword
          • RevokeOperatorPermission
          • ModifyAccountDescription
          • DescribeAllAccounts
        • Tag management
          • TagResources
          • ListTagResources
          • UntagResources
        • Backup and restoration
          • DescribeBackups
          • DescribeBackupPolicy
          • ModifyBackupPolicy
          • ModifyLogBackupPolicy
        • Security management
          • DescribeDBClusterAccessWhiteList
          • ModifyDBClusterAccessWhiteList
        • Monitoring management
          • DescribeDBClusterPerformance
          • DescribeDBClusterResourcePoolPerformance
          • DescribeInclinedTables
        • Appendixes
          • Cluster states
      • SDK Reference
        • SDK reference
      • Spark engine
        • Spark clusters
        • Airflow clusters
    • Best Practices
      • Schema design
      • Specifications for SQL development
      • Optimization of data changes
      • Advanced feature optimization
        • Nested loop join
        • Rewrite left join to right join
      • Query optimizers
        • STRAIGHT_JOIN
        • Persist plan and Query-Blocker
        • Explain & Explain Analyze
    • Case Studies
      • Biology
        • Genetic analysis of COVID-19
      • New retail
        • Flowerplus
      • Internet
        • Irobotbox
        • Keruyun
      • Finance
        • Lichu Saobei
      • Transportation and logistics
        • TusPass Beijing Technologies
    • Performance White Paper
      • Overview
      • Test description based on standard dataset
        • Test environments
        • Test procedure
        • Test method
        • Test metrics
        • Test results
      • Test description based on application scenarios
        • Query scenarios
        • Data import scenarios
      • Performance test guide
        • TPC-H Tests
          • Preparations
          • AnalyticDB for MySQL
          • Presto
          • Apache Spark
          • Construct data
          • Import data
          • TPC-H dataset
        • TPC-DS test
          • Preparations
          • Install TPC-DS tools
          • Construct data
          • AnalyticDB for MySQL
          • Import data
          • TPC-DS dataset
    • FAQ
      • Monitor the disk usage
      • Obtain the AccessKey pair of an account
      • Commonly asked questions about data synchronization when you use DTS
      • How can I view the version of an AnalyticDB for MySQL cluster?
 
All Products
Search
  • Document Center
  • AnalyticDB for MySQL
  • Developer‘s Guide
  • Data import and export
  • 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

    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: Import OSS data to AnalyticDB for MySQL by using external tables

    How helpful was this page?

    What might be the problems?

      More suggestions?

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