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: