BI XMLA Connector 

Use

Microsoft's XMLA (XML for Analysis) facilitates Web services-based, platform-independent access to OLAP providers. The BI XMLA Connector enables the exchange of analytical data between a client application and a data provider working over the Web, using a SOAP-based XML communication API. The XMLA Connector sends commands to an XMLA-compliant OLAP data source in order to retrieve the schema rowsets and obtain a result set.

The BI XMLA Connector allows you to connect applications built with the BI Java SDK to data sources such as Microsoft Analysis Services, Hyperion, MicroStrategy, MIS, and BW 3.x. This connector is fully compliant with the J2EE Connector Architecture (JCA).

You can also use the BI XMLA 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 XMLA Connector implements the BI Java SDK's IBIOlap interface.

 

See also:

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

·        To configure properties for systems based on the BI XMLA Connector, see Editing BI XMLA 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 XMLA, see:

¡        http://www.xmla.org/docs_pub.asp

¡        http://msdn.microsoft.com/library/default.asp?URL=/library/techart/XMLAnalysis.htm