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
    • API Reference
      • SDK reference
 
All Products
Search
  • Document Center
  • AnalyticDB for MySQL
  • Data Integration
  • OSS
  • Use DataWorks to import data from OSS
  • Configure an AnalyticDB for MySQL connection

This Product

  • This Product
  • All Products

    Configure an AnalyticDB for MySQL connection

    Document Center
    Download PDF

    Configure an AnalyticDB for MySQL connection

    Last Updated: Aug 03, 2020

    To configure an AnalyticDB for MySQL connection, you can follow the steps for using DataWorks.

    For more information, see Configure the AnalyticDB for MySQL connection .

    Previous: Configure an OSS connection Next: Configure the source connection and destination connection for a synchronization task

    How helpful was this page?

    What might be the problems?

      More suggestions?

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