SQL-Server
Updated 3 weeks ago
by
Stephanie Krenz
To store the data from your SAP-system, you need a connection to the SQL-server.
Click on Settings at the top, then on SQL Servers on the left-hand side and create a connection by clicking on + SQL Server at the top right.
The following screen is divided in two sections: General and Permissions.
dab Nexus requires the role dbowner for the database.
General
In this area, you define all the basic settings for the connection to your SQL-server.
You must define the following settings:
- Name: enter a name for the SQL connection in the textfield on the top left side
- Connection: select the type of connection. You can choose between the following three connection types:
- TCP/IP (recommended)
In this section you define the following settings:
- Hostname (if the server hosts only one SQL server instance): e.g. myserver
OR
Hostname & Instancename (if the server hosts multiple SQL Server instances): e.g. myserver\MYINSTANCE
- Trust server certificate (optional): if this option is activated, the SSL/TLS certificate sent by the server is not validated
- Enable TLS encryption (optional): if this option is activated, the data traffic between dab Nexus and the SQL server is encrypted
- Is contained database (optional): if this option is activated, you can enter a name for the database in which your data is stored (this is isolated from the SQL server instance that provides the database).
- Authentication Type: to establish a SQL connection, the following authentication types are available:
Authentication Type | Authentication method | Microsoft articles for reference |
SQL Authentication | Enter the SQL Server Username and Password | |
Windows Authentication | Use Windows authentication with SQL Server; using the Windows user the dab Nexus service is running as | |
Microsoft Entra ID | Enter the Username and Password to the client and driver. | |
Service Principal | Enter the Client ID and Client Secret. | |
System Assigned Managed Identity | ||
User Assigned Managed Identity | Enter the User Assigned Managed Identity |
- Name Pipes
Here you will find the same setting options as explained in the previous point TCP/IP.
In the background, a connection is created between the SQL server and the clients. Only they know both sides and the data is then sent back and forth via this connection.
However, this only works between Windows systems.
- Shared Memory
Here you will find the same setting options as explained in the previous point TCP/IP.
Communication between the SQL server and clients works directly via the computer's memory.
However, the prerequisite for this is that SQL Server and dab Nexus are installed on the same server.
Permissions
In this area, teams (a group of users) and individual users can be explicitly authorised for this connection to the SQL server.
If you select individual teams or users here, only these can access the SQL connection later.
If you do NOT select any teams or users here, everyone will have access to this SQL connection.
- Test Connection (optional): here you can test the connection to the SQL-Server and either a success or error message will appear.
- Create oder Create & Close: if you select the Create button at the top right, the connection is saved, but you remain in the settings area. If you click on Create & Close, the connection will be saved and you will be redirected back to the SQL Server overview. Here you can see your newly created connection.
SQL-Server Overview
All existing SQL connections are displayed in this overview.
You will see the following information for each connection in the list:
- Name of the SQL connection, Host- and Instancename and the database name, if specified
- Status of the connection test with date and time of the last test:
- not tested yet
- successful
- warning
- failure
If you hover over the connection with the mouse, three dots appear next to the connection name.
There you have access to the following functions:
- Deactivate SQL Server: if you deactivate the SQL Server connection, it is no longer displayed when a task is created. The connection is displayed again with the Activate SQL Server option.
- Activities: you can see all the changes to this connection on the right-hand side of the screen.
- Edit: adjust the current settings of the SQL connection.
- Clone: copies the selected connection and applies all settings. Important: If a password is required for authentication, this will NOT be copied and must be re-entered!
- Delete: deletes the selected connection completely and irrevocably.
