About the SAP BI JDBC Connector
This document is called howto.html and is delivered
in the resource adapter archive (RAR file) bi_sdk_jdbc.rar.
You may extract howto.html to a separate location
for your reference before deploying the resource adapter archive. Refer
to this document for properties configuration information.
This document contains the following information:
Overview
Sun's Java Database Connectivity (JDBC) is the standard Java API for
Relational Database Management Systems (RDBMS). The BI JDBC Connector
allows you to connect applications built with the BI Java SDK to over
170 JDBC drivers, supporting data sources such as Teradata, Oracle, Microsoft
SQL Server, Microsoft Access, DB2, Microsoft Excel, and text files such
as CSV. This connector is fully compliant with the J2EE Connector Architecture
(JCA).
You can also use the BI JDBC Connector to make these data sources available
in SAP BI systems via UD Connect, or to create systems in the portal.
The connector adds the following functionality to existing JDBC drivers:
- Uniform connection management that integrates with user management
in SAP's Enterprise Portal
- Uniform metadata service, by implementing Java Metadata Interface
(JMI) capabilities based on the Common Warehouse Metamodel (CWM)
- Query model independent of SQL dialect of the underlying data source
The BI JDBC Connector implements the BI Java SDK's IBIRelational interface.
System Requirements
Requirement |
Detail |
Software prerequisites |
JDBC driver for your data source
|
Supported data sources |
JDBC-compliant data sources |
Supported systems |
Platform-independent apart from JDBC driver used
for connection |
Supported application server |
SAP NetWeaver |
Connection Properties
Connection Constant |
Property Name |
Description |
Examples |
JdbcConnectionConstants.
USERNAME |
UserName |
Data source username. |
(your username) |
JdbcConnectionConstants.
PASSWORD |
Password |
Data source password. |
(your password) |
JdbcConnectionConstants.
URL |
URL |
URL string specifying the location of a database
(used by the java.sql.DriverManager to determine which
driver to use). |
jdbc:inetdae7:
domain:port?
database=
mydatabase |
JdbcConnectionConstants.
DRIVERNAME |
DriverName |
Class name of JDBC driver used for this connection. |
com.inet.tds.
TdsDriver |
JdbcConnectionConstants.
FIXED_CATALOG |
FixedCatalog |
Restriction of metadata access to metadata contained
in specified catalog. null means no restriction. Optional. |
null (no restriction)
xyz (restrict to catalog "xyz ")
|
JdbcConnectionConstants.
FIXED_SCHEMA |
FixedSchema |
Restriction of metadata access to metadata contained
in specified schema. null means no restriction. Optional. |
null (no restriction)
xyz (restrict to schema "xyz ")
|
JdbcConnectionConstants.
LANGUAGE |
Language |
Two-letter abbreviation of language. Specifies the
language of exceptions evoked on the BI Java SDK layer. JDBC databases
themselves do not support this property. Optional. |
EN = English
DE = German |
JNDI Name
Refer to this connector in your application by its JNDI name: SDK_JDBC .
For code samples, refer to the Connection Interfaces Javadocs package
in the documentation set delivered with the BI Java SDK.
You may clone an existing connection using the Web Application Server's
Visual Administrator. If you are using this connector with UD Connect,
when entering the resource adapter name during the cloning process, you
must prefix the JNDI name with "SDK_ " and use only all capital
letters in order for UD Connect to properly recognize the connector.
Additional Information
For more information about Sun's J2EE Connector Architecture, see:
For more information about the connection architecture in the BI Java
SDK, refer to the following documentation in the SDK distribution package:
- Connection Interfaces Javadocs package
- Developer's Guide (PDF)
For more information about Sun's JDBC, see:
|