Skip to main content

​
Intro

Azure Synapse Analytics lets you quickly implement a high-performance, globally available, and secure cloud data warehouse. Use Domo’s Azure Synapse Active Directory Service Principal SQL connector (formerly the Azure SQL Data Warehouse connector) to bring your Azure data into Domo. Combine your Azure data with data from other sources throughout your company for a comprehensive view of your business. Set up custom alerts to be notified in real-time when your key metrics change, so that you can make faster, better business decisions. You can connect to your Azure Synapse Active Directory Service Principal account in the Data Center. This topic discusses the fields and menus specific to the Azure Synapse Active Directory Service Principal connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your Azure Synapse Active Directory Service Principal account and create a DataSet, you need the following:
  • Server Name
  • Port
  • Database
  • Azure App Service Principal Client Id
  • Azure App Service Principal Client Secret
  • Host Name In Certificate

​
Connecting to Your Azure Synapse Active Directory Service Principal Account

This section enumerates the options in the Credentials and Details panes on the Azure Synapse Active Directory Service Principal Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Connector.

​
Credentials Pane

This pane contains fields for entering credentials to connect to your Azure Synapse Active Directory Service Principal account. The following table describes what is needed for each field:

Field

Description

Server Name

To know your server name:

  1. Navigate to the Azure Portal.
  2. Click Azure Synapse Analytics.
  3. Click the Synapse SQL Pool you want to connect.
  4. Locate the full server name. For example, yourserver.database.windows.net
Port Enter the port number from where the server is listening.
Database Enter the name of the database that you want to connect to.
Azure App Service Principal Client Id Enter your Active Directory Service Principal client id.
Azure App Service Principal Client Secret</td><td colspan="1" rowspan="1">Enter your Active Directory Service Principal client secret.
Host Name In Certificate Enter the host name to be used to validate the SQL Server TLS/SSL certificate.
Once you have entered valid Azure Synapse Active Directory Service Principal credentials, you can use the same account at any time to create a new Azure Synapse Active Directory Service Principal DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.

​
Details Pane

Menu Description
Query Type
Query Type Description
Custom Query Enter the query to execute.
Query Builder Select a table and fields to autogenerate your query.
Query Enter the SQL query to execute.
Database Tables Select the table.
Table Columns Select the columns.
Query Helper This field is automatically generated using the above selected fields. Updating the auto generated query will not update your selections in the above Field table.
Query Time Out The number of seconds to wait before a timeout has occurred on a query. The default value is -1, which indicates infinite timeout. Setting this value to 0 also implies to wait indefinitley.
MaxResultBuffer

maxResultBuffer can be used to set the maximum bytes to read when reading a result set. If this is not specified, then the entire result set is read. Size can be specified in two styles:

  1. As size of bytes (for example, 100, 150M, 300K, 400G).
    1. As a percent of maximum heap memory (for example, 10p, 15pct, 20percent).

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Connector.