If enabled by your administrator, pass-through enables you to access data sources without entering a username and password for each data source. For pass-through to work for Interactive Reporting jobs or files associated with multiple, Interactive Reporting database connections, these conditions are necessary:
Interactive Reporting database connections is configured for pass-through.
Credentials required to access each data source are identical.
Note: | Oracle recommends selecting similarly configured Interactive Reporting, database-connection files when importing Interactive Reporting documents. To enable users doing imports to make this selection, Interactive Reporting database connection names should indicate whether the database connection is configured for pass-through. |
When Interactive Reporting jobs and files with some but not all Interactive Reporting database connections configured for pass-through are processed:
Interactive Reporting database connections configured for pass-through—Users are not prompted for logon credentials.
Interactive Reporting database connections not configured for pass-through—The credential option selected when the job or file was imported (prompt user, specify now, or use the default) is used.
Caution! | For pass-through processing of all queries, Interactive Reporting database connections must have identical database credentials. |