If you are having problems using the SQL tile to add SQL queries into SquaredUp please check the following:
Here are a few things to check if you're finding the SQL tile shows no data.
Test the query in SQL Server Management Studio
Run the query in SQL Server Management Studio on the SQL server. Are results shown? If not, then there is a problem with the query.
Check SquaredUp has access to the database being queried.
By default, access to the Data Warehouse database is configured during the SquaredUp setup process, but you will need to configure access to any other database.
Check that the SquaredUp application pool account has the db_datareader role on the database that is being queried. See How to configure access to a database for use with the SQL tile.
It is important to note that the account you are logging into SquaredUp with has no effect on database access. What is important is the user (identity) of the application pool inside IIS which is being used by SquaredUp.
Check the connection string in the SQL tile configuration.
To query the Data Warehouse the connection string can simply be set to:
To connect to any other database you will need to specify the server and database as described below:
Data Source=<SQLservername>;Initial Catalog=<DatabaseName>;Integrated Security=True;
For more information about connection strings see How to use the SQL tile - Connection String
Check that you are using the correct tile type (Grid or Scalar) depending on the results output in SQL Server Management Studio.
The SQL Grid tile should be used for queries that return a table of results.
The SQL Scalar tile should be used when the result of the query is a single number.
Line Graph shows "A value column and a timestamp column are mandatory in the query results, please modify your query"
This message is shown if the query results do not contain a DateTime field AND a Numeric value field, both of which are necessary for a line graph to be drawn.