Show TOC

BI JDBC ConnectorLocate this document in the navigation structure

Use

Sun's JDBC (Java Database Connectivity) 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 using UD Connect. You can also create systems in the portal that are based on this connector.

The connector adds the following functionality to existing JDBC drivers:

  • Standardized connection management that is integrated into user management in the portal.
  • Uniform metadata service, by implementing JMI capabilities based on CWM
  • A query model independent of the SQL dialect in the underlying data source

The JDBC Connector implements the BI Java SDK's IBIRelational interface.

Prerequisites

The BI JDBC Connector supports all JDBC-compliant data sources.

If you have not already done so, you need to deploy your data source's JDBC driver to the server:  SeeManaging JDBC Driversfor more information.

Connector Properties

The table below lists all required and optional properties for the configuration of your connector:

BI JDBC Connector Properties

Property

Description

Examples

UserName

Data source username.

User must have at least read access to the data source.

(your user name)

Password

Data source password.

(your password)

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

DriverName

Class name of the JDBC driver used for this connection.

com.inet.tds.TdsDriver

FixedCatalog

Restriction of metadata access to metadata contained in specified catalog. Optional

null (no restriction)

xyz(restrict access to catalog "xyz")

FixedSchema

Restriction of metadata access to metadata contained in specified schema.  Optional.

null (no restriction)

xyz(restrict access to schema "xyz")

Language

Language key made up of two letters. This indicates the language of exceptions that can be called on the BI Java SDK Layer. JDBD databases do not support this property. Optional.

EN=English

DE=German

See also:

  • To configure BI Java Connector properties in the SAP NetWeaver Administrator, seeConfiguring the BI Java Connectors.
  • To create a system on the portal using the BI JDBC Connector, seeCreating Systems andEditing BI JDBC System Properties.
  • For information about the BI Java SDK and its connection architecture, see the index.html file in the SDK distribution package
  • For more information about Sun's J2EE Connector Architecture, see http://java.sun.com/j2ee/connector/
  • For more information about Sun's J2EE Connector Architecture, see http://java.sun.com/j2ee/connector/