Summary

This article describes creation and use of a Database Connection.


Tip: You can add a Database Query to a Burst and deliver the query result in Excel or HTML format


Uses

Use a Database Connection and query for:


Create a Database Connection

To create an object, select Manage then a folder.

  • Select New > Database Connection
  • Type: Select a database type
  • Name: Enter a name
  • Configure Connection Details and Database Credentials
  • Select the Save button
  • Select the Test button to test the connection


Connection Details

SQL Server

Server: Enter a Database Connection String

Database: Enter database name

Timeout (Seconds): Timeout for initial database connection (max: 7200 seconds)


OracleServer: Enter a Database Connection String

Timeout (Seconds): Timeout for initial database connection (max: 7200 seconds)


ODBC

DSN: Select a System DSN (must exist in Windows > ODBC Data Sources (64-bit) > System DSN)



Database Credentials

  • User: Enter username
  • Password: Enter password


Database Queries

Create a Query

  • Select the Queries tab
  • Select New Query button
  • Name: Enter a name
  • SQL: Enter SQL
  • Select the Save button


Test a Query

  • Select the query
  • Select the Run button
  • Enter parameter values if applicable and select Run


Trace Query Performance

  • Select a query
  • Check Trace Performance
  • Run the query
  • Select Performance button


Squirrel Actions

Execute one or more Actions based on execution of a Database Query from a Squirrel dashboard. Execution of an Action is based on a query parameter condition.


Example Squirrel Action scenario:

  • Squirrel dashboard consumer inputs a specific set of values in a dashboard
  • Input triggers a BI report Burst to execute
  • Burst automatically delivers PDF version of BI report to Squirrel dashboard consumer


Add a Squirrel Action

  • Select a query
  • Select the Add Squirrel Action button
  • Condition(s): Enter a query parameter condition (example: @State='Arizona')
  • Select Add Action
  • Add the Action to be executed when the condition is true. Multiple Actions can be added per condition.
  • Run in Background: Check this option to run Action(s) as background task. Recommended for long-running Actions.
  • Select Add button to add additional conditions (if applicable)


Test Squirrel Action

  • Select a query where Squirrel Actions are configured
  • Select the Run button
  • Enter parameter value(s)
  • Check Run Squirrel Actions
  • Select the Run button
  • Select Squirrel Actions button to see test result