Data sources (generic data storage mechanisms) can be multidimensional databases, relational databases, or files. Database connections are portable files stored in the repository. They define the terms, conditions, and methods for connecting to data sources. In Oracle Hyperion Enterprise Performance Management Workspace, you cannot create or modify database connections; rather, you must use the applicable Oracle Hyperion Reporting and Analysis product. You see only database connections that you own and to which you are granted permissions. Multiple permissions are needed to read, write, edit, and change database-connection file properties. For permission descriptions, see the Oracle Hyperion Enterprise Performance Management Workspace Administrator's Guide.
Database servers typically use server, application, and database names to create unique identifiers. Such identifiers make database references not readily portable. The studios use database aliases instead of long identifiers. Aliases are easier to remember and more economical to employ and enable a database to be maintained on multiple servers.
Repository documents are dependent on a database-connection file to query data sources for values. A document can use only one database connection but can use any of several data sources.
For a complete list of supported data sources and relational databases by Reporting and Analysis product, see Oracle Enterprise Performance Management System Installation and Configuration Guide.
Different data sources have different system requirements. See the Oracle Enterprise Performance Management System Installation and Configuration Guide for descriptions of system requirements.
The View pane displays specific information for the document currently open in the content area. For example, the database connection used by the current data object. The View pane displays two database connection segments for Oracle Hyperion Web Analysis:
The Database segment displays the database connection name for the current data object.
The Database User Name segment displays the user name by which access to the database connection was granted.