Vastbase G100 (Oracle) Data Connection

Version

Function Description

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

• Data reading/writing using Scheduled Task

• Data Service

• Database Table Management

Prerequisite

For details, see Overview of Data Connection.

Version and Driver

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

Procedure

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

Scheduled Task

Data Reading

1. You can select Vastbase G100 (Oracle) as the data source in Data Synchronization, Parameter Assignment, Global Assignment Parameter, the DB Table Input operator in Data Transformation, and SQL Script.

Note:

Stored Procedure in Configuration Method is unavailable.

2. Adding table descriptions is supported.

3. If it is selected in Data Source in a scheduled task, the Parallel Read and partition table reading functions are unavailable.

Data Writing

1. You can select Vastbase G100 (Oracle) as the data destination in Data Synchronization and the DB Table Output operator in Data Transformation.

2. If it is selected as the data destination in a scheduled task, the DDL change synchronization is unavailable, and you cannot configure Partition Key Setting when setting Target Table to Auto Created Table.

3. Transaction Control is unavailable.

Data Service

You can use this data source to release data services. For details, see Overview of Data Service.

Data Management

The Database Table Management and Lineage Analysis functions are available.

General Configuration

The Auto Table Creation Configuration and Field Mapping Rule functions under System Management > General Configuration are unavailable for this data source.