BI Java Connectors (SAP Library - Enterprise Reporting, Query, and Analysis)

BI Java Connectors

Purpose

The BI Java Connectors are a group of four JCA (J2EE Connector Architecture)-compliant resource adapters that implement the BI Java SDK's APIs and allow you to connect the applications you build with the SDK to heterogeneous data sources. They are deployed by default onto SAP NetWeaver's J2EE Web Application Server.

The BI Java SDK contains the JAR files you need to develop applications using any of the BI Java Connectors and to use them in an unmanaged scenario, but to use your application with a data source in the managed environment of the J2EE server, you need to create a system on the server using the appropriate BI Java Connector.

Features

Four BI Java Connectors are available:

· BI JDBC Connector, for connecting to relational JDBC data sources

· BI ODBO Connector, for connecting to OLE DB for OLAP-compliant data sources

· BI SAP Query Connector, for connecting to data from SAP operational applications

· BI XMLA Connector, for connecting to XMLA-compliant data providers such as SAP BI Systems

Connector Overview

Connector	Access To	Technology Based On	System Requirements
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
BI ODBO Connector	OLAP data sources: OLE DB for OLAP-compliant data sources Examples: Microsoft Analysis Services, SAS, Microsoft PivotTable Services	Microsoft's OLE DB for OLAP -- the established industry-standard OLAP API for the Windows platform	Microsoft Windows 2000 / NT / XP ODBO driver for your data source
BI SAP Query Connector	SAP operational applications Examples: data in transactional systems such as Ad-Hoc, and Operational Reporting	SAP Query -- a component of SAP's Web Application Server that allows you to create custom reports without any ABAP programming knowledge	SAP JCo
BI XMLA Connector	XMLA-compliant OLAP data sources Examples: MS Analysis Services, Hyperion, MicroStrategy, and SAP BW 3.x	Microsoft's XMLA (XML for Analysis) -- Web services-based, platform-independent access to OLAP providers. Exchanges analytical data between a client application and a data provider working over the Web, using a SOAP-based XML communication API.	none

See also:

· To create a system on the portal using a BI Java Connector, see Structure link 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, refer to the index.html file inside of the SDK distribution package

· Read about the BI Java SDK