Product specifications

7.6 Oracle RAC connections

The Data Access layer allows the SAP BusinessObjects Business Intelligence platform to connect to

Oracle Real Application Clusters (RAC) through JDBC.

To create a connection from your application using the connection wizard, you need to provide the

Oracle RAC datasource entry, which has the following format:

The number of host and port pairs depends on the number of machines involved in the cluster.

Example:

pmrac1.us.oracle.com:1521,pmrac2.us.oracle.com:1521

7.7 salesforce.com connections

Before you create a connection to salesforce.com from the connection wizard, configure your environment

as follows:

Stop the Connectivity Service from the CMC and the client application.

Run regedit.exe in the MS Windows command line to open the Registry Editor.

Go to the Salesforce ODBC data source under HKEY_LOCAL_MACHINE > SOFTWARE > ODBC

> ODBC.INI > <SALESFORCE_DSN_NAME>, where SALESFORCE_DSN_NAME is the salesforce.com

data source name.

Right-click Add New String Value.

Type in CheckJVMChanged.

Double-click the property and type in 0.

Close the Registry Editor.

Open the cs.cfg file for editing.

In the JavaVM section, add the following path:

<Path>C:\Program Files (x86)\Progress\DataDirect\Connect_for_ODBC_61\java\lib\sforce.jar</Path>

</ClassPath>

10.

Save the file.

11.

Open the openaccess.sbo file for editing.

It is located in the connectionserver-install-dir\connectionServer\odbc directory.

12.

Set Transactional Available parameter to No.

2012-03-1578

Connection reference