Connecting Bold BI to Azure SQL Data Warehouse data source
The Bold BI Dashboard Designer supports connecting Azure SQL Data Warehouse database using SQL Live Query (C# API).
Choose Azure SQL Data Warehouse data source
To configure the Azure SQL Data Warehouse data source, follow these steps:
-
Click Data Sources in the configuration panel to add a new data connection.
-
Click CREATE NEW to launch a new connection from the connection panel.
-
Select the Azure SQL Data Warehouse connection in the connection panel.
NOTE: You can also create a data source from the home page by clicking the Data Sources menu from left menu panel and Create Data Source from the data sources page.
Connect to Azure SQL Data Warehouse
Create Azure SQL Data Warehouse data source
After clicking a data source, the NEW DATA SOURCE configuration panel opens. Follow the given steps to create a Azure SQL Data Warehouse data source:
-
Enter a name and description (optional) for the data source.
-
Enter a valid Azure SQL Data Warehouse server or host name in the ServerName text box.
-
Enter a valid Azure SQL Data Warehouse username in the UserName text box.
-
Enter a valid Azure SQL Data Warehouse password in the Password text box.
-
Select a database that you want to query in the listed database associated with the given Azure SQL Data Warehouse server in the database combo box.
NOTE: Azure SQL Data Warehouse supports live mode connection only.
Data Preview
-
Click Connect to connect the Azure SQL Data Warehouse server with configured details. The schema represents the collection list retrieved from the Azure SQL Data Warehouse server. This dialog displays a list of schemas in treeview and their corresponding values.
-
Now, the data design view page with the selected table schema opens. Drag the table.
You can use the Code View option for passing a query to display data.
-
Click Save to save the data source with a relevant name.