Database connections are portable files that define terms, conditions, and methods for connecting to data sources. You must use Web Analysis Studio, not Web Analysis, to create and modify database connections.
Documents are dependent on database connection files to query data sources. A document can use multiple database connections to connect to one or more data sources.
To access data sources, you may be prompted to provide logon credentials.
Information provided in the view pane Information tab:
Database—displays the database connection name for the current data object
Database User Name—displays the user name by which access to the database connection is granted
Data sources and database connections supported by Web Analysis documents:
OLAP data sources
Analytic Services 6.5.6, 7.0.1, 7.1, and 7.1.2
IBM DB2 OLAP Server 7.1 Service Pack 11, 8.1 Service Pack 3, and 8.2
SAP BW 3.0, 3.1, and 3.5
Hyperion data sources
Financial Management 3.4, 3.5, 3.5.1, and 4.0
Planning 3.3, 3.5 with Analytic Services 3.5.1, and 4.0
Relational database connections:
Microsoft SQL Server
System RDBMS requirements vary. See the Oracle Enterprise Performance Management System Installation and Configuration Guide for descriptions of relational system requirements.