Summary


This article describes the Database Connection data source.


Usage


Use a database connection/query for:

  • Parameter and filter values
  • Delivery email address
  • XDCs
  • Database Query Events
  • Run Query Action
  • Bursting and delivering the results of a query

Create a Database Connection
  • From the main user interface select the New button then DB Connection
  • Name: Enter a connection name
  • Timeout: Adjust to time out an idle or long-running query after X seconds (max: 7200 seconds)
  • Type:Select a database type
    • SQL Server
      • Server:Enter database server address
        • Examples:
          • <SERVER>
          • <SERVER\INSTANCE>
          • <SERVER>:<PORT>  (only if port is non-default)
          • <SERVER>:<PORT>\<INSTANCE>  (only if port is non-default)
      • Catalog: Enter database name
    • ODBC
      • Name: Enter ODBC connection name
      • InfoBurst only supports 32-bit ODBC connections
    • Oracle
      • Connection String:Enter database server address
        • Examples:
          • <HOST>/<SID>
          • //<HOST>/<SID>
          • <HOST>:<PORT>/<SID>  (only if port is non-default)
          • //<HOST>:<PORT>/<SID>  (only if port is non-default)
  • User: Enter database username
  • Password: Enter database password
  • Select the Add button

Create a Query
  • Select the New button
  • Name: Enter a query name
  • Timeout: Time out an idle or long-running query after X seconds (max: 7200 seconds). This setting is query-specific and overrides the database connection timeout setting. If this setting is set lower than the database connection timeout setting, the database connection timeout setting will be used.
  • Enter a query or reference a stored procedure under the SQL tab
  • Select the Add button
  • Test the query using the green arrowbutton
    • Enter a value under the Parameters tab if the query has a parameter
    • Query results are displayed on the Results tab
  • Select the Save button

Copy a Query
  • Select the Copy button

Default Column


Column used when query is used as a data source in a Burst.


Summary


Generate a PDF summary of a database query.

  • Select a query
  • Select Summary
  • Select Summary again to save PDF