How to integrate OLAP XMLA in Exasol
Discover how to integrate OLAP XMLA and Exasol and instantly get access to your data.
WITH DATA VIRTUALITY PIPES
Replicate OLAP XMLA data into Exasol and analyze it with your BI Tool.

About OLAP XMLA
OLAP or online analytical processing is an approach to answering multi-dimensional analytical queries swiftly. It allows users to perform complex calculations and multi dimensional analysis of business data. Therefore OLAP is part of the broader category of business intelligence, which also encompasses relational database, report writing and data mining.
About Exasol
Exasol is a leading analytic database management software company. Eexasolution, runs on a cluster of standard computer hardware servers. It stores data in a column-oriented way, using proprietary in-memory compression. The relational database management system of Exasol helps companies to increase their efficiency and speed of analytic workloads.
DATA VIRTUALITY OFFERS TWO PIPES SOLUTIONS
depending on your needs.

Pipes
Easy and reliable data replication in the cloud
Pipes enables you to move data from any data source to your target storage or data warehouse on schedule. Integrate your data with just a few clicks and without any coding.

Pipes Professional
Advanced data replication hosted in the cloud or on-premises
Pipes Professional enables you to transform and model your data with SQL before replication. Customize your data pipelines and build data models across sources in 80% less time.
Pipes Professional features include:
- Cloud/On-Premises Hosting
- Complex Data Transformations
- Advanced Jobs & Schedules
- Multiple Target Storages
- Custom Extraction Definitions
- Job Dependencies
- SQL Modelling Layer
- Complex Replication Types
- Custom Job Triggers