Search results

Connecting Bold BI to Azure Synapse Analytics data source

The Bold BI Dashboard Designer supports connecting Azure Synapse Analytics database using SQL Live Query (C# API).

Choose Azure Synapse Analytics data source

To configure the Azure Synapse Analytics data source, follow these steps:

  1. Click Data Sources in the configuration panel to add a new data connection.

    Data source icon

  2. Click CREATE NEW to launch a new connection from the connection panel.

  3. Select the Azure Synapse Analytics connection in the connection panel.

    Choose data source

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.

Choose data source from server

Connect to Azure Synapse Analytics

Create Azure Synapse Analytics data source

After clicking a data source, the NEW DATA SOURCE configuration panel opens. Follow the given steps to create a Azure Synapse Analytics data source:

  1. Enter a name and description (optional) for the data source.

  2. Enter a valid server or host name in the ServerName text box.

  3. Enter a valid username in the UserName text box.

  4. Enter a valid password in the Password text box.

  5. 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.

    Azure Synapse Analytics Connection

NOTE: Azure Synapse Analytics supports live mode connection only.

Data Preview

  1. 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.

    Treeview schema

  2. Now, the data design view page with the selected table schema opens. Drag the table.

    Query designer

    You can use the Code View option for passing a query to display data.

    Codeview mode

  3. Click Save to save the data source with a relevant name.

Data Transformation

Editing a Data Connection

Dashboard Designer Walkthrough

Azure Synapse Analytics Integration