Getting Started with Alpana Dashboard Platform
In this training course, we will connect to a
Microsoft SQL Server to get data, create a dashboard using
Alpana Dashboard Designer and publish it to a server via
Alpana Dashboard Server.
Finally, we will visualize the
dashboard in a web browser.
This course is not intended to be an exhaustive instruction manual or a reference guide. It’s a walk-through to
quickly publish a dashboard using code192
Alpana Dashboard Designer and code192
Alpana Dashboard server.
At the end of this course, we will be able to visualize a dashboard with one widget like this one below.
Show me how
1. Connect to Microsoft SQL Server
First of all, let’s connect to a
Microsoft SQL Server via the
Alpana Dashboard Designer.
After opened the
Alpana Dashboard Designer, the software invites you to add a
data source, let’s do it by clicking
connection to the
data source. In our example this will be a database, but it could be an Excel file, CSV file,
Wonderware Historian server via our
WEB API or a Web data connector.
Let’s use the Microsoft Nothwind Database as sample data. If you want to reproduce this example, don’t hesitate to get it here https://northwinddatabase.codeplex.com/ to restore the database to your SQL Server.
Set the needed information to connect to your server, select the Northwind database.
To ensure the settings are correct, you can click
Test Connection, to try to connect to your server, if all the settings are correct, the following window should appear like below.
Click OK button to close the confirmation message and then click Connect button in New Connection dialog.
Then, click the
Connect button in New Connection dialog. Now the following view displayed.