Cloud Portal ONE Desktop ONE DQ&C ONE MDM ONE RDM ONE Runtime Server
User Community Service Desk Downloads

MS SQL Server Connection

This article describes how to connect to MS SQL Server for data processing and catalog.

If you’re looking to connect MS SQL Server for lineage, see MSSQL Lineage Scanner.

Availability

Data processing & catalog Edge processing Lineage Exceptions

✔

✔

✔

None

Prerequisites

Add a connection

  1. Go to [your source] > Connections and select Add Connection.

  2. In Connection type, select MSSQL Server.

  3. Fill in the following:

    • Name: A meaningful name for your connection. Used to indicate the location of catalog items.

    • Description (Optional): A short description of the connection.

    • JDBC: A JDBC connection string pointing to the IP address or the URL where your data source can be reached. See JDBC connection string format.

JDBC connection string format

The expected syntax is as follows:

Username and password authentication
jdbc:sqlserver://server_name:1433;database=database_name;encrypt=true;trustServerCertificate=false
Entra ID authentication
jdbc:sqlserver://server_name:1433;database=database_name;authentication=ActiveDirectoryServicePrincipal;encrypt=true;trustServerCertificate=false

For Azure-hosted SQL Server, use the full domain: server_name.database.windows.net.

Add credentials

  1. Select Add Credentials.

  2. Choose an authentication method and continue with the corresponding step:

    • Username and password: Basic authentication using your username and password.

    • Entra ID: Authentication using Microsoft Entra ID (formerly Azure Active Directory) for OAuth 2.0 authentication.

One set of credentials must be defined as default for each connection. Otherwise, DQ evaluation fails and previewing data in the catalog is not possible.

Username and password

To authenticate using a username and password:

  1. Fill in the following:

    • Name: Provide a clear name for this set of credentials.

    • Description (Optional): Explain what the credentials are used for or provide other useful information.

    • Username: The username for the data source.

    • Password: The password for the data source.

  2. To use this set of credentials by default when connecting to the data source, select Set as default.

Entra ID

To authenticate using Entra ID:

  1. Fill in the following:

    • Name: Provide a clear name for this set of credentials.

    • Description (Optional): Explain what the credentials are used for or provide other useful information.

    • Client ID: The application (client) ID registered in the Microsoft Entra portal.

      This appears as a GUID (for example, 4701c7e7-1178-4006-a1fc-b4c3ee5cfef7) and is found in the Entra ID portal in App registrations > [app name] > Overview.

    • Client Secret: The secret value generated for the application in the Microsoft Entra portal (App registrations > [app name] > Certificates & secrets).

      Client secrets expire (maximum 24 months). Plan to renew them before expiration to avoid connection failures.

    • Tenant ID: The directory (tenant) ID of your Microsoft Entra instance.

      This appears as a GUID (for example, 12345678-1234-1234-1234-123456789012) and is found in the Entra ID portal in App registrations > [app name] > Overview, or in Azure Active Directory > Overview.

      For details about registering an application and generating credentials, see Register an application with Microsoft Entra ID.

  2. To use this set of credentials by default when connecting to the data source, select Set as default.

Add write credentials

If you want to export data to this source, add write credentials. Select Add Credentials and follow the instructions in Add credentials.

Next steps

Test and save your connection to complete setup.

Was this page useful?