TiDB Data Connection

  • Last update: September 19, 2024
  • Overview

    Version

    FineDataLink VersionFunctional Change
    4.0.28/

    Introduction 

    TiDB is a converged distributed database product that supports both Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP), known as Hybrid Transactional and Analytical Processing (HTAP). It features horizontal capacity scaling, financial-grade high availability, real-time HTAP capabilities, distributed cloud-native architecture, and compatibility with MySQL 5.7 protocol and MySQL ecosystem, among other important characteristics.

    FineDataLink supports the use of TiDB databases as the source and target data sources.

    Application Scenario 

    Scheduled Task supports the reading from and writing into the TiDB database.

    Pipeline Task supports data writing into the TiDB database.

    Preparation 

    Version and Driver

    Supported Database VersionDriver

    V5.2.0

    V5.2.1

    The driver (com. mysql. jdbc. Driver) is built-in, and no download is required.

    If the driver is unavailable for use, replace the official driver by referring to Choose Driver or ORM.

    Connection Information Collection 

    Collect the following information before connecting FineDataLink to the database.

    • IP address and port number of the database server

    • Database name

    Procedure

    1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection.

    iconNote:
    If you are not the admin, you can configure data connections only after the admin assigns you permission on Data Connection under Permission Management > System Management. For details, see Data Connection Management Permission



     2. Click the TiDB icon.

    3. Fill in the connection information.

    iconNote:
    (Optional) You can modify advanced settings. For details, see Connection Pool Setting.

    4.  Click Test Connection. If the connection is successful, click Save to save the configuration.

    Data Source Usage 

    After configuring the data source, you can use it in Data Development. For details, see Overview of Data Development.

    After configuring the data connection, you can use it in Data Pipeline to write data into the TiDB database.


    附件列表


    主题: Data Source Configuration
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    6s后關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy