OceanBase (Oracle) Data Connection

Version

Function Description

FineDataLink supports connection to OceanBase (Oracle) data sources with the following functions available:

• Data reading/writing using Scheduled Task

• Data writing using Real-Time Pipeline Task

• Database Table Management

• Data Service

Prerequisite

For details, see Overview of Data Connection.

Version and Driver

Download the driver package and upload it to FineDataLink. For the specific steps of uploading the driver package, see Driver Management.

Connection Information Collection

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

• Schema of the database to be connected

Procedure

For details about data connection creation, see Data Source Creation and Management.

Note that when configuring the data connection, you must select Custom from the drop-down list of  Driver and select the driver mentioned in the "Version and Driver" section of this document.

Scheduled Task

Data Reading

1. Stored Procedure in Configuration Method is unavailable, as shown in the following figure.

2. When Configuration Method is set to Table Selection, the table description is displayed.

3. Data from this data source can be written into Public Data.

Data Writing

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.

Data Pipeline

You can write data into this data source using Real-Time Pipeline Task.

When data is written into an OceanBase (MySQL) data source through pipeline tasks, BLOB/CLOB/NCLOB-type data is automatically intercepted.

Data Service

You can release data from this data source as APIs using Data Service.

Database Table Management

You can view and manage data in this data source in Database Table Management.