Summary
This article describes the Database Connection object.
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
- Server: Enter a Database Connection String
- Database: Enter database name
- Timeout (Seconds): Adjust to time out an idle or long-running query (max: 7200 seconds)
- Server: Enter a Database Connection String
- Timeout (Seconds): Adjust to time out an idle or long-running query (max: 7200 seconds)
Database Credentials
- User: Enter user name
- Password: Enter password
Create a Query
New Database Connection
- Name: Enter a name
- SQL: Enter SQL
- Timeout (Seconds): Adjust to time out an idle or long-running query (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): Adjust to time out an idle or long-running query (max: 7200 seconds)
- Select the Save button
Test a Query
- Parameters: Enter parameter values if applicable
- Select the Run button