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:

• Parameter and filter values
• Delivery email address
• Tableau data source
• Database Query Event
• Run Query Action
• Bursting and delivering the results of a query
• Authentication Management
• XDC

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

Squirrel Store Tables

Create a table by adding columns manually.

• Select Add Table
• Name: Enter a table name
• Add a new Column:
  • Name: Enter a column name
  • Type: Select a column data type
  • Select Add Column
• Identity Column: Identity column is added to table automatically. Uncheck to omit identity column.
  • Name: Specify an alternate name for the identity column
• New Index: Optionally index one or more columns
  • Select New Index
  • Select column(s) (check box) to index
  • Select Save Index

CSV Data Import

Create a table by importing data from a CSV file.

• Select Choose File
• Select Import Data
• Name: Enter a table name (optional)
• Identify Column: Select this option to add an identity column to new table
• Select a column (left) to optionally change data type (Size) and rename a column (Name)
• Exclude: Select a column (left) and select Exclude to exclude the column from the new table
• Select Import

Queries

InfoBurst automatically creates "helper" queries under the Queries tab. Use existing queries or create new queries. See Database Queries below.

Summary Report

Select this option to create a PDF summary of the Squirrel Store.

Data Export

Select this option to export the Squirrel Store as Excel.

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
• Select CSV button to export test result as CSV

Trace Query Performance

• Select a query
• Check Trace Performance
• Run the query
• Select Performance button
• View performance history on Query Performance tab

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