Document Center

    AnalyticDB for MySQL

    • Notifications
      • [Notice] Announcement of free extension of backup set retention period
    • Release Notes
      • Release notes
      • Announcements
    • Product Introduction
      • What is AnalyticDB for MySQL?
      • Editions
      • Features
      • Benefits
      • Scenarios
      • Customer Case
        • Transportation and logistics
          • Intelligent urban public transportation system built based on AnalyticDB for MySQL
        • Internet
          • Keruyun precision marketing solution
          • Fine-grained advertisement management solution for Irobotbox
          • Real-time BI analytics for the Internet industry
        • New retail
          • AnalyticDB for MySQL empowers Flowerplus business development
        • Finance
          • Aggregate payment solution
      • 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 an AnalyticDB for MySQL 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
          • Smartbi
        • 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
      • Separation of hot and cold data storage
      • 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
        • Smartbi
      • 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
          • Success story I
          • Success story II
          • Success story III
          • Success story IV
      • 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
        • View a backup set
        • Restore a cluster
      • 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
      • Data modeling optimization
      • Daily health reports
    • Developer‘s Guide
      • Welcome
        • Instructions for database developers
        • Prerequisites
      • 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
          • Use external tables to import data
            • Use external tables to import data from ApsaraDB RDS for MySQL to AnalyticDB for MySQL
            • Use external tables to import data from a self-managed MySQL database to AnalyticDB for MySQL
          • Use external tables to export data
            • Use external tables to export data from AnalyticDB for MySQL to ApsaraDB RDS for MySQL
            • Use external tables to export data from AnalyticDB for MySQL to a self-managed MySQL database
          • 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
          • Use DLA to import data from Apache Hadoop
            • Feature description
            • Procedure
          • Import MaxCompute data to AnalyticDB for MySQL
          • Use external tables to export data to MaxCompute partitioned tables
          • Flink AnalyticDB MySQL Connector
        • 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
          • Use the AnalyticDB for MySQL import tool to import on-premises data
        • Asynchronously submit an import or export task
      • 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
          • Full-text Search (Advanced Edition)
            • Create a full-text index
            • Query data by using full-text indexes
            • Custom analyzers and dictionaries
          • 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
          • Diagnose slow SQL 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
          • DescribeLoadTasksRecords
          • DescribeConnectionCountRecords
        • 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
          • DescribeTableStatistics
        • Appendixes
          • Cluster states
      • SDK Reference
        • SDK reference
      • Spark and Airflow clusters
        • Spark clusters
        • Airflow clusters
    • Best Practices
      • Schema design
      • Rules 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
    • Performance White Paper
      • Overview
      • Test description based on standard dataset
        • Test environments
        • Test procedure
        • Test method
      • Test description based on application scenarios
        • Query scenarios
        • Data import scenarios
      • Appendix: test procedure
        • TPC-H test
          • Preparations
          • AnalyticDB for MySQL
          • Presto
          • Apache Spark
          • Construct data
          • Import data
          • TPC-H dataset
        • TPC-DS test
          • Preparations
          • Install TPC-DS tools
          • Construct data
          • Create test tables in AnalyticDB for MySQL
          • Import test data
          • TPC-DS dataset
    • Technical Whitepaper
      • Industry trends and background
        • Technology development trends
        • Business challenges
      • Technical architecture
        • Overall architecture
        • Elastic computing layer
        • Serverless storage layer
      • Technical benefits
        • High performance
          • Xuanwu analytical storage engine
          • Xihe analytical computing engine
          • Cost-based SQL optimization
          • Query optimization based on hybrid loads
          • Read/write splitting architecture
        • High availability
          • High availability of the access layer
          • High availability of the computing layer
          • High availability of the storage layer
        • High scalability
          • Elasticity of the computing layer
          • Elasticity of the storage layer
      • Backup and restoration
        • How backup works
        • How restoration works
      • Monitoring and alarm
        • Monitoring mechanism
          • Data collection
          • Data storage
          • Data aggregation analysis
        • Alerting mechanism
        • Obtain monitoring data (API operation)
    • FAQ
 
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