Microsoft SQL Server Database Creation Requirements

This section describes the Microsoft SQL Server instance and database configuration requirements for Oracle Enterprise Performance Management (EPM) System and Repository Creation Utility (RCU) schemas.

Important Notice:

  • The Microsoft SQL Server instance used for EPM must be created with a case-insensitive collation. The SQL Server instance must not use a binary collation, including collations that contain BIN or BIN2, such as SQL_Latin1_General_CP850_BIN2.

  • Oracle Hyperion Financial Management (HFM) is not supported on a SQL Server instance that uses a binary collation.

  • The SQL Server instance collation is defined when the SQL Server instance is created. Therefore, configuring only the EPM repository database with a case-insensitive collation does not satisfy this requirement if the SQL Server instance itself was created with a binary or other unsupported collation.

  • Oracle recommends and supports the SQL_Latin1_General_CP1_CI_AS case-insensitive collation for the SQL Server instance and EPM repository database.

When creating a Microsoft SQL Server database for use as an EPM repository, configure the following settings for EPM products and RCU schemas:

  • ALTER DATABASE DATABASE_NAME COLLATE SQL_Latin1_General_CP1_CI_AS

  • Set READ_COMMITTED_SNAPSHOT = ON (Financial Management requires READ_COMMITTED_SNAPSHOT = OFF).

  • Set ALLOW_SNAPSHOT_ISOLATION = ON (Financial Management requires ALLOW_SNAPSHOT_ISOLATION = OFF).

  • Select the SQL Server and Windows authentication option when configuring the database security properties.

Microsoft SQL Server Database Creation Requirements for Repository Creation Utility (RCU):

Oracle recommends that you add a prefix to the user name that will correspond to the RCU schema prefix used during configuration.

You must also create a database to be used with the Repository Creation Utility (RCU).

For the RCU database, run these queries:

  • ALTER DATABASE DATABASE_NAME SET READ_COMMITTED_SNAPSHOT ON

  • ALTER DATABASE DATABASE_NAME COLLATE LATIN1_GENERAL_CS_AS