Overview
Version
| FineDataLink Version | Functional Change |
|---|---|
| 4.1.8.2 | Scheduled Task supported data reading from and writing into the Oscar database. Pipeline Task supported data writing into the Oscar database. Data Service supported data reading from the Oscar database. |
Function Description
FineDataLink supports connection to the Oscar database for data reading and writing using scheduled tasks, data writing using pipeline tasks, and for releasing data services.
Notes
1. When using an Oscar cluster, pay attention that:
Nested multi-level queries are not supported. Errors will occur if there are duplicate fields in the subquery.
The PrepareStatement method of the Oscar cluster does not support the simultaneous use of subqueries and the question mark (?) placeholders.
The LIMIT statement cannot be used in subqueries.
2. The database driver does not support the insertion of files as large-object data into the Oscar database currently. The supported large-object data types include CLOB, BLOB, and XML. The file content can be read as binary data and inserted into the database as large object data.
Preparation
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.
| Supported Database Version | Driver |
|---|---|
| 7.0 | oscarJDBC.jar |
Connection Information Collection
Collect the following information before connecting FineDataLink to the database.
IP address and port number of the database server
Username and password of the database
Database name
Procedure
1. Log in to FineDataLink, choose System Management > Data Connection > Data Connection Management, and choose Create > Data Connection, as shown in the following figure.
2. Set the data connection name. You can also modify the directory of the data connection.
3. Find the Oscar data source by searching the data source name or filtering the data source by Data Source Type, Supported Form, and Compatible Module, as shown in the following figure.
4. Enter the connection information collected in the "Connection Information Connection" section.
5. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.
Data Source Usage
After configuring the data source, you can use it in Scheduled Task. For details, see Overview of Scheduled Task.
After configuring the data source, you can use it in Data Service. For details, see Overview of Data Service.
After configuring the data source, you can use it in Data Pipeline. For details, see Overview of Data Pipeline.
Previous：Pulsar Data Connection
