Product specifications

Related Topics
• http://technet.microsoft.com/en-us/library/cc917711.aspx
• http://technet.microsoft.com/en-us/library/cc917712.aspx
7.4 Oracle EBS connections
The Data Access layer provides a new driver for connecting SAP BusinessObjects applications to
Oracle E-Business Suite (EBS) through OCI. It allows applications to access data from EBS views and
stored procedures. You can only use OCI to connect the driver to Oracle EBS.
When creating a connection in the universe design tool or information design tool, you first choose the
authentication mode, which is either user-supplied if the application user provides user name and
password when logging in to SAP BusinessObjects Business Intelligence platfrom, or single sign-on if
the user logs in with Oracle EBS credentials. You then choose the Oracle EBS application, responsibility
and security group, which define the datasource of your universe.
The BI platform provides SSO for Oracle EBS with the help of an authentication plugin. SSO is enabled
when the plugin is installed and configured properly. SSO allows the application user to login into the
BI launch pad with Oracle EBS credentials. Same credentials are used by Connection Server to access
Oracle EBS data source. For more information about the authentication plugin, refer to SAP
BusinessObjects Business Intelligence platform Administrator Guide .
7.5 Oracle Essbase connections
Caution:
Because of a limitation in the Essbase middleware for .unv universes, a specific deployment of the
SAP BusinessObjects BI platform server is required to support both .unv and .unx universes based
on Essbase. To deploy a server that supports both .unv and .unx Essbase universes, configure a
system with the two following clusters on two separate machines:
• In a 64-bit environment, install the following software on the first cluster (Cluster1): the 64-bit
BusinessObjects BI platform, the Central Management Server, Web Intelligence servers, a 64-bit
Connection Server, and all the 64-bit middleware drivers.
• In a 32-bit environment, install the following software on the second cluster (Cluster2): the 32-bit
Connection Server, and the 32-bit middleware drivers (including the 32-bit Essbase driver for .unv
universes).
At runtime, Connection Server uses Cluster2 for .unv universes. The OLAP Client, which serves .unx
universes, uses the 64-bit middleware available in Cluster1.
2012-03-1577
Connection reference