Show TOC

BI Java ConnectorLocate this document in the navigation structure

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 underConfiguring 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 theSAP NetWeaver Visual Composer Installation & Configuration Guide. For information about configuring the systems on the portal, see Running the System Landscape Wizard andEditing 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 underConfiguring 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 SAP NetWeaver Administrator, see Configuring the BI Java Connectors.
  • To create a system on the portal using a BI Java Connector, seeCreating 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, seeBI Java SDK