Skip to main content
Version: 2023 R2

MSSQL database

The data source allows you to retrieve data from the MSSQL database.

drex_DataConnection_MSSQL_screen.png

1. ID​

The data source identifier (if the value is smaller than 0, the source has not been saved in the database yet).

2. Name​

Name of the data source entered by the user.

3. Connection type​

The field allows you to specify a connection type. You can choose from: MSSQL Database, Oracle Database, Exchange Server, OneDrive, SharePoint Site Collection, REST Web Service, and SOAP Web Service.

4. Description​

Description of the data source entered by the user.

5. Environment​

Defines the behavior of the data source in particular environments. The Common tab sets the default parameters that are to be used across all three environments (DEV/TEST/PROD). The tabs dedicated to the individual environments can be used to enter custom parameters. In such case, it is necessary to check the Break inheritance checkbox (this will override the settings specified in the Common tab) and then enter the desired connection settings.

6. Server​

The address of the MSSQL server. When there are several instances of the SQL Server, it is necessary to select the server and the instance to which we want to connect.

7. Database​

The database in the context of which a query is executed.

8. User​

An SQL user. For the Windows authentication the field is grayed out.

9. Password​

An SQL user's password. For the Windows authentication the field is grayed out.

10. Windows integrated authentication​

The parameter allows you to specify whether to use an SQL or a Windows authentication.

11. Test​

Tests the connection to the SQL server.