Configuring the SAP R3 Native Repository

Before configuring an SAP native repository, ensure that you have met the prerequisites described in “Single Sign-on with SAP Enterprise Portal” in the Oracle Hyperion Enterprise Performance Management System Security Administration Guide.

By default, EPM System sets a SAP keystore timeout of 10 seconds. After configuring an SAP provider, you can change the timeout by editing the security options. See Setting Security Options.

  To configure an SAP native repository:

  1. Launch Shared Services Console. See Launching Shared Services Console.

  2. Select Administration, and then Configure User Directories.

  3. Click New.

  4. On the Directory Type screen, select SAP, and then select Next.

    Illustration of SAP Connection Information screen
  5. On the SAP Connection Information screen, enter configuration parameters.

    Table 4.  SAP Connection Information Screen

    LabelDescription[1]
    NameA unique configuration name for the SAP provider. You use this name to identify the SAP provider in situations in which multiple SAP providers are defined in Shared Services.

    Example: MY_SAP_DIRECTORY

    SAP Server NameThe DNS name of the computer where the SAP Server is running, or the SAP router address.

    Example: myserver

    Client NumberThe client number of the SAP system to which you want to connect.

    Example: 001

    System NumberThe system number of the SAP System to which you want to connect.

    Example: 00

    User IDThe user name that Shared Services should use to access SAP. This user must have access permissions to use Remote Function Calls (RFC) to connect to SAP and to access user, activity groups, and their relationship data.

    Example: my_sap_user

    PasswordThe password of the user identified in the User ID box.

    Example: my_sap_password

    Max EntriesThe maximum entries that a query to the SAP provider can return. If you are configuring Shared Services in Delegated Administration mode, set this value to 0.

    Example: 100

    Pool SizeThe JCo connection pool size.

    Default: 20

    Pool NameA unique name for the connection pool that should be used to establish a link between Shared Services and SAP.

    Default: HYPERION_SAP_POOL

    LanguageLanguage for messages, for example error messages, from SAP. By default, this value is read from the system locale of the server hosting Shared Services.

    Example: EN

    Location of SAP Digital CertificateThe SAP X.509 certificate to use. EPM System products use this certificate to parse the SAP login ticket and to extract the user ID needed to support SSO. Required only if EPM System products are plugged into SAP Enterprise Portal.

    Example: C:/Oracle/Middleware/EPMSystem11R1/common/SAP/bin/SAP_cert_name.

    SSL EnabledCheck box that enables you to use Secure Socket Layer (SSL) to communicate between Shared Services and the SAP provider.
    TrustedCheck box that enables you to specify that this provider is a trusted SSO source. SSO tokens from trusted sources do not contain the user's password.
    Show Advanced OptionsThe check box to display custom authentication setting.
    Authentication ModuleSelect this check box to enable the use of a custom authentication module to authenticate users defined in this user directory. You must also enter the fully qualified Java class name of the authentication module in the Security Options screen. See Setting Security Options.

    See “Using a Custom Authentication Module” in the Oracle Hyperion Enterprise Performance Management System Security Administration Guide.

    1 EPM System security may use default values for fields for which configuration values are optional. If you do not enter values in such fields, default values are used during runtime.

  6. Click Save.

    Shared Services saves the configuration and returns to the Defined User Directories screen, which now lists the SAP provider that you configured.

  7. Test the SAP native repository configuration. See Testing User Directory Connections.

  8. If needed, change the search order assignment. See Managing the User Directory Search Order for details.

  9. If needed, specify security options. See Setting Security Options for details.

  10. Restart Shared Services and all EPM System products.