Connect to data and view it on a dashboard
This walkthrough shows you how to add a new connection to a data source and use it to display some data on a dashboard.
A SQL Server/Azure database is used for example purposes, but you can follow these steps for any data source.
2. Connecting to data
In order to create a data connector, you generally need to have some knowledge about the type of data source as well as the necessary permissions to connect.
In Dundas BI, you also need to be a user with at least power user access.
2.1. Create a new data connector
A data connector lets you connect to a data source by choosing a data provider and setting various fields that are specific to that provider.
You can create a data connector from anywhere in Dundas BI using the main menu on the left by clicking New, then Data Connector. You can also find this option in a few other places.
The New Data Connector dialog is scrollable with a number of fields to set depending on the type of data provider you want to use.
2.2. Choose a name and folder location
Your new data connector will need a name – click inside the Name box to open the Save dialog and enter one.
You can optionally change the folder Location within your Dundas BI project from the Data Connectors folder to a subfolder. To create a subfolder, right-click (or long-tap) an existing folder and choose Create Folder.
2.3. Select a data provider
You can connect to a wide range of data source types with Dundas BI. The data provider dropdown is set to Microsoft SQL Server by default, which is also used for connecting to Azure SQL and Azure Synapse.
Depending on the data provider selected, the remaining fields may be different.
Your administrator may need to install drivers on the Dundas BI server for certain data providers. For more information about supported data sources and their driver requirements, see Dundas BI - System Requirements.
Each data provider has its own settings for you to fill in. Hover over the field (long-tap on touch devices) for a tooltip popup providing a description. There may also be additional details available for certain data sources in the How To article subsection.
Many data providers offer more than one authentication method you can choose from, such as:
- Server Windows credentials
- Provider-specific options such as SQL Server authentication
- Specified Windows credentials
- Impersonated Windows credentials
- Active Directory credentials, for use with Azure
Fill in the requested credentials if required.
When connecting to a database such as our Microsoft SQL Server example, the following settings or similar are typical:
- Data Source – The name of your database instance or database server (e.g., often this is just the server name), or its network/internet address.
- Initial Catalog – The database name.
There are typically other optional or advanced settings you can configure. Click through the expandable sections to access other settings, and hover over with your mouse or long-tap a field to see its tooltip description.
2.5. Test the connection
Once you have set the required data connector fields, click Test connection as a quick way of verifying the settings you just entered.
By default, the Check In option is checked so that other users with access to the current project can also use the data connector as soon as it's created.
Finally, click the Submit (checkmark) button at the bottom of the New Data Connector dialog to create the connector.
You'll see a message telling you the data connector was created and that a discovery operation was started. Discovery retrieves information about native data structures such as tables, stored procedures, and functions. You don't need to wait for the discovery operation to complete because it runs in the background.
If you want to make changes to the data connector, you can re-open it from the main menu.
3. Viewing data
Now that you have a data connector providing access to a data source, you can display some data using a metric set or dashboard, for example. The quick walkthrough below shows a dashboard.
3.1. Create a new dashboard
Use the main menu to create a new dashboard.
Select the Blank template for your new dashboard.
The dashboard editor is displayed. It consists of a main menu on the left, a toolbar along the top, a status bar along the bottom, and the actual design surface with horizontal and vertical rulers. The white area within the design surface represents your dashboard and is generally referred to as the canvas. You can drag and drop items onto the canvas in order to compose your dashboard.
3.2. Find your data connector
Click the Explore window, which is docked on the right, to see all the items within the current project.
Expand the Data Connectors folder to see the data connector created previously. Further expand the data connector itself to see the native data structures discovered, including database tables and programmatic structures such as stored procedures and functions.
3.3. Drag a table of data to the canvas
Under your data connector, scroll down and locate a specific table or sheet of data you want to see. As an example, drag the table or sheet and drop it onto the canvas.
When you drag a table, the entire table of raw data will appear as a table visualization. Dundas BI connects live to data sources by default (other than data that has been imported such as a dropped Excel file).
This automatically creates a metric set you can use to analyze the data. You can also start by dragging individual columns containing the data you want visualized. For more details on using metric sets, see Metric set analysis tools.
3.4. View the dashboard
Click View in the toolbar to switch to View mode. This lets you interact with your dashboard, such as using the scrollbars on the table visualization. Click Edit in the toolbar to go back to Edit mode.