Oracle Essbase Data Source

Before connecting to an Oracle Essbase data source, some configuration is required if the data source uses scenario dimensions, hierarchies, or measures.

When a Oracle Essbase System 9 Data Source is configured with an LDAP namespace, single signon is supported. The user ID and password used to log on to the LDAP namespace automatically connects to the data source. For more information about configuring an LDAP namespace, see the IBM Cognos Business Intelligence Installation and Configuration Guide.

You specify connection parameters when you create a data source or modify a data source connection. For more information, see Data Source Creation and Add or Modify a Data Source Connection.

Table 1. Oracle Essbase data source parameters
Parameter	Description
Server name	Enter the name of the server where the database is located. For UNIX operating system, this can be the TCP/IP address of the server.
Signon	For more information on signon, see Securing data sources. If no authentication is required, click No authentication. For Essbase Server System 9 and IBM Cognos 8.4, single signon is supported if your Essbase server is configured for an LDAP namespace. Select An external namespace and select LDAP from the list. The user ID and password used to log on to the LDAP namespace automatically connects to the data source. If a user ID and password is required in the connection string, click Signons. If a password is required, select the Password check box and enter the password in the Password and Confirm password boxes. To create a user ID and password that automatically connects to the data source, click Create a signon that the Everyone group can use. Enter the User ID and then enter the password in the Password and Confirm password boxes.