Skip to main content

[en] Azure Active Directory Interactive Authentication

[en] This article shows how to authenticate with an Azure AD identity by using interactive authentication.

[en] Common Prerequisites

  • [en] Available account in Azure Active Directory.

  • [en] Available Azure MS SQL server.

  • [en] Azure Active Directory is set to centrally manage identity and access to Azure SQL Database.

  • [en] Installed MS ODBC Driver for SQL Server. The current version is 17.

[en] DSN Connection

[en] You can connect with DNS using Data Connection Manager (DCM) or without it.

[en] Prerequisites: User or System DSN is configured in ODBC data source manager to use Azure Active Directory Interactive authentication.

DNS Settings

[en] DSN Connection without DCM

  1. [en] Place the Input Data tool on the Designer canvas.

  2. [en] Select the down arrow in the Connect a File or Database field.

  3. [en] From Data Sources, choose Microsoft Azure SQL Database - ODBC.

    MSQL ODBC

  4. [en] Choose DSN created in the preconditions from the dropdown.

  5. [en] There is no need to enter the credentials here because the external browser is triggered.

    External browser
    External browser

  6. [en] In the Query Builder, choose any table from your database.

  7. [en] Select OK.

注意

[en] Credentials are required for each setting change and workflow run. To eliminate this, set Cache Data on the Input Data tool.

[en] DSN Connection Using DCM

  1. [en] Make sure that DCM is enabled.

  2. [en] Place the Input Data tool on the Designer canvas.

  3. [en] Below the Connect a File or Database field, select Set Up a Connection.

  4. [en] Choose Microsoft Azure SQL Database - ODBC from Data Sources.

    MSQL ODBC

  5. [en] Select the Add Data Source button.

    Add Data Source

  6. [en] Enter a descriptive Data Source Name.

  7. [en] Enter the name of DSN created in ODBC Data source manager and select Save.

    Enter a name of DNS

  8. [en] Select Connect Credential.

    Connect Credentials

  9. [en] For Authentication Method select No Credentials.

  10. [en] Select Link.

    Click Link

  11. [en] Select Connect.

    Click Connect

  12. [en] External browser is triggered to enter credentials.

  13. [en] Choose any table from your database in the Query Builder.

  14. [en] Select OK.

注意

[en] Credentials are required for each setting change and workflow run. To eliminate this, set Cache Data on the Input Data tool.

[en] DSN-less Connection

[en] You can establish a DSN-less connection using Data Connection Manager (DCM) or without it.

[en] DSN-less Connection without DCM

  1. [en] Place the Input Data tool on the Designer canvas

  2. [en] Enter this Connection string in the Connect a File or Database field:

    [en] odbc:Driver={ODBC Driver 17 for SQL Server};Server=tcp:<_your_server_>,1433;Database=<_your_db_>;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;Authentication=ActiveDirectoryInteractive

    [en] Replace the text between the <> with actual values.

  3. [en] Select the 3 dot icon next to the Table or Query option.

  4. [en] An external browser is triggered to enter credentials.

  5. [en] Choose any table from your database in the Query Builder.

  6. [en] Select OK.

注意

[en] Credentials are required for each setting change and workflow run. To eliminate this, set Cache Data on the Input Data tool.

[en] DSN-less Connection Using DCM

  1. [en] Make sure that DCM is enabled.

  2. [en] Place the Input Data tool on the Designer canvas.

  3. [en] Below the Connect a File or Database field select Set Up a Connection.

  4. [en] Choose Microsoft SQL Server - Quick connect from Data Sources.

    MSQL Server Quick Connect

  5. [en] Select the Add Data Source button.

    Add Data Source

  6. [en] Provide a descriptive name for Data Source Name, actual server, and database name.

  7. [en] Make sure the Driver is set to ODBC Driver 17 for SQL Server.

  8. [en] Select the Save button.

    Click on Save

  9. [en] Select Connect Credential.

  10. [en] Choose or provide Azure Active Directory Interactive for Authentication Method and select Link.

    Click Link

  11. [en] Select Connect.

  12. [en] An external browser is triggered to enter credentials.

  13. [en] Choose any table from your database in the Query Builder.

  14. [en] Select OK.

注意

[en] Credentials are required for each setting change and workflow run. To eliminate this, set Cache Data on the Input Data tool.

: