The Bold BI Dashboard Designer supports connecting Azure Synapse Analytics database using SQL Live Query (C# API).
To configure the Azure Synapse Analytics 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 Synapse Analytics 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.
After clicking a data source, the NEW DATA SOURCE configuration panel opens. Follow the given steps to create a Azure Synapse Analytics data source:
Enter a name and description (optional) for the data source.
Enter a valid server or host name in the ServerName text box.
Enter a valid username in the UserName text box.
Enter a valid password in the Password text box.
Select a database that you want to query in the listed database associated with the given Azure Synapse Analytics server in the database combo box.
NOTE: Azure Synapse Analytics supports live mode connection only.
Click Connect to connect the Azure Synapse Analytics server with configured details. The schema represents the collection list retrieved from the Azure Synapse Analytics 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.