Skip to main content
Version: 2023 R3

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.