All Products
Search

This Product

    AnalyticDB:Schedule XIHE SQL jobs with DolphinScheduler

    Document Center

    AnalyticDB:Schedule XIHE SQL jobs with DolphinScheduler

    Last Updated:Jun 05, 2026

    DolphinScheduler is a distributed and extensible open-source workflow orchestration platform with a powerful Directed Acyclic Graph (DAG) visual interface for executing and managing big data processing workflows. You can use DolphinScheduler to schedule XIHE SQL tasks for AnalyticDB for MySQL to improve data processing efficiency.

    Prerequisites

    • DolphinScheduler is installed. For details, see the official DolphinScheduler documentation.

    • The MySQL driver (version 8.0.0 or later) is configured in the DolphinScheduler installation directory . To download the driver, see mysql-connector-java.

    • You have added the IP address of the DolphinScheduler server to the whitelist of your AnalyticDB for MySQL cluster. For more information, see Whitelist.

    Procedure

    1. Create a data source.

      1. In the DolphinScheduler web UI, click Datasource in the top navigation bar.

      2. Click Create DataSource and select MYSQL as the data source type.

      3. In the Add Data Source dialog box, configure the following parameters:

        Parameter

        Description

        Data source

        Select MYSQL.

        Data source name

        The name of the data source.

        Hostname

        The hostname of the AnalyticDB for MySQL cluster. You can find the hostname on the Cluster Information page in the console.

        Port

        The port number of the AnalyticDB for MySQL cluster. The value is fixed at 3306.

        Username

        The database account for the AnalyticDB for MySQL cluster.

        Database name

        The name of the database in the AnalyticDB for MySQL cluster.
        Note

        Other parameters are optional. For more information, see the official DolphinScheduler documentation on MySQL data sources.

      4. Click Test Connection. After the connection test succeeds, click OK.

    2. Create a project.

      1. In the top navigation bar, click Projects.

      2. Click Create Project.

      3. In the Create Project dialog box, configure parameters such as Project Name and Username. For details, see Create Project.

    3. Create a workflow.

      1. Click the name of the project you created to open the Workflow Definition page.

      2. Click Create Workflow to open the workflow DAG edit page.

      3. From the task list on the left, drag the SQL node to the canvas on the right.

      4. In the Configure Current Node dialog box, configure the following parameters:

        Parameter

        Description

        Data source type

        Select MySQL.

        Data source instance

        Select the data source you created in Step 1.

        SQL type

        The type of the SQL job, such as Query or Non-query.

        SQL statement

        Enter the SQL statement to execute.

      5. Click OK.

      6. In the upper-right corner of the page, click Save. In the Basic Information dialog box that appears, configure parameters such as Workflow Name.

      7. Click OK.

    4. Run the workflow.

      1. In the workflow's Actions column, click the image icon to publish it.

      2. In the workflow's Actions column, click the image icon.

      3. In the Configure Parameters dialog box, configure the required parameters.

      4. Click OK to run the workflow.

    5. View workflow details.

      1. In the navigation pane on the left, click Task Instances.

      2. In the Operation column, click the image icon to view the execution results and logs.