Product specifications

10.1.6 JDBC driver properties
You can add JDBC driver properties by doing one of the following:
• In the connection wizard of your application, at connection creation, set the "JDBC Driver Properties
(key=value,key=value):" parameter. It is optional.
• Set driver properties in the appropriate SBO file after you stop Connection Server.
If the property is both set in the SBO file and through the wizard, only the value set through the wizard
is taken into account by the application.
Example:
This shows an example of the section of an oracle.sbo file modified with two driver properties.
<DataBase Active="Yes" Name="Oracle 10">
<Class JARFile="dbd_jdbc,dbd_oracle">
com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
<JDBCDriver>
<Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>
<Parameter Name="URL Format">jdbc:oracle:thin:@§DATASOURCE§:§DATABASE§</Parameter>
<Properties>
<Property Name="oracle.jdbc.defaultNChar">true</Property>
<Property Name="defaultNChar">true</Property>
</Properties>
...
</JDBCDriver>
...
</DataBase>
Related Topics
• To create a JDBC connection with the SBO file
10.2 Configuring data access for DataDirect ODBC branded drivers
Data Access supports the use of branded DataDirect ODBC 6.0 SP2 drivers for MS SQL Server
databases on all UNIX platforms. These branded DataDirect drivers are provided as part of the BI
platform and can only be used with SAP BusinessObjects applications such as SAP BusinessObjects
Web Intelligence and SAP Crystal Reports.
The following middleware and drivers are available for UNIX platforms only:
• MS SQL Server 2005 SP2
• MS SQL Server 2008
• MS SQL Server 2008 R2
2012-03-15117
Configuring data access driver parameters