General Configuration - Field Mapping Rule

  • Last update: April 18, 2025
  • Overview

    Version

    FineDataLink VersionFunctional Change

    4.1.9.3

    • Allowed customizing field mapping rules and configuring valid data connections.

    • Prioritized the customized mapping rules of data connections over the default rules in scenarios including automatic table creation, the synchronization of DDL changes via pipeline tasks, and DDL changes prompting in scheduled tasks.

    4.2.2.1

    Supported Field Mapping Rule in a cluster environment.

    Supported Field Mapping Rule in the SelectDB database.

    Application Scenario

    During the configuration of data synchronization for pipeline tasks and scheduled tasks, you may encounter situations where the expected field mapping relationship does not match the default mapping relationship provided by FineDataLink.

    You can modify the field type of the target table if Target Table is set to Auto Created Table. However, for scheduled tasks, if this mapping modification needs to be applied to multiple tasks or nodes in this data source, you need to configure mapping rules repeatedly. For pipeline tasks, you may synchronize data in dozens or hundreds of tables at once. It is impractical for you to manually search and modify fields table by table and field by field.

    Therefore, you may want to uniformly customize field mapping rules for multiple scheduled tasks and pipeline tasks that use the same data connection.

    Function Overview

    • Allowed customizing field mapping rules and configuring valid data connections.

    • Prioritized the customized mapping rules of data connections over the default rules in scenarios including automatic table creation, the synchronization of DDL changes via pipeline tasks, and DDL changes prompting in scheduled tasks.

    Limitation

    1. Types of data sources currently supported by Field Mapping RuleMySQLOracleSQLServerPostgreSQLGreenplumStarRocksDoris, and SelectDB.

    2.  You can only use the admin account set during the initialization configuration to set General Configuration, and you cannot assign Use and Management permission on General Configuration to other users.

    3. For FineDataLink versions before V4.2.2.1, the Field Mapping Rule function is not supported in a cluster environment. For FineDataLink of V4.2.2.1 and later versions, this function is supported in a cluster environment.

    Function Description

    2.png

    Configuration Item
    Description

    Rule Name

    You can customize the name of a field mapping rule.

    Data Source Mapping

    You can select the source database type and target database type.

    Applicable Data Connection

    You can select a created data connection that meets the conditions.

    Field Mapping Rule

    You can select the field types of the source and target ends as needed, set multiple field type mapping relationships between the source and target ends, and add or delete them.

    Configuration ItemDescription

    Field types of the source and target ends

    You can select from all available field types in the source and target databases from the drop-down list.

    Length

    For the field mapping on the source end:

    • When the upper and lower limits are initialized, the system provides default values. The limits are given based on the specific database type and field type.

    • You can modify the upper and lower limits as needed.

    For the field mapping on the target end:

    • If the selected field type of the source end does not support configuration for LengthPrecision, or Scale, but the field type of the target end does, you can set fixed values for length, precision, or scale on the target field.

    • If the selected field types of both the source and target ends support configuration for LengthPrecision, or Scale, you can set precise values or multipliers for the target field.

    Precision

    Scale


    Procedure

    For example, when you create a scheduled task or a pipeline task, some source tables in the MySQL database contain char-type fields.When StarRocks is the target database, you cannot select char-type fields as primary keys, and an error will occur during table creation.

    You may want the char-type fields to be mapped to varchar-type fields in StarRocks by default, so that you can achieve successful configuration and data synchronization.

    Before configuring Field Mapping Rule, you need to first create a data connection. For details, see Data Source Creation and Management.

    Setting the Field Mapping Rule

    1. Choose System Management > General Configuration and click Field Mapping Rule, as shown in the following figure.

    3.1-1.png

    2. Enter the rule name, select the source and target database types in Data Source Mapping, choose the previously created data connection with permissions on the platform, and select the field types that need mapping modification from the source end and target end.

    You can choose to set Length or Precision to Fixed Value or Multiple of N. If Fixed Value is selected, you need to enter an integer ranging from 1 to 65533. If Multiple of N is selected, you need to enter a multiplier such that a multiple of n ranges from 1 to 65533.

    3.1-2.png

    In this example, the value of n set for Length or Precision ranges from 1 to 255, and the value set for Multiple of N is 3, as shown in the following figure.

    3.1-3.png

    Effect Display

    When you create a pipeline task in Data Pipeline, the char-type fields in Table Field Mapping are changed to varchar-type fields during data synchronization, and the field length and precision are also modified according to the configured field mapping rule, as shown in the following figure.

    3.2-1.png

    When you create a scheduled task in Data Development, the char-type fields in Table Field Mapping are changed to varchar-type fields during data synchronization, and the field length and precision are also modified according to the configured field mapping rule, as shown in the following figure.

     3.2-2.png

    附件列表


    主题: System Management
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read

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

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

    不再提示

    10s後關閉

    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