openPR Logo
Press release

Greater convenience: access the data warehouse directly via the EXASolution OLAP Connector

02-20-2013 11:14 PM CET | IT, New Media & Software

Press release from: EXASOL AG

/ PR Agency: Waggener Edstrom Worldwide
Greater convenience: access the data warehouse directly via

A Multidimensional Expressions (MDX) interface enables smooth processing of complex OLAP queries

Nuremberg, 19.02.2013 – With the new EXASolution OLAP Connector, EXASOL AG, a specialist in high-performance databases, offers its clients an interface with which all kinds of Online Analytic Processing (OLAP) tools can be integrated. With the OLAP Connector based on the MDX standard, EXASOL connects the intuitive analysis world of multidimensional OLAP cubes with the EXASolution scalable relational high-speed database. By making use of virtual cubes (ROLAP = relational OLAP), users can to use their OLAP tools as normal. They can integrate and analyse data from the data warehouse directly in Microsoft Excel PowerPivot tables, for example. The EXASolution OLAP Connector was developed in partnership with Simba Technologies, the leading provider of MDX and other data connectivity solutions.

Rapid data analyses with no elaborate pre-aggregations
For users, the tool’s added value particularly lies in the retention of the familiar frontend and access to up-to-date, detailed data directly in the Excel environment, for example, without having to copy and save this locally. Thus, users are able to develop new analysis procedures without the support of their IT department (self service). This enables more rapid and flexible reactions to customer requirements. Moreover, users also benefit from the discontinuation of elaborate pre-aggregations, as the cubes’ calculations can be performed directly on the raw data. Last but not least, the high performance with data volumes of any size (including big data) in addition to the simple data management round out the advantages of the new EXASolution OLAP Connectors.

What does the EXASolution OLAP Connector comprise?
So-called virtual cubes are defined to be able to process the values of all cubes. The EXASolution OLAP Connector is familiar with the metadata for these cubes. The integrated MDX query engine translates multidimensional MDX queries into relational SQL queries and sends these directly to the EXASolution database. They are calculated there and the results returned via the same channel.

"The combination of MDX interfaces with our high-performance EXASolution database means our customers benefit from extremely fast analyses and real self-service analytics," says Steffen Weissbarth, CEO at EXASOL AG. "We want to make business intelligence easier for our customers by providing intuitive solutions, which are available to them anytime anywhere."

"We are excited to work with EXASOL to add our enterprise grade MDX interfaces to EXASolution" quoted Amyn Rajan, CEO of Simba, "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."

EXASOL AG, based in Nuremberg in Germany, develops a data management system that enables the rapid analysis and evaluation of data. By implementing the solution from EXASOL, business processes are optimised and secure foundations for decision-making are generated, which give companies of all industry sectors a sustainable competitive edge.
EXASolution is a relational high-performance database that was specifically developed for enterprise warehouse applications and business intelligence solutions. The In-Memory-technology-based database is utilised by companies of all industry sectors for time-critical analyses, comprehensive data research, planning or reporting. By integrating geodata and BigData-sources as well as unstructured data - e.g by using the feature EXAPowerlytics - EXASolution offers an additional dimension of evaluation for more efficient and ad-hoc analyses. The easy-to-manage database can be integrated easily into existing IT infrastructures and requires a minimal amount of administrative maintenance, while ensuring low investment and operation costs (TCO). As an appliance EXASolution, is available in three versions. EXACloud, based on EXASolution, is offered as datawarehousing as a services. By using this highly efficient way to manage their data EXASOL customers benefit as well from full data access at any time as from a transparent pricing model.
Companies such as XING, Sony Music, Olympus, media control, Zalando, stayfriends, Coop, IMS Health, Semikron, Webtrekk, econda and xplosion rely on EXASOL technology, made in Germany. For more information, please visit follow us on twitter or like us on facebook.

About Simba
Simba Technologies is industry’s recognized leader in standards-based data connectivity products, solutions and services. Simba’s specialty and expertise in data connectivity is highly regarded in industry and sought by leading Business Intelligence (BI) and data companies worldwide. Simba’s software is the glue between front-end BI applications and back-end data servers – ensuring products interoperate across vendors according to established data standards such as ODBC, JDPB, ADO.NET OData and MDX. Millions of people use Simba’s software worldwide to enable data access and analytics.

Monika Götzmann
Tel.: +49 (0)911 23991 300

Waggener Edstrom Worldwide
Adriano Gómez-Bantel
Tel.: +49 (0)89 6281 75 0

This release was published on openPR.

Permanent link to this press release:

Please set a link in the press area of your homepage to this press release on openPR. openPR disclaims liability for any content contained in this release.

You can edit or delete your press release Greater convenience: access the data warehouse directly via the EXASolution OLAP Connector here

News-ID: 252606 • Views:

More Releases from EXASOL AG

Helmut Fink complements management board of EXASOL
Helmut Fink takes up the position of Chief Operating Officer (COO) at EXASOL. With his many years of experience, Fink shall strengthen the global positioning of marketing and partner business as part of the management board. EXASOL, manufacturer of the analytical database EXASolution, expanded their management board with the addition of Helmut Fink. Beginning January 2014, he will fill the position as COO and be responsible for the global positioning of
EXASolution 4.2 by EXASOL completes the vision Logical data warehouse
EXASolution 4.2 by EXASOL completes the vision Logical data warehouse
New version impresses with its user-friendliness, and optimises big data analyses Nuremberg, 14 May 2013 – EXASOL AG, the manufacturer of high-performance databases presents its new release, EXASolution 4.2. The main feature of the latest version is the MultiDimensional eXpressions (MDX) interface for complex OLAP queries and expansion of the EXAPowerlytics framework. With the open interface, virtually any number of external services and systems can be integrated directly into SQL

More Releases for EXASolution

Zalando optimises its data warehouse with EXASolution.
Zalando optimises its data warehouse with EXASolution. High-performance, in-memory database from EXASOL supplies target group-specific analyses in real time Nuremberg, 15 February 2012 – Zalando, Germany's largest online provider of shoes, fashion, beauty and sports equipment, relies on EXASolution, the relational, high-performance database from EXASOL. With the use of the database management solution, Zalando can accelerate its reporting, process complex requests more quickly and carry out analyses more precisely. EXASolution allows
EXASolution Announces MicroStrategy Certification
MicroStrategy integrates VLDB data connector for relational database solution EXASolution Nuremberg, Germany, August 23, 2011 – EXASolution, the relational database solution of EXASOL, today announced that it has passed MicroStrategy’s comprehensive test suite, qualifying it as a supported database for the MicroStrategy platform. Thus companies with MicroStrategy Business Intelligence (BI) applications can now fully leverage the data management solution. EXASolution is based on in-memory technology and makes it possible for organizations
EXASOL presents new EXASolution Data Warehouse Appliance
Flexible and affordable: high-speed database comes as ready-to-run solution Nuremberg, Germany, August 5, 2011 – EXASolution, the relational high-performance database by EXASOL, is now also available as an appliance: the complete package includes the high-performance EXASolution high-speed database and affordable standard hardware from hardware and service partners such as Dell, HP, IBM, Fujitsu and Netapp. The new EXASolution Data Warehouse Appliance also features services and support. With this new appliance version,
EXASolution integrates MDX applications for business intelligence
• The interface on an open-source basis enables access to the OLAP server. • Planning departments in companies profit from faster analyses, hence shorter decision-making cycles Nuremberg, 28 June 2011 – The relational database solution EXASolution can now access data from the business intelligence (BI) applications written in MultiDimensional eXpressions (MDX) and analyse them straightaway. The Nuremberg database specialist EXASOL has developed an interface for this purpose thatis based on an open
EXASolution 3.3: faster integration with EXAjload Bulk Loader
Nuremberg, 21. February 2011 – The relational EXASolution high-performance database is now available in version 3.3. The most important innovations include the EXAjload Bulk Loader and extra features in the areas of linear regression, aliases as well as statistical and inverse distribution functions. EXASOL customers who choose EXASolution 3.3 as a base for their data warehouse benefit from the improved performance of their enterprise warehouse applications and business intelligence solutions.
EXASolution 3.2 – New Version of the high-performance database
Bulk loader now many times faster and GROUP BY queries improved to increase performance Nuremberg, September 20th, 2010 – EXASOL, a leading provider of a database management system (DBMS) for precise data analytics, will release the new Version 3.2 of its high-performance database management system (DMBS) EXASolution today, including a series of innovative improvements. Customers will now benefit from even better performance and simplified integration options. “This version represents a continuation of