Summary
This article describes creation and use of a Database Connection.
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
| SQL Server | Server: Enter a Database Connection String Database: Enter database name Timeout (Seconds): Timeout for initial database connection (max: 7200 seconds) |
| Oracle | Server: Enter a Database Connection String Timeout (Seconds): Timeout for initial database connection (max: 7200 seconds) |
| ODBC | DSN: Select a System DSN (must exist in Windows > ODBC Data Sources (64-bit) > System DSN) |
Database Credentials
- User: Enter username
- 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