Intro
Azure Synapse SQL lets you quickly implement a high-performance, globally available, and secure cloud data warehouse. Use Domo’s Azure Synapse SQL Connector to bring your Azure data into Domo. You connect to your Azure Synapse SQL database in the Data Center. This topic discusses the fields and menus that are specific to the Azure Synapse SQL Connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Connector.Prerequisites
To connect to an Azure Synapse SQL database and create a DataSet, you must have the following:- The username and password you use to log into your Azure Synapse database.
-
The server name for the database. You can find this by doing the following:
- Log into Azure Portal.
- Click on Azure Synapse Analytics.
- Click on the Synapse SQL Pool you want to connect to.
- Locate the full server name. Example yourserver.database.windows.net
- The port number for the database
- The database name
Connecting to Your Azure SQL Database
This section enumerates the options in the Credentials and Details panes in the Azure Synapse SQL Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Connector.Credentials Pane
This pane contains fields for entering credentials to connect to your Azure Synapse SQL database. The following table describes what is needed for each field:Field | Description |
|---|---|
JDBC Driver | Select the JDBC driver you want to use from the drop-down list. |
Server Name | Enter the name of your server. For information about finding the server name, see “Prerequisites,” above. |
Database Name | Enter the name of the Azure Synapse database. |
Port | Enter the port number for the Azure Synapse database. |
Username | Enter the username you use to log into your Azure Synapse database. |
Password | Enter the password you use to log into your Azure Synapse database. |
Hostname in Certificate | Enter the h ostname in certificate obtained from the show database connection strings. |
Details Pane
In this pane you create an SQL query to pull data from your database. The Query parameter is required. The other three parameters are here to help you construct this query, if you choose.Menu | Description | ||||||
|---|---|---|---|---|---|---|---|
Query Type (Mandatory) |
| ||||||
Query (Mandatory) | Enter the Structured Query Language (SQL) query to use in selecting the data you want. For example: select * from Employee If you want help in constructing your query, copy and paste the automatically-generated query from the Query Helper field into this field. | ||||||
Database Tables (Mandatory) | Select the table containing the data you want to pull into Domo. The selected table will be added to the automatically generated query in the Query Helper field. | ||||||
Table Columns (Mandatory) | Select the table columns with data you want to pull into Domo. The selected columns will be added to the automatically generated query in the Query Helper field. | ||||||
Query Helper (Mandatory) | Copy and paste this query into the Query field if you need in help building a query. This query is automatically generated when you select a table and columns in the Database Table and Table Columns fields, respectively. | ||||||
Limit Buffer Size | Select the checkbox if you want to limit the maximum heap memory used by ResultBuffer. | ||||||
Convert BIGINT to LONG | Select this check box if you want to convert the BIGINT columns to LONG. |