JDBC data source connection configuration on SAP Business Objects

You can find the file under <Installation_path>\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc

jdbc.sbo file example (BOXI 3.1)

<?xml version=”1.0″ encoding=”UTF-8″?><!DOCTYPE DriverConfiguration SYSTEM “../sbo.dtd”><DriverConfiguration>
<Defaults>
<Class JARFile=”dbd_jdbc”>com.businessobjects.connectionserver.java.drivers.jdbc.JDBCDriver</Class>
<JDBCDriver>
<ClassPath>
<Path>$ROOT$/dbd_jdbcwrapper.jar</Path>
</ClassPath>
<Parameter Name=”JDBC Wrapper”>com.businessobjects.connectionserver.java.drivers.jdbc.wrapper.JDBCWrapper</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Generic</Parameter>
<Parameter Name=”SQL External File”>jdbc</Parameter>
<Parameter Name=”SQL Parameter File”>jdbc</Parameter>
<Parameter Name=”Description File”>jdbc</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>jdbc</Parameter>
<Parameter Name=”Connection Shareable”>Yes</Parameter>
<Parameter Name=”Shared Connection”>No</Parameter>
<Parameter Name=”Array Fetch Available”>True</Parameter>
<!–  define &quot;magic&quot; value 0 for Array Fetch Size to use default JDBC Fetch Size  –>
<Parameter Name=”Array Fetch Size”>0</Parameter>
<Parameter Name=”Array Bind Available”>False</Parameter>
<Parameter Name=”Max Rows Available”>Yes</Parameter>
<Parameter Name=”Query TimeOut Available”>Yes</Parameter>
</Defaults>
<DataBases>
<DataBase Active=”Yes” Name=”Generic JDBC datasource”>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>define java class for JDBC driver</Parameter>
<Parameter Name=”URL Format”>$DATASOURCE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Generic</Parameter>
<Parameter Name=”Version”>jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>jdbc</Parameter>
<Parameter Name=”SQL Parameter File”>jdbc</Parameter>
<Parameter Name=”Description File”>generic_jdbc</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Transactional Available”>No</Parameter>
<Parameter Name=”Max Rows Available”>No</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MS SQL Server 7.x”>
<Class JARFile=”dbd_jdbc,dbd_mssql”>com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.microsoft.jdbc.sqlserver.SQLServerDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:microsoft:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Microsoft</Parameter>
<Parameter Name=”Version”>mssqlserver_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sqlsrv</Parameter>
<Parameter Name=”SQL Parameter File”>sqlsrv7</Parameter>
<Parameter Name=”Strategies File”>sqlsrv</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sqlsrv7,sqlsrv,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
<Parameter Name=”Quote Identifiers”>False</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MS SQL Server 2000″>
<Aliases>
<!– You can add an alias here if you are using some connections that are defined with an older database engine –>
<Alias>MS SQL Server 6.5</Alias>
</Aliases>
<Class JARFile=”dbd_jdbc,dbd_mssql”>com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<!– Configuration is done for SQL Server 2000 JDBC Driver –>
<Parameter Name=”JDBC Class”>com.microsoft.jdbc.sqlserver.SQLServerDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:microsoft:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Microsoft</Parameter>
<Parameter Name=”Version”>mssqlserver_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sqlsrv</Parameter>
<Parameter Name=”SQL Parameter File”>sqlsrv7</Parameter>
<Parameter Name=”Strategies File”>sqlsrv</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sqlsrv2000,sqlsrv,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
<Parameter Name=”Quote Identifiers”>False</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MS SQL Server 2005″>
<Class JARFile=”dbd_jdbc,dbd_mssql”>com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<!– Configuration is done for SQL Server 2005 JDBC Driver –>
<Parameter Name=”JDBC Class”>com.microsoft.sqlserver.jdbc.SQLServerDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Microsoft</Parameter>
<Parameter Name=”Version”>mssqlserver_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sqlsrv</Parameter>
<Parameter Name=”SQL Parameter File”>sqlsrv</Parameter>
<Parameter Name=”Strategies File”>sqlsrv</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sqlsrv2005,sqlsrv,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Quote Identifiers”>False</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MS SQL Server 2008″>
<Class JARFile=”dbd_jdbc,dbd_mssql”>com.businessobjects.connectionserver.java.drivers.jdbc.mssql.MSSQLDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<!– Configuration is done for SQL Server 2008 JDBC Driver (2.0)  –>
<Parameter Name=”JDBC Class”>com.microsoft.sqlserver.jdbc.SQLServerDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Microsoft</Parameter>
<Parameter Name=”Version”>mssqlserver_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sqlsrv</Parameter>
<Parameter Name=”SQL Parameter File”>sqlsrv</Parameter>
<Parameter Name=”Strategies File”>sqlsrv</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sqlsrv2008,sqlsrv,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Quote Identifiers”>False</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Oracle 9″>
<Aliases>
<!– You can add an alias here if you are using some connections
that are defined with an older database engine –>
<Alias>Oracle 7.3</Alias>
<Alias>Oracle 8</Alias>
<Alias>Oracle 8.0</Alias>
<Alias>Oracle 8.1</Alias>
</Aliases>
<Class JARFile=”dbd_jdbc,dbd_oracle”>com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>oracle.jdbc.OracleDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Oracle</Parameter>
<Parameter Name=”Version”>oracle_jdbc.setup</Parameter>
<Parameter Name=”Description File”>oracle</Parameter>
<Parameter Name=”SQL External File”>oracle</Parameter>
<Parameter Name=”SQL Parameter File”>oracle9</Parameter>
<Parameter Name=”Strategies File”>oracle</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>oracle9,oracle,jdbc</Parameter>
<Parameter Name=”Escape Character”>/</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Oracle 10″>
<Class JARFile=”dbd_jdbc,dbd_oracle”>com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>oracle.jdbc.OracleDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Oracle</Parameter>
<Parameter Name=”Version”>oracle_jdbc.setup</Parameter>
<Parameter Name=”Description File”>oracle</Parameter>
<Parameter Name=”SQL External File”>oracle</Parameter>
<Parameter Name=”SQL Parameter File”>oracle</Parameter>
<Parameter Name=”Strategies File”>oracle</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>oracle10,oracle,jdbc</Parameter>
<Parameter Name=”Escape Character”>/</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Oracle 11″>
<Class JARFile=”dbd_jdbc,dbd_oracle”>com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>oracle.jdbc.OracleDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Oracle</Parameter>
<Parameter Name=”Version”>oracle_jdbc.setup</Parameter>
<Parameter Name=”Description File”>oracle</Parameter>
<Parameter Name=”SQL External File”>oracle</Parameter>
<Parameter Name=”SQL Parameter File”>oracle</Parameter>
<Parameter Name=”Strategies File”>oracle</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>oracle11,oracle,jdbc</Parameter>
<Parameter Name=”Escape Character”>/</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”DB2 UDB v8″>
<Aliases>
<!– You can add an alias here if you are using some connections that are defined with an older database engine –>
<Alias>DB2 UDB v7</Alias>
<Alias>DB2 UDB v6</Alias>
<Alias>DB2 UDB v5</Alias>
</Aliases>
<Class JARFile=”dbd_jdbc,dbd_db2″>com.businessobjects.connectionserver.java.drivers.jdbc.db2.DB2Driver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.ibm.db2.jcc.DB2Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:db2://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>db2_jdbc.setup</Parameter>
<Parameter Name=”Description File”>db2</Parameter>
<Parameter Name=”SQL External File”>db2</Parameter>
<Parameter Name=”SQL Parameter File”>db2udb</Parameter>
<Parameter Name=”Strategies File”>db2</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>db2v8,db2udb,db2,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”DB2 v9″>
<Class JARFile=”dbd_jdbc,dbd_db2″>com.businessobjects.connectionserver.java.drivers.jdbc.db2.DB2Driver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.ibm.db2.jcc.DB2Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:db2://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>db2_jdbc.setup</Parameter>
<Parameter Name=”Description File”>db2</Parameter>
<Parameter Name=”SQL External File”>db2</Parameter>
<Parameter Name=”SQL Parameter File”>db2udb</Parameter>
<Parameter Name=”Strategies File”>db2</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>db2v9,db2udb,db2,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Sybase Adaptive Server 12″>
<Aliases>
<!– You can add an alias here if you are using some connections that are defined with an older database engine –>
<Alias>Sybase SQLServer 11</Alias>
<Alias>Sybase Adaptive Server 11</Alias>
</Aliases>
<Class JARFile=”dbd_jdbc,dbd_sybase”>com.businessobjects.connectionserver.java.drivers.jdbc.sybase.SybaseDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.sybase.jdbc3.jdbc.SybDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sybase:Tds:$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Sybase</Parameter>
<Parameter Name=”Version”>sybase_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sybase12</Parameter>
<Parameter Name=”SQL Parameter File”>sybase</Parameter>
<Parameter Name=”Strategies File”>sybase</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sybase12,sybase,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Sybase Adaptive Server 15″>
<Class JARFile=”dbd_jdbc,dbd_sybase”>com.businessobjects.connectionserver.java.drivers.jdbc.sybase.SybaseDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.sybase.jdbc3.jdbc.SybDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:sybase:Tds:$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Sybase</Parameter>
<Parameter Name=”Version”>sybase_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>sybase</Parameter>
<Parameter Name=”SQL Parameter File”>sybase</Parameter>
<Parameter Name=”Strategies File”>sybase</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>sybase15,sybase,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Informix Dynamic Server 7.3″>
<Class JARFile=”dbd_jdbc,dbd_informix”>com.businessobjects.connectionserver.java.drivers.jdbc.informix.InformixDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.informix.jdbc.IfxDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:informix-sqli://$DATASOURCE$/$DATABASE$:informixserver=$INFORMIXSERVER$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>informix_jdbc.setup</Parameter>
<Parameter Name=”Description File”>informix</Parameter>
<Parameter Name=”SQL External File”>informix</Parameter>
<Parameter Name=”SQL Parameter File”>informix</Parameter>
<Parameter Name=”Strategies File”>informix</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>ids7,informix,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Informix Dynamic Server 2000″>
<Class JARFile=”dbd_jdbc,dbd_informix”>com.businessobjects.connectionserver.java.drivers.jdbc.informix.InformixDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.informix.jdbc.IfxDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:informix-sqli://$DATASOURCE$/$DATABASE$:informixserver=$INFORMIXSERVER$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>informix_jdbc.setup</Parameter>
<Parameter Name=”Description File”>informix</Parameter>
<Parameter Name=”SQL External File”>informix</Parameter>
<Parameter Name=”SQL Parameter File”>informix</Parameter>
<Parameter Name=”Strategies File”>informix</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>ids2000,informix,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Informix Dynamic Server 10″>
<Class JARFile=”dbd_jdbc,dbd_informix”>com.businessobjects.connectionserver.java.drivers.jdbc.informix.InformixDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.informix.jdbc.IfxDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:informix-sqli://$DATASOURCE$/$DATABASE$:informixserver=$INFORMIXSERVER$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>informix_jdbc.setup</Parameter>
<Parameter Name=”Description File”>informix</Parameter>
<Parameter Name=”SQL External File”>informix</Parameter>
<Parameter Name=”SQL Parameter File”>informix</Parameter>
<Parameter Name=”Strategies File”>informix</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>ids10,informix,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Informix Dynamic Server 11″>
<Class JARFile=”dbd_jdbc,dbd_informix”>com.businessobjects.connectionserver.java.drivers.jdbc.informix.InformixDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.informix.jdbc.IfxDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:informix-sqli://$DATASOURCE$/$DATABASE$:informixserver=$INFORMIXSERVER$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>IBM</Parameter>
<Parameter Name=”Version”>informix_jdbc.setup</Parameter>
<Parameter Name=”Description File”>informix</Parameter>
<Parameter Name=”SQL External File”>informix</Parameter>
<Parameter Name=”SQL Parameter File”>informix</Parameter>
<Parameter Name=”Strategies File”>informix</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>ids11,informix,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Teradata V2 R6″>
<Aliases>
<Alias>Teradata V2 R5</Alias>
</Aliases>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.ncr.teradata.TeraDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:teradata://$DATASOURCE$/COMPAT_DBS=TRUE,COMPAT_ISSIGNED=TRUE</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Teradata Corporation</Parameter>
<Parameter Name=”Version”>teradata_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc2</Parameter>
<Parameter Name=”SQL External File”>teradata</Parameter>
<Parameter Name=”SQL Parameter File”>teradata</Parameter>
<Parameter Name=”Strategies File”>teradata</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>teradatav2r6,teradata,jdbc</Parameter>
<Parameter Name=”Escape Character Available”>False</Parameter>
<Parameter Name=”ForeignKeys Available”>False</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Teradata 12″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.teradata.jdbc.TeraDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:teradata://$DATASOURCE$/COMPAT_DBS=TRUE,COMPAT_ISSIGNED=TRUE</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Teradata Corporation</Parameter>
<Parameter Name=”Version”>teradata_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc2</Parameter>
<Parameter Name=”SQL External File”>teradata</Parameter>
<Parameter Name=”SQL Parameter File”>teradata</Parameter>
<Parameter Name=”Strategies File”>teradata</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>teradata12,teradata,jdbc</Parameter>
<Parameter Name=”Escape Character Available”>False</Parameter>
<Parameter Name=”ForeignKeys Available”>False</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Teradata 13″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.teradata.jdbc.TeraDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:teradata://$DATASOURCE$/COMPAT_DBS=TRUE,COMPAT_ISSIGNED=TRUE</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Teradata Corporation</Parameter>
<Parameter Name=”Version”>teradata_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc2</Parameter>
<Parameter Name=”SQL External File”>teradata</Parameter>
<Parameter Name=”SQL Parameter File”>teradata</Parameter>
<Parameter Name=”Strategies File”>teradata</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>teradata13,teradata,jdbc</Parameter>
<Parameter Name=”Escape Character Available”>False</Parameter>
<Parameter Name=”ForeignKeys Available”>False</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MySQL 4″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class file directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.mysql.jdbc.Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:mysql://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Sun</Parameter>
<Parameter Name=”Version”>mysql_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>mysql</Parameter>
<Parameter Name=”SQL Parameter File”>mysql</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>mysql4,mysql,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”MySQL 5″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.mysql.jdbc.Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:mysql://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Sun</Parameter>
<Parameter Name=”Version”>mysql_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>mysql</Parameter>
<Parameter Name=”SQL Parameter File”>mysql</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
<Parameter Name=”Extensions”>mysql5,mysql,jdbc</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Progress OpenEdge 10″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<!–  We only support JDBC type 4 driver, OpenEdge JDBC 10.1 or higher  –>
<Parameter Name=”JDBC Class”>com.ddtek.jdbc.openedge.OpenEdgeDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:datadirect:openedge://$DATASOURCE$;databaseName=$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Progress</Parameter>
<Parameter Name=”Version”>progress_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>progress</Parameter>
<Parameter Name=”SQL Parameter File”>progress</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>progress10,progress,jdbc</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Netezza Server”>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>org.netezza.Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:netezza://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Netezza</Parameter>
<Parameter Name=”Type”>Open</Parameter>
<Parameter Name=”Version”>netezza_jdbc.setup</Parameter>
<Parameter Name=”SQL External File”>netezza</Parameter>
<Parameter Name=”SQL Parameter File”>netezza</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>netezza,jdbc</Parameter>
<Parameter Name=”PrimaryKey Available”>Yes</Parameter>
<Parameter Name=”ForeignKeys Available”>Yes</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Data Federator Server”>
<Class JARFile=”dbd_jdbc,dbd_datafederator”>com.businessobjects.connectionserver.java.drivers.jdbc.datafederator.DataFederatorDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>LeSelect.ThinDriver.ThinDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:leselect://$DATASOURCE$;catalog=&quot;$DATABASE$&quot;</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>SAP BusinessObjects</Parameter>
<Parameter Name=”Version”>datafederator_jdbc.setup</Parameter>
<Parameter Name=”Description File”>datafederator</Parameter>
<Parameter Name=”SQL External File”>datafederator</Parameter>
<Parameter Name=”SQL Parameter File”>datafederator</Parameter>
<Parameter Name=”Strategies File”>datafederator</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>datafederator,jdbc</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Derby 10 Embedded”>
<Class JARFile=”dbd_jdbc,dbd_derby”>com.businessobjects.connectionserver.java.drivers.jdbc.derby.DerbyEmbeddedDriver</Class>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>org.apache.derby.jdbc.EmbeddedDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:derby:$DATASOURCE$</Parameter>
<Properties>
<Property Name=”create”>true</Property>
</Properties>
</JDBCDriver>
<Parameter Name=”Family”>Apache</Parameter>
<Parameter Name=”Version”>derby_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc2</Parameter>
<Parameter Name=”SQL External File”>derby</Parameter>
<Parameter Name=”SQL Parameter File”>derby</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>derby10,derby,jdbc</Parameter>
<Parameter Name=”Qualifiers Available”>No</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Escape Character”>\</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
<Parameter Name=”Force Execute”>Procedures</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”HSQLDB 1.8 Embedded”>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>org.hsqldb.jdbcDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:hsqldb:file:$DATASOURCE$</Parameter>
<Properties>
<Property Name=”shutdown”>true</Property>
</Properties>
</JDBCDriver>
<Parameter Name=”Family”>HSQLDB</Parameter>
<Parameter Name=”Version”>hsqldb_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc2</Parameter>
<Parameter Name=”SQL External File”>hsqldb</Parameter>
<Parameter Name=”SQL Parameter File”>hsqldb</Parameter>
<Parameter Name=”Driver Capabilities”>Query,Procedures</Parameter>
<Parameter Name=”Extensions”>hsqldb,jdbc</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”PostgreSQL 8″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>org.postgresql.Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:postgresql://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>PostgreSQL</Parameter>
<Parameter Name=”Version”>greenplum_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc</Parameter>
<Parameter Name=”SQL External File”>postgresql</Parameter>
<Parameter Name=”SQL Parameter File”>postgresql</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>postgresql8,postgresql,jdbc</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”GreenPlum 3″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>org.postgresql.Driver</Parameter>
<Parameter Name=”URL Format”>jdbc:postgresql://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>GreenPlum</Parameter>
<Parameter Name=”Version”>greenplum_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc</Parameter>
<Parameter Name=”SQL External File”>postgresql</Parameter>
<Parameter Name=”SQL Parameter File”>postgresql</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>greenplum3,greenplum,jdbc</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
<Parameter Name=”Force Execute”>Always</Parameter>
</DataBase>
<DataBase Active=”Yes” Name=”Ingres 2006″>
<JDBCDriver>
<!–  Uncomment and edit the following lines
to define java classes required by JDBC driver
&lt;ClassPath&gt;
&lt;Path&gt;your jar or class files directory&lt;/Path&gt;
&lt;/ClassPath&gt;
–>
<Parameter Name=”JDBC Class”>com.ingres.jdbc.IngresDriver</Parameter>
<Parameter Name=”URL Format”>jdbc:ingres://$DATASOURCE$/$DATABASE$</Parameter>
</JDBCDriver>
<Parameter Name=”Family”>Ingres</Parameter>
<Parameter Name=”Version”>ingres_jdbc.setup</Parameter>
<Parameter Name=”Description File”>jdbc</Parameter>
<Parameter Name=”SQL External File”>ingres</Parameter>
<Parameter Name=”SQL Parameter File”>ingres</Parameter>
<Parameter Name=”Driver Capabilities”>Query</Parameter>
<Parameter Name=”Extensions”>ingres2006,ingres,jdbc</Parameter>
<Parameter Name=”Query TimeOut Available”>No</Parameter>
<Parameter Name=”Catalog Separator”>.</Parameter>
<Parameter Name=”Array Fetch Size”>10</Parameter>
</DataBase>
</DataBases>
</DriverConfiguration>

Leave a Reply

Your email address will not be published. Required fields are marked *