Overview
Application Scenario
FineDataLink supports connection to Microsoft SQL Server for data reading/writing using scheduled tasks and pipeline tasks and for releasing data services.
Preparation
Version and Driver
Download the corresponding driver package. For the specific steps of uploading the driver package, see Driver Management.
Supported Database Version | Driver Package Download |
---|---|
SQL Server 2000 | |
SQL Server 2005 SQL Server 2008 SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2019 Note: SQL server 2019 is supported by FDL 4.0.17.1 and later releases. | (Built-in) No need to download. |
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
Procedure
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.
Data Source Usage
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.