Data Connection to Microsoft SQL Server

Version

Application Scenario

This document introduces how to connect to the Microsoft SQL Server database.

Version/Driver

Download the corresponding driver package. For details about how to upload the driver package, see Driver Management.

Connection Information Collection

Before connecting the database, you need to collect the following information:

• IP address and port number of the database server

• Database name

• Username and password of the database

• Schema of the database to be connected

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection, as shown in the following figure.

Note:

If you are not the admin, you can configure data connections only after the admin assigns you the permission on Data Connection Management. For details, see Data Connection Permissions Overview.

2. Find the Microsoft SQL Server icon, as shown in the following figure.

3. Enter the connection information collected in section "Connection Information Collection". Select Default from the Driver drop-down list as the driver is built-in.

Schema is available after the database is connected by clicking Click to Connect Database, as shown in the following figure.

Note:

1. To connect to a non-default instance, you can change Data Connection URL in either of two ways:

• jdbc:sqlserver://IP address;InstanceName=Instance name;DatabaseName=Database name

• jdbc:sqlserver://IP address\Instance name;DatabaseName=Databasename

2.  If you use a SQL statement to connect a multi-schema database, you need to prefix the database name with the schema names in the statement, for example, SELECT * FROM [dbo].[asdfg].

4. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets

Note on the Decimal Data Type

If a field in the database is of the decimal type (with one decimal place kept and 0 to the right of the decimal point), the field value will be displayed as an integer directly during the FineBI preview.