Oracle Data Connection

Application Scenario

FineDataLink supports connection to the Oracle database for data reading/writing using scheduled tasks and pipeline tasks and for releasing data services.

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

• Database pattern

Thin Mode

If you need to use this data connection for data development tasks, data service tasks, and LogMiner-based data pipelines, follow the steps below.

Log in to FineDataLink, choose System Management > Data Connection > Data Connection Management, and click New Data Connection.

Note: If you are not the admin, you can configure data connections only after the admin assigns you permission on Data Connection under Permission Management > System Management. For details, see Data Connection Management Permission.

Click the Oracle database.

Fill in the connection information. To use a built-in driver, select Default. To use the driver you upload, click Custom and select the required driver.

You cannot set Pattern unless the database is connected. Click Click to Connect Database and then click Pattern, as shown in the following figure.

Note: The Oracle database is case-sensitive, so pay attention to the letter case when filling in the database name and the pattern. 

The following table describes the driver, database name, and URL.

The value of sid_name can be queried using the statement: Select INSTANCE_NAME from v$instance.

TNSName is described as follows.

In the URL (jdbc:oracle:thin:@TNSName), the value of TNSName is the value of ORCL in the tnsnames.ora file, as shown in the following figure.

The full URL is as follows:

jdbc:oracle:thin:@
(DESCRIPTION=(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=Protocol)(HOST=IP address)(PORT=Port number)))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=Service Name)))

OCl Mode

The Thin driver is not available if you need to use this data connection to synchronize data from a container database (CBD) through XStream using pipeline tasks as the connection to XStream relies on the OCI driver.

Modify the data connection URL above to the following one.

jdbc:oracle:oci:@(DESCRIPTION=
(ADDRESS=(PROTOCOL=Protocol)(HOST=IP address)(PORT=Port number))
(CONNECT_DATA=(SID=Database Name)))

The value of HOST is the IP address of the Oracle server, the value of PORT is the port number, and the value of SID is the database name.

After configuring the data source, you can use it in Data Development. For details, see Overview of Data Development.

After configuring the data source, you can use it in Data Pipeline. For details, see Overview of Data Pipeline.

After configuring the data source, you can use it in Data Service. For details, see Overview of Data Service.

If you need to use the data source for setting pipeline tasks with data from pluggable databases (PDB), modify the database of this connection to the corresponding PDB database.