German-based EXASOL, a developer of data management systems, has released the EXASolution OLAP Connector, a new interface that can integrate different types of Online Analytic Processing (OLAP) tools for clients.
Steffen Weissbarth, CEO at EXASOL said, “The combination of MDX interfaces with our high-performance EXASolution database means our customers benefit from extremely fast analyses and real self-service analytics. We want to make business intelligence easier for our customers by providing intuitive solutions, which are available to them anytime anywhere.”
The OLAP Connector, based on the MDX standard, enables EXASOL to bring together multidimensional OLAP cubes with the EXASolution scalable relational high-speed database. The virtual cubes enable users to employ OLAP tools as usual and integrate and analyze data from the data warehouse directly in Microsoft (News - Alert) Excel PowerPivot tables.
The new tools help in retaining direct access to latest and detailed data in the Excel environment, allowing for saving the data without copying. Users will be able to develop new analysis procedures themselves, enabling fast and flexible reactions to customer requirements.
Elaborate pre-aggregations are dispensed as the cubes’ calculations can be performed directly on the raw data. Also, the performance of the solution is optimized for all sizes of data, including big data. Data management is simple as well, with the new EXASolution OLAP Connectors.
Amyn Rajan, CEO at Simba remarked, “We are excited to work with EXASOL to add our enterprise grade MDX interfaces to EXASolution. The combination of our MDX engine and the EXASOL high performance database creates an excellent solution for customers that are looking for advanced high performance real time analytics. We look forward to their success with this innovative solution.”
The virtual cubes can process the values of all cubes, as the EXASolution OLAP Connector is familiar with the metadata for these cubes. Additionally, the integrated MDX query engine translates multidimensional MDX queries into relational SQL queries, sending them directly to the EXASolution database.
All calculations are done there and the results are returned through the same channel.
EXASOL recently announced that Gartner, Inc. has once again listed the company in the Magic Quadrant for Data Warehouse Database Management Systems (DBMS).