Connect Davinci to MaxCompute

Make sure that you meet the following requirements:

• You have created a MaxCompute project.

  For more information, see Create a MaxCompute project.

• You have obtained an AccessKey ID and AccessKey secret with permissions to access the MaxCompute project.

  You can obtain them from the AccessKey Management page.

• You have downloaded the MaxCompute JDBC driver (v3.0.1 or later), specifically the jar-with-dependencies package.

  Note

  The MaxCompute JDBC driver version used in this topic for demonstration is v3.2.9.

• You have installed and configured Davinci.

  You can install and configure Davinci by following the official Davinci documentation. For more information, see Install and configure Davinci. You can also install Davinci by using Docker and mount the MaxCompute JDBC driver successfully.

  When you configure Davinci and mount the driver, make sure that the MaxCompute-related information is correctly configured. For more information, see Configuration notes for Davinci and the driver.

When configuring Davinci and mounting the driver, ensure the following information is correct:

• Mail configuration

  # Configuration information in the config/application.yml file.
  mail:
      # The SMTP service address.
      host: 
      # The SMTP service port.
      port: 
      # Your email address.
      username: 
      # You do not need to fill in this parameter.
      fromAddress: 
      # Your email authorization code. This is not your email password.
      password: 
      # The email display name, for example, Davinci.
      nickname: 
  # You can keep the following settings at their default values.
      properties:
        smtp:
          starttls:
            enable: true
            required: true
          auth: true
        mail:
          smtp:
            ssl:
              enable: true

• Custom data source configuration

  • If you install Davinci by following the official documentation, open the custom data source configuration file datasource_driver.yml and add the following content.

    odps:
        name: odps
        desc: odps
        version:
        driver: com.aliyun.odps.jdbc.OdpsDriver
        keyword_prefix:
        keyword_suffix:
        alias_prefix: \`
        alias_suffix: \`

    After configuration, copy the MaxCompute JDBC driver JAR package to the lib directory and restart the Davinci service.

  • If you install Davinci by using Docker, manually create a data source configuration file named datasource_driver.yml. Run the vim docker-compose.yml command to open the configuration file and add the following content.

    volumes:
          - /path/to/odps-jdbc-x.x.x-jar-with-dependencies.jar:/opt/davinci/lib/odps-jdbc-x.x.x-jar-with-dependencies.jar
          - /path/to/datasource_driver.yml:/opt/davinci/config/datasource_driver.yml

    odps-jdbc-x.x.x-jar-with-dependencies.jar is the name of the MaxCompute JDBC driver JAR package, for example, odps-jdbc-3.2.9-jar-with-dependencies.jar. After configuration, restart the Davinci service.

Davinci uses views to manage SQL templates and data permissions. Widgets aggregate and group view data into visualizations. For more information, see Davinci Help.

• View all tables

  On the view list page, click the icon in the upper-right corner to open the SQL editor. Select the data source you created to see all available tables.

• View the table schema

  On the view list page, click the icon in the upper-right corner to open the SQL editor. Select the data source you created, write and run an SQL script, then click Next to view the table schema.

• View table data

  On the view list page, click the icon in the upper-right corner to open the SQL editor. Select the data source you created, write an SQL script, and then click Execute to view the table data.

• Visualize and analyze data

  On the widget page, click the icon in the upper-right corner to open the chart editor. Select a chart type and configure its properties to analyze your data based on your business needs.