Interactive Reporting database connection files are used by Interactive Reporting jobs and files to connect to databases. Queries in a document can use different databases. In addition, an Interactive Reporting database connection file can be specified for each query of an file or job.
Before you can import files and jobs, you need access to all Interactive Reporting database connections that your document uses. Otherwise, the required database connection files are not displayed in the connection list. Ask your administrator for access to the required Interactive Reporting database connections.
If you use pass-through, see Pass-Through Using Multiple, Interactive Reporting, Database-Connection Files.
Note: | If no Interactive Reporting database connection file is specified for a query, users accessing the document cannot process the query unless it uses only local results. |
To access data source and query properties from Properties, select 2: Query from the left pane.
Property | Description |
|---|---|
Select a method for obtaining user names and password for queries:
You can override individual username or password combinations by selecting a method for each query connection. | |
Connection | Select an Interactive Reporting database connection file to use the query. For queries using only local results, select <No Connection>. If you are using pass-through, see Pass-Through Using Multiple, Interactive Reporting, Database-Connection Files. |
User name | Enter a user name, set one globally with the Connecting to Data Sources list; or set a one individually with the options list. |
Password | Enter the password to use for this query; or set globally with the Connecting to Data Sources list; or set individually with the options list. |
Options | Set the username and password using the selected method (default or prompted) |
Query Connections and Processing | Validate all queries that you process at runtime. |