...
Refresh time (in minutes) - after how much time the widget refreshes
SQL connection and command section - contains connection string, command, MogoDB fields
Data Representation - SQL widget accept 4 types of data representation: chart, table, counter and data points
...
SQL connection and command section
As it can be seen above the username, password, machine and script are read only. They can be edited by clicking Configure SQL Connection button.
...
Flowster Studio offers the possibility to use multiple databases types, via ODBC connections for the SQL widget, therefore an ODBC driver will be needed for each specific database type.
SQL Server – required info:
Hostname / IP Address
Instance name
Database name
...
Command - add the query to return data in the corresponding format for the data representation type
Run Script button - by clicking this button you can run the script entered. A preview will show.
Save button
Close button
Data representation
There are 4 types of data representations for this widget:
chart,
table
counter
data points
Data representation - Chart
...
Data representation - Table
...
Data representation - Counter
...
Data representation - Data points
...