All Products
Search

This Product

    AnalyticDB:Import on-premises data using Kettle

    Document Center

    AnalyticDB:Import on-premises data using Kettle

    Last Updated:Jul 17, 2026

    You can use Kettle to import data from a local Excel file into AnalyticDB for MySQL.

    Background

    Kettle is a popular open-source extract, transform, and load (ETL) tool for data integration, transformation, and migration. Kettle supports various relational databases and NoSQL data sources such as HBase and MongoDB, as well as file-based data sources like Excel and Access. You can extend its capabilities to support more data sources through plug-ins.

    For more information, see the official Kettle website.

    Prerequisites

    • Kettle is installed.

    • A destination database and table have been created in AnalyticDB for MySQL.

    • The IP address of the machine where Kettle is installed has been added to the whitelist of the AnalyticDB for MySQL cluster.

    • If you need to connect to your AnalyticDB for MySQL cluster over the internet, apply for a public endpoint.

    Procedure

    1. Open Kettle. From the menu bar, click File > Create > Transform to create a new transformation.

    2. From the menu bar, click File > Create > Database Connection to create a new database connection.

      Parameter

      Description

      Connection Name

      Enter a name to identify the connection.

      Connection type

      Select MySQL.

      Encryption

      Select Native (JDBC).

      Host Name

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

      Database Name

      The name of your database in AnalyticDB for MySQL.

      Port

      3306

      Database Account

      The account used to access the AnalyticDB for MySQL cluster. This can be one of the following account types:

      • privileged account

      • standard account

      Password

      The password for the specified user account.
      Note

      Do not select the Use Result Streaming Cursor checkbox.

    3. After you complete the preceding parameter configuration, click Test. In the Database Connection Test dialog box that appears, use the prompt to verify the connection to the AnalyticDB for MySQL database, and click OK after the test passes.

    4. In the Core objects panel on the left, expand the Input folder and drag the Excel Input step to the main workspace.

    5. Double-click Excel Input in the workspace, and in the Excel Input dialog box, click Browse to upload the Excel table to import, and then click Add to add it to Selected files.

      Configure the settings on the Sheets, Content, and Field tabs. Click Preview records to verify that the data is read correctly.

    6. In the Core objects panel, expand the Output folder and drag the Table output step to the workspace.

    7. Create a hop (a connection line) from the Excel Input step to the Table output step.

    8. Double-click the Table output step to open the Table output dialog box and configure the following settings.

      • Target schema: Enter the name of your AnalyticDB for MySQL database.

      • Target Table: Enter the name of the destination table in your AnalyticDB for MySQL database.

      • Select the Specify database fields checkbox.

      • Select the Use batch insert checkbox.

      In the Database Fields tab of Table Output, click Get Fields and Input Field Mapping to configure the mapping between columns in Excel and the column names in the AnalyticDB for MySQL table.

    9. Click the Run icon (a green triangle) to start the transformation. Monitor the execution logs and status in the Log panel at the bottom of the window.

      After the data is imported, you can run analytical queries on it in AnalyticDB for MySQL.