Microsoft | Azure Synapse Analytics

Azure Synapse Analytics is a comprehensive enterprise service that speeds up the time to insight across data warehouses and big data systems. It combines the strengths of SQL technologies for enterprise data warehousing, Apache Spark for big data processing, and Azure Data Explorer for log and time series analytics.

Azure Synapse Analytics Integration with ADOC

ADOC extends its data reliability capabilities to data visualized through Azure Synapse Analytics. Using Azure Synapse Analytics as a data source in ADOC allows users to monitor and ensure the dependability and integrity of their visualized data, facilitating real-time data processing and analytics.

Integration Steps for Azure Synapse Analytics as a Data Source

Azure Synapse Analytics Data Source

Follow the steps to add Azure Synapse Analytics as a data source:

1. In the left pane,click the Register icon.
2. Click the Add Data Source button.
3. Select the Azure Synapse Analytics data source. The Data Source Details page is displayed.

Azure Synapse Analytics Data Source Details

4. In the Data Source Name field, enter a name for the data source.
5. (Optional) Enter a description for the data source in the Description field.
6. Enable the Data Reliability capability by switching on the toggle switch.
7. Select a data plane from the Select Data Plane drop-down menu.
8. Click Next. The Enter Connection Details page appears.
9. Enter the Azure Synapse Analytics Workspace.
10. Select a Synapse Workspace Pool Configuration.
    1. Synapse Dedicated SQL Pool
       1. Enter the Synapse Dedicated SQL Pool Name.
       2. Enter the Synapse user name.
       3. Enter the Synapse password.

Azure Synapse Analytics Connection Details

11. (Optional) Enable Use Managed Identities if you would like to use managed identities.
    1. Enter the Synapse Dedicated SQL Pool Name
    2. Enter the Synapse user name.
    3. Enter the Synapse password.

Azure Synapse Analytics Managed Identities

12. (Optional) Enable Use Service Principal if you would like to use service principal.
    1. Enter the Azure Synapse Analytics Workspace name.
    2. Choose the Synapse Workspace SQL Pool Config.
    3. Enter the Synapse Dedicated SQL Pool Name.
    4. Enter the service principal's Client ID.
    5. Enter the service principal's Client Secret.
    6. Enter your Azure tenant ID.

Azure Synapse Analytics Service Principal

13. (Optional) Enable Use Secret Manager if you would like to use secret manager.
    1. Enter the Azure Synapse Analytics Workspace name.
    2. Choose the Synapse Workspace SQL Pool Config.
    3. Enter the Synapse Dedicated SQL Pool Name.
    4. Enter the Synapse User Name.
    5. Enter the Secret Configuration Name.
    6. Enter the Secret Key/Name.

Azure Synapse Analytics Secret Manager

14. Select the Dataplane Engine, either Spark or Pushdown Data Engine, for profiling and data quality.

Azure Synapse Analytics Dataplane Engine

15. Click Test Connection. If your credentials are valid, you will receive a Connected message.

Note If the Test Connection button does not return a successful connection, recheck your input details for any errors and ensure your network connectivity.