BI Java Connector 

Purpose

BI Java JDBC Connector is a JCA-enabled (J2EE Connector Architecture) resource adapter. It implements the APIs for the BI Java SDK and allows you to connect various data sources to the applications you have created using the SDK. You can also use BI Java JDBC Connector to make these data sources available in SAP BI systems (by means of UD Connect), or to create systems in the portal to use in Visual Composer scenarios.

The following diagram outlines the potential usage scenarios for the BI Java Connectors:

As illustrated, you can use BI Java JDBC Connector to create systems for use in three different scenarios. Since BI Java JDBC Connector is part of SAP Universal Data Integration (UDI), these are often referred to as UDI scenarios: 

●      Scenario 1: UD Connect

On the BI platform, you can use UD Connect to make data from systems based on the BI Java Connectors available in SAP BI.  More information: Transferring Data with UD Connect.

You can find more information about configuring BI Java Connector for this scenario in the SAP Implementation Guide, under SAP NetWeaver ® Business Intelligence ® UDI Settings by Purpose ® UD Connect Settings. You can find more information about the configuring connector properties under Configuring BI Java Connector.

●      Scenario 2: Visual Composer

You can use data from systems based on BI Java Connector in Visual Composer, the portal-based visual modeling application.  More information: SAP NetWeaver Visual Composer Modeler’s Guide.

To configure BI Java Connector for this scenario, see the SAP NetWeaver Visual Composer Installation & Configuration Guide. For information about configuring the systems on the portal, see Running the System Landscape Wizard and Editing Systems.

●      Scenario 3: BI Java SDK

You can build custom Java applications based on data in systems created with BI Java Connector.  More information: BI Java SDK.

You can find more information about configuring the BI Java Connectors for this scenario under Configuring BI Java Connector.

Features

To connect to relational JDBC data sources, you can use BI Java JDBC Connector,

Overview

Connector	Access To	Technology Based On	System Prerequisites
BI JDBC Connector	Relational data sources: over 170 JDBC drivers Examples: Teradata, Oracle, Microsoft SQL Server, Microsoft Access, DB2, Microsoft Excel, text files such as CSV	Sun's JDBC (Java Database Connectivity) -- the standard Java API for Relational Database Management Systems (RDBMS)	JDBC driver for your data source

 

See also:

●      To configure a BI Java Connector on the Application Server Java using the NetWeaver Administrator, see Configuring the BI Java Connectors.

●      To create a system on the portal using a BI Java Connector, see Creating Systems.

●      For more information about the J2EE Connector Architecture (JCA), see http://java.sun.com/j2ee/connector/

●      For information about the BI Java SDK and its connection architecture, see the index.html file in the SDK distribution package

●      To learn more about SDK, see BI Java SDK