The XMLA Connector from Arquery
provides seamless data connectivity between OLEDB for OLAP (ODBO) clients and XMLA data sources. The connector is designed to interface with XMLA compliant data sources such as SAP, Mondrian, Jedox as well as other data sources.
The connector is ODBO compliant and, as such, it loads seamlessly into ODBO clients. This enables Excel (for example) to connect to the data sources enumerated before.
One obvious advantage of using this technology is bringing the powerful pivot table technology of Excel to XMLA warehouses. As such, a user of the connector has a commodity BI tool at fingertips with the corresponding advantages in knowledge reutilization and price.
Serious consideration was paid during the design of this connector to speed and memory consumption optimization. A MDX query can result in a rather large quantity of information and the system was designed with this in mind. As a result the system is fast and robust, with low memory requirements.
The connector exposes the IMDDataset interface for classical connectivity. This interface allows axis retrieval and sequential access to data. In addition, bulk access to data is provided through IMDRangeRowset implementation. This allows writing more effective clients that are ultimately faster.
Go to the project page on SourceForge
See the provider in action
SSL and Proxy Support
Sharepoint 2013 and Arquery
Mondrian and non ASCII characters
Visual Totals with Mondrian