BI JDBC Connector 

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

●      A standardized metadata service, provided by the implementation of 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:

...

       1.      Start the Visual Administrator.

       2.      On the Cluster tab, select Server x → Services → JDBC Connector.

       3.      In the right frame, select the Drivers node on the Runtime tab.

       4.      From the icon bar, choose Create New Driver or Data source.

       5.      In the DB Driver field in the Add Driver dialog box, enter a name for your JDBC driver.

       6.      Navigate to your JDBC driver's JAR file and select it.

       7.      To select additional JAR files, select Yes when prompted, and when finished, select No.

More information: JDBC Connector Service.

Connector Properties

Refer to the table below for the required and optional properties to configure for 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	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

 

More Information:

●      To configure BI Java Connector properties in the SAP NetWeaver Application Server's Visual Administrator, see Configurating BI Java Connector.

●      To create a system on the portal using the BI JDBC Connector, see Creating Systems and Editing BI JDBC System Properties.

●      For information about the BI Java SDK and its connection architecture, refer to the index.html file inside of 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/