Product specifications

Note:
JDBC connectivity is available for SAP BusinessObjects Enterprise XI 3.0 and higher. Web Intelligence
Rich Client supports JDBC connectivity in 3-tier mode in the SAP BusinessObjects Business Intelligence
platform 4.0 and higher.
SAP BusinessObjects software also includes configuration files for using JDBC drivers to access your
databases. To use these drivers, you do the following:
1.
Obtain the java driver software from your database supplier.
2.
Specify JAR file paths by one of the following ways:
• Set the ClassPath element in the SBO configuration file of the data access driver with the fully
qualified path of the JAR file.
• Store JAR files into directories you create from the Extensions parameter values of the SBO
file.
You can use simultaneously these two ways of specifying JAR file paths. However, JAR files specified
in the SBO file take precedence over JAR files stored in your own directories.
For an up-to-date list of supported JDBC drivers, check the SAP Service Marketplace at http://ser
vice.sap.com/bosap-support, or contact your SAP representative.
Note:
The Data Access layer provides the Generic JDBC connectivity to create a connection to a data source
that the SAP BusinessObjects Business Intelligence platform does not support explicitly.
Related Topics
• To create a JDBC connection with the SBO file
• To create a JDBC connection with Extensions
• To create a generic JDBC connection
• JDBC driver properties
5.3.1 To create a JDBC connection with the SBO file
In order to create a JDBC connection:
• Obtain the necessary JDBC driver software for the database, and copy the files to your system.
These files are available from the database vendor. The driver software consists typically of one or
more .jar files. Note the installation path details for these files.
• Ensure that you have the database access details to hand, for example the login and password
details.
1.
Navigate to the directory that contains the SBO file you want to use.
For example, on Microsoft Windows, the JDBC configuration files are located in the connection
server-install-dir\connectionServer\jdbc directory.
2.
Use an XML editor to open the SBO file for editing.
2012-03-1550
Creating a connection