Microsoft SQL Server Data Connection

Application Scenario

FineDataLink supports connection to Microsoft SQL Server for data reading/writing using scheduled tasks and pipeline tasks and for releasing data services.

Version and Driver

Download the corresponding driver package. 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

• Database pattern

1. Log in to FineDataLink as the admin, 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.  

2. Click Microsoft SQL Server.

3. Select Default as the driver is built-in and fill in the connection information.

You cannot set Pattern unless the database is connected. Click Click to Connect Database and then click Pattern.

Note 1: To connect to a non-default instance, you can change the value of Data Connection URL to jdbc:sqlserver://IP address:Port number;instanceName=Instance name;databaseName=Database name.

Note 2: Include the pattern prefix in SQL statements if the connected database has multiple patterns. For example, SELECT * FROM [dbo].[asdfg].

4. Click Test Connection. If the connection is successful, click Save. 

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.

Note: For FineDataLink 4.1.1 and later releases, if a database from Microsoft SQL Server is used as the data source, it supports synchronization without a primary key.

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