1. Getting Started.
   1. Connecting to a Server
   2. Adding a Widget
2. Chart Example Data Formats - Light / Dark / Pastel Themes
3. sqlChart - Command Line SQL Chart generator
4. Forms
   1. Simple Form Example - Taking user input to customize an SQL query
   2. Advanced Forms - Multiple Input Components and Dynamically specifying options
5. Database Examples
   • Charting data from a kdb+ Database
   • Real Time Charting of kdb+ Database Tick Data 
6. FAQ

View Quick Start Video

Getting Started

If you installed sqlDashboards for windows you can start it from the start menu, on linux/macs you should be able to make the jar executable and run it as long as you have java 1.6+ installed. (Click here for detailed instructions)

Connecting to a Server

When you first open sqlDashboards it will look like the image below.

1. Click on the menu options Server->Add Server or on the add server button on the toolbar.
2. Enter the server details and click add

Adding a Chart

Now that you have added a server.

1. Click the "Add Chart" button
2. Enter your query e.g. for kdb: ([] tt:asc 10?.z.t; a:asc 10?10; b:asc 10?10.0)
3. Press the "Set Query" button and the widget area should be updated shortly with your graph.

Optionally select a different graph type or set the name of the chart by typing it into the "Title:" box and pressing enter.