Documentation for CXO-Cockpit Reporting Suite 5.0, click for CXO-Cockpit Reporting Suite 4.3 Documentation or check the CXO-Cockpit Website.

Configuring HFM Database access

From CXO Cockpit Reporting Suite Documentation
Jump to: navigation, search

CXO Cockpit never changes data in HFM database and we recommend to create a read-only user to access the database. 2 database types are currently supported: Microsoft SQL Server 2005+ and Oracle 9+.

Configuring access to Microsoft SQL Server

SQL Server

The name of the server where the HFM database is stored. Examples:

  • myserver (for default instance of Microsoft SQL Server)
  • myserver\myinstance (for named instance of Microsoft SQL Server)

Database

The name of the database where the HFM applications stored their data.

User

The name of the native SQL user that can be used to connect to the HFM Database. This can be a read-only user.

Password

The password of the SQL User. Will be stored in the CXO-Cockpit database with encryption.

Configuring access to Oracle

In order to use Oracle database Oracle Data Provider for .NET (ODP.NET) must be installed on the CXO Cockpit server. Read more on Prerequisites page.

Oracle Server

The name of the server and SID where the HFM database is stored. Examples:

  • myserver/mysid (for default port)
  • myserver:1226/mysid (for specific port)
  • mytnsentry (if you have a TNS Alias for your oracle instance)

Schema Owner

The owner of the HFM tables.

User

The name of the user that can be used to connect to the HFM Database. This can be a read-only user.

Password

The password of the Oracle User. Will be stored in the CXO-Cockpit database with encryption