Managing Database Connections for Financial Reporting

In This Section:

The Database Connection Manager provides a means to manage reports, books, saved reports objects (row/column templates, grids), batches, and scheduled batches. Reports and report objects can be moved from a development environment to a production environment, or between production servers. The Database Connection Manager provides the following information about each database connection:

Name—The database connection name
Type—The data source type (Essbase, Analytic Services, Financial Management, Planning, SAP BW)

Value—The connection path

A designercan use EPM Workspace to create, maintain, and assign names to database connections.

Users can select an existing database connection when prompted throughout the Oracle Hyperion Financial Reporting Studio, Fusion Edition; for example, while adding a grid to a report. A database connection consists of a database name, ID, password, and several values that are different for each data source.

Table 2. Valid Database Values by Database

Database	Values
Essbase	Server. For accessing an Essbase Server, see Various ways to access an Essbase Server. Application Database Data Source Type
Financial Management	Server. For accessing an Essbase Server, see Various ways to access an Essbase Server. Application Data Source Type
Planning	Application Database Connection Data Source Type
SAP BW	Server. For accessing an Essbase Server, see Various ways to access an Essbase Server. System Number Client Application Database Data Source Type
MSOLAP	Server. For accessing an Essbase Server, see Various ways to access an Essbase Server. Application Database Data Source Type