Data sources

MS SQL Server

This article explains Peakboard’s access to an MS SQL Server. The dialogue is almost self-explanatory. In addition to the host name, the user name, password and the database (Initial Catalog) must be filled in. If a host has multiple SQL Server instances, the desired instance is simply attached to the host name with a backslash.

The SQL statement can be complicated as required. At this point, we recommend that you rather place very complex queries in a view in SQL Server and read them from here to the view.

The Load button executes the SQL statement once and fills the column data. From then on, the preview should also work and the dataset is available in Peakboard for further processing.

Add SQL Server Data

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 www.peakboard.com

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