Overview
FineDataLink supports connection to the Informix database for data reading and writing using scheduled tasks.
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 Package |
---|---|
V11.7 and V11.5 | ifxjdbc_informix (1).jar |
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
1. Log in to FineDataLink as the admin, 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 INFORMIX 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. Click Custom, select the driver uploaded in the "Version and Driver" section, and enter the connection information collected in the "Connection Information Collection" section.
You cannot set Schema unless the database is connected. Click Click to Connect Database and then select the schema, as shown in the following figure.
Enter the database name in the format of Database Name:INFORMIXSERVER=Server Name.
5. Click Test Connection. If the connection is successful, click Save.
Data Source Usage
You can use data from the data source for data development.
Notes
To use the SQL statement that includes the field enclosed in double quotes (such as SELECT "COL1", "COL2" FROM table1;) to fetch data from the Informix database, you must suffix the data connection URL with the DELIMIDENT=Y parameter. Otherwise, automatic table creation will fail, or the SQL statements will fail to be executed.
Example URL: jdbc:informix-sqli://192.168.5.47:9088/fdl:INFORMIXSERVER=demo;DELIMIDENT=Y