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)
- Examples:
- Catalog: Enter database name
- Server:Enter database server address
- 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)
- Examples:
- Connection String:Enter database server address
- SQL Server
- 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