Intro
Azure SQL users can connect their data to Domo through Cloud Amplifier native integrations. Get started by providing connection parameters, then select the tables you want to see as Domo DataSets.Create an Azure SQL Integration
Follow the steps in this article to configure a read-only Azure SQL–Domo integration:-
In the Domo Data Center, navigate to the
Data Warehouse.
-
Select
Add New Cloud Account.
The Amplify existing cloud warehouses modal displays.
-
In the Native integration section, choose See More to see additional options.
-
Select Azure SQL.
-
Select + Add New Integration.
-
Enter the following connection parameters in the provided fields to connect to your Azure SQL database:
- Integration name — If you need to update your integration in the future, this is the name to search for in the list of integrations.
- Integration description (optional) — Any additional information about the integration.
- Azure SQL Database connection URL — The host and port for the Azure SQL instance you are connecting to. Ex. < myhost.com:3306>.
- Azure SQL Database database name — The name of the database containing the tables you want to connect to.
- Azure SQL Database username — The Azure SQL instance username with access to the data you are connecting to.
- Azure SQL Database password — The password for the Azure SQL user.
-
Configure caching options at the bottom of the form and select Next. Learn about Cloud Amplifier caching rules.
A success message displays.
-
Select Choose Tables to Connect to open the table picker.
-
Use the table picker to select from schemas and tables. When you’re ready, select
Create DataSets.
-
(Optional)The confirmation modal allows you to share your DataSets with other Domo users. After choosing people to add and choosing their level of access in the dropdown, select
Share.
Or, select No Thanks to close the modal without sharing access.
