DocsICP FilingConsole
官方文档
首页

Configure an AnalyticDB for MySQL 2.0 data source

更新时间：
复制 MD 格式
我的收藏

Prerequisites

Create a database, a table group, and a table in your AnalyticDB for MySQL instance. For more information, see Quick start - Activate AnalyticDB for MySQL, Create a table group, and Create a table.
Important In AnalyticDB for MySQL, create tables as real-time tables to simplify data import and improve efficiency.

Procedure

  1. Log on to the DataWorks console and, on the required project's card, click Go to Data Integration.
    In this example, the project name is SQLServer_DataWorks_ADB1. On the Data Source page, click Add Data Source.
  2. Click Add Data Source, then select AnalyticDB for MySQL.
  3. On the Add AnalyticDB for MySQL Data Source page, configure the following parameters.
    The following table describes the parameters.
    Parameter Description
    Data source name Enter a name to identify and manage the data source.
    Data source description Optional. Enter a description for the data source.
    JDBC URL Enter the connection endpoint and port for your AnalyticDB for MySQL instance.
    Database Enter the name of the database in your AnalyticDB for MySQL instance.
    AccessKey ID Enter the AccessKey ID used to authenticate the connection.
    AccessKey Secret Enter the AccessKey Secret that corresponds to the AccessKey ID.
  4. After configuring the parameters, click Test Connectivity. If successful, click Complete.