Supported connection to the OceanBase (MySQL) data source, with the following functions available:
Data reading and writing using Scheduled Task
Data writing using Real-Time Pipeline Task
Database Table Management
Data Service
Supported data reading from the OceanBase (MySQL) data source using Real-Time Pipeline Task and Real-Time Task.
Added the OBCDC Wrapper Path setting to the data connection configuration.
FineDataLink supports connection to OceanBase (MySQL) data sources for:
Data reading and writing using Real-Time Pipeline Task
Data writing using Scheduled Pipeline Task
Data reading using Real-Time Task
For details, see Overview of Data Connection.
Download the driver package and upload it to FineDataLink. For details about driver uploading steps, see Driver Management. Configure the data connection using either of the following connection schemes.
jdbc:mysql://obmt68hdqbmnbh4w.huawei-cn-north-4.oceanbase.cloud:3306/fdl
jdbc:oceanbase://obmt68hdqbmnbh4w.huawei-cn-north-4.oceanbase.cloud:3306/fdl
Note that:
1. When uploading a MySQL-type driver provided in connection scheme one, select com.mysql.jdbc.Driver as the driver.
com.mysql.jdbc.Driver
2. When uploading an OceanBase-type driver provided in connection scheme two, select com.oceanbase.jdbc.Driver as the driver.
com.oceanbase.jdbc.Driver
Collect the following information before connecting FineDataLink to the database:
IP address and port number of the database server
Database name
Username and password of the database
Database encoding
For details about data connection steps, see Data Source Creation and Management.
Note that when configuring the data connection, you need to select Custom from the Driver drop-down list and select the driver described in the "Version and Driver" section.
From FineDataLink V4.2.20.2, the OBCDC Wrapper Path setting is added to the data connection configuration.
1. Stored Procedure in Configuration Method is unavailable, as shown in the following figure.
2. When Configuration Method is set to Table Selection, table descriptions are displayed.
3. Data from this data source can be written to Public Data.
1. If it is selected as the data destination, DDL change synchronization is available.
2. Remark in Field Mapping is available.
3. Partition Key Setting is unavailable.
LOB fields cannot be synchronized.
1. From FineDataLink V4.2.20.2, data can be read from this data source through Real-Time Pipeline Task.
2. Partitioned tables can be read.
3. DDL changes can be synchronized.
4. Grouped tables can be added.
You can write data into this data source using Real-Time Pipeline Task.
BLOB, CLOB, and NCLOB fields are automatically excluded when data is written to the OceanBase (MySQL) data source through pipeline tasks.
You can publish data in this data source as APIs using Data Service.
You can view and manage data in this data source using Database Table Management.
1. You can use Scheduled Pipeline Task to write data to this database, but not to partitioned tables.
2. Target table names are case-insensitive. The database converts automatically created table names to lowercase according to its naming rules.
3. DDL change synchronization is not available.
4. The field mapping rules are as follows:
__dm_key
Write data into the target table directly
Strategy for primary key conflict: Overwrite data in the target table if the same primary key value exists
Update matching records
Strategy for primary key conflict: This setting is not displayed because the target table has no primary key. If a conflict occurs, the conflicting data is recorded as dirty data.
Write data into the target table after emptying it
Update matching records after emptying the target table
From FineDataLink V4.2.20.2, data can be read from this data source through Real-Time Task.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy