Properties for Microsoft SQL Server

  1. Navigate to EPM_ORACLE_HOME/common/config/11.1.2.0/RCUSchema.properties.

  2. Provide the required database details:

    Example RCUSchema.properties file for Microsoft SQL Server 

    sysDBAUser= EPMLogin
sysDBAPassword=<The sysdba password for RCU>
schemaPrefix=<The schema prefix used to create RCU>
rcuSchemaPassword=<you are prompted for schema password in the script>
dburl=jdbc:weblogic:sqlserver://<hostname>:<port=1433>;databaseName=TESTRCU

    Table 9-2 Properties for Microsoft SQL Server

    Property Description
    sysDBAUser The SYSDBA user for RCU.
    sysDBAPassword The SYSDBA password for RCU. The maximum password length is 16 characters.
    schemaPrefix The schema prefix used during RCU creation. Ensure it matches the Oracle Hyperion Shared Services Registry database user.
    rcuSchemaPassword The RCU schema password created while running RCU. The maximum password length is 16 characters and cannot start with a number or special character. Allowed special characters: $, #, _.
    dbURL Database URL:

    With SID dbURL=jdbc:weblogic:sqlserver://hostName:port;databaseName=databaseName
    For Essbase only
    schemaPrefixEssbase
    • The schema prefix used for creating the RCU schema for Essbase. Ensure that this prefix is unique and different from the schemaPrefix value.
    • The schema prefix must be at least 1 character long and no more than 12 alphanumeric characters (0-9, a-z, or A-Z), excluding the underscore character. It cannot begin with a number, and whitespace or special characters are not allowed.
    • The EPM Configurator will create the Essbase RCU schema based on the value entered in schemaPrefixEssbase.
    dbURLEssbase The database URL for Essbase. For example: dbURLEssbase= hostname:port:databasename

    Database URL Format for SSL:

    dbURLEssbase=serviceName?TNS_ADMIN=PATH_TO_WALLET_FILES

    Note:

    TNS_ADMIN must point to a folder containing sqlnet.ora, tnsnames.ora, a wallet, and ojdbc.properties files.