Whenever you use Interactive Reporting to query a relational database and retrieve information, the Interactive Reporting database connection file and data model are used to interact transparently with the database. The Interactive Reporting database connection file and data models are not visible to the end user in the EPM Workspace.
The Interactive Reporting connection file encapsulates and stores connection information used to connect Hyperion applications to a database. Interactive Reporting database connection files specify the database API(ODBC, SQL*Net, etc.,), database software, the network address of the database server, and your database user name. An end-user can specify the Interactive Reporting database connection file and database password and logon. It is required for an Interactive Reporting document file (BQY) to reference live information from the database.