BI ODBO Connector 

Use

Microsoft's OLE DB for OLAP is the established industry-standard OLAP API for the Windows platform. The BI ODBO Connector is based on OLE DB for OLAP, abbreviating it as "ODBO." This connector allows you to connect applications built with the BI Java SDK to ODBO-compliant OLAP data sources such as Microsoft Analysis Services, SAS, and Microsoft PivotTable Services. This connector is fully compliant with the J2EE Connector Architecture (JCA).

You can also use the BI ODBO Connector to make these data sources available in SAP BI Systems via UD Connect, or you can create systems in the portal based on this connector.

Integration

The BI ODBO Connector uses Microsoft's ADO (ActiveX Data Objects) and ADO MD (ActiveX Data Objects Multidimensional) to support connectivity to OLAP data sources. ADO provides access to the schema object; ADO MD adds easy access to multidimensional data by extending ADO with objects specific to multidimensional data, such as the cubes and cellsets. With ADO and ADO MD, you can browse multidimensional schema, query a cube, and retrieve the results, thus providing convenient access to OLAP data from languages such as Microsoft Visual Basic, Microsoft Visual C++, and Microsoft Visual J++. Like ADO, ADO MD uses an underlying OLE DB provider to gain access to data.

The ODBO Connector implements the BI Java SDK's IBIOlap interface.

See also:

·        To create a system on the portal using the BI ODBO Connector, see Creating Systems.

·        To configure properties for systems based on the BI ODBO Connector, see Editing BI ODBO 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 Microsoft’s ADO, see:
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/dasdk/mdac3sc7.htm