InterSystems IRIS Data Connection

Version

Function Description

FineDataLink supports connection to InterSystems IRIS data sources with the following functions available:

• Data reading/writing using Scheduled Task

• Data Service

• Database Table Management and Lineage Analysis

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

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. You can select InterSystems IRIS as the data source in Data Synchronization, Parameter Assignment, Global Assignment Parameter, the DB Table Input operator in Data Transformation, and SQL Script.

Note:

You can set Configuration Method to  Stored Procedure. Ensure you have the EXECUTE permission on the stored procedure to be executed.

2. If it is selected in Data Source in a scheduled task, the following functions are unavailable: Parallel Read, partition table reading, and field remarks.

3. If an ORDER BY clause is used in an SQL statement, it must be used in conjunction with TOP/BOTTOM.

Data Writing

You can select InterSystems IRIS as the data destination in Data Synchronization and the DB Table Output operator in Data Transformation.

If it is selected as the data destination in a scheduled task, DDL change synchronization and writing data into partition tables are 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

Under System Management > General Configuration, the Auto Table Creation Configuration function is available for this data source, while the Field Mapping Rule function is not.