Add a relational database driver for RDBMS

Create a custom resource group

1. Log on to the DataWorks console.
2. In the left-side navigation pane, click Workspaces.
3. Find the required workspace and click Data Integration.
   If you are using another service of DataWorks, click the More icon in the upper-left corner and choose All Products > Data Integration to go to the Data Integration page.
4. In the left-side navigation pane, click Custom Resource Group. The Custom Resource Groups page appears.
5. Click Add Resource Group in the upper-right corner.
6. Install and initialize the agent.
   If the server status is Available, a custom resource group is created.

   If the server status is still Stopped after you refresh the dialog box, switch to the admin account and run the following command to restart alisa:

   /home/admin/alisatasknode/target/alisatasknode/bin/serverct1 restart

Add a MySQL driver

1. Log on to the ECS instance on which the custom resource group is created.
2. Run the following commands to go to the directory of RDBMS Reader. ${DATAX_HOME} indicates the home directory of Data Integration. RDBMS Reader resides in the /home/admin/datax3/plugin/reader/rdbmsreader directory.

   [root@izbp1czjk**** rdbmsreader]# pwd
   /home/admin/datax3/plugin/reader/rdbmsreader
   [root@izbp1czjkv**** rdbmsreader]# ls
   libs plugin.json rdbmsreader-0.0.1-SNAPSHOT.jar

3. Find the plugin.json file in the directory of RDBMS Reader. Add a specific database driver, such as com.mysql.jdbc.Driver in the following code, to the drivers array in the file.
   RDBMS Reader dynamically selects an appropriate database driver for connecting to a database when nodes are run.

   [root@izbp1cz**** rdbmsreader]# vim plugin.json
   {
       "name": "rdbmsreader",
       "class": "com.alibaba.datax.plugin.reader.rdbmsreader.RdbmsReader",
       "description": "useScene: prod. mechanism: Jdbc connection using the database, execute select sql, retrieve data from the ResultSet. warn: The more you know about the database, the less problems you encounter.",
       "developer": "alibaba",
       "drivers":["dm.jdbc.driver.DmDriver", "com.sybase.jdbc3.jdbc.SybDriver", "com.edb.Driver","com.mysql.jdbc.Driver"]
   }

4. Add the MySQL JAR package that you downloaded to the libs folder in the rdbmsreader folder.
   For example, you can add the mysql-connector-java-5.1.47.jar package, as shown in the following figure.

Configure a sync node

{
"job": {
        "setting": {
            "speed": {
                "byte": 1048576
            },
            "errorLimit": {
                "record": 0,
                "percentage": 0.02
            }
        },
        "content": [
            {
                "reader": {
                    "name": "rdbmsreader",
                    "parameter": {
                        "username": "xxxxx",
                        "password": "yyyyyy",
                        "column": [
                            "*",   
                        ],
                        "splitPk": "id",
                        "connection": [
                            {
                                "table": [
                                    "a2"
                                ],
                                "jdbcUrl": [
                                    "jdbc:mysql://xxx.mysql.yy.aliyuncs.com:3306/xxx" // Enter the JDBC URL of your MySQL database.
                               ]
                            }
                        ],

                        "where": ""
                    }
                },
                "writer": { // Configure the writer as required. 
                   "name": "streamwriter",
                    "parameter": {
                        "print": true
                    }
                }
            }
        ]
    }
}