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)


Oracle


Database Credentials

  • User: Enter user name
  • Password: Enter password


Create a Query


New Database Connection

  • Name: Enter a name
  • SQL: Enter SQL
  • Timeout (Seconds): Timeout for initial database connection (max: 7200 seconds)
  • Select the Save button


Database Connection with existing queries

  • Select the New Query button
  • Name: Enter a name
  • SQL: Enter SQL
  • Timeout (Seconds): Timeout for initial database connection (max: 7200 seconds)
  • Select the Save button


Test a Query

  • Parameters: Enter parameter values if applicable
  • Select the Run button