Data sources

MS SQL Server

This article explains how to access an MS SQL Server from Peakboard. To add the data source, right click on [Data] or alternatively click on the […] button and then select [Add data source] and [SQL server] (1).

Add data source

Give the data source a name (1). Besides the host name (2) you need to specify the user name (3), password (4) and the database (5) you want to use. If a host has multiple SQL server instances, append the desired instance to the host name with a backslash.

The SQL statement (6) can be as complicated as you like. You should create very complex queries in a view in SQL Server and then query the view with Peakboard.

With [Load data] (7) you can check the data and then use it in your project.

SQL Dialog

We are learning from you!

Did you find this article helpful?

Be enlightened!

Do you need more support?

Peakboard Youtube icon Visit our YouTube channel

Our numerous videos for beginners and advanced users explain exactly how to design your dashboard.

Peakboard Templates icon Visit the Peakboard Templates

Download our templates for various use cases for free.

Peakboard icon Visit

Find out all about Peakboard and browse our different use cases and success stories.