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 may be deployed 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 deploy the appropriate BI Java Connector. The connectors themselves are distributed separately.
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’s BW
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 |
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 |
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 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 |
Deployment Information
The BI Java Connectors are packaged in resource adapter archives, or RAR files. Each RAR file includes class libraries and dependencies, a deployment descriptor, and documentation in the form of a howto.html file. Refer to this howto.html file inside of each RAR file for additional system or configuration information specific to that particular connector. This file also contains instructions on how to deploy the connector into the Web Application Server.
See also:
· For deployment and configuration information, refer to the howto.html file located inside of each resource adapter archive
· 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