Greater convenience: access the data warehouse directly via the EXASolution OLAP Connector
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."
About EXASOL AG
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 www.exasol.com follow us on twitter or like us on facebook.
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.
Tel.: +49 (0)911 23991 300
Waggener Edstrom Worldwide
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: 1566
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
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
EXASOL included in the Magic Quadrant for Data Warehouse Database Management Sys …
EXASOL offers a strong support, a wide customer adoption and a growing product maturity Nuremberg, February 5, 2013 – The German-based EXASOL AG is listed again in the Magic Quadrant for Data Warehouse Database Management Systems (DBMS) by Gartner, a leading analyst company. According to Gartner, Inc., the data warehouse DBMS market is transforming due to the rise of "big data" and logical data warehouses. Unexpectedly, many organizations entered the data warehouse
Wooga opts for EXASOL's Data Warehouse Appliance
Performance improved 200x thanks to EXASolution Nuremberg, 11. December 2012 – Wooga GmbH, a dynamically growing games software company, is extending its analysis platform to gain more detailed information about customer satisfaction and to enhance this effectively. To achieve this, the young Berlin-based games manufacturer relies on a business intelligence environment based on the new Data Warehouse Appliance from EXASOL. Wooga is therefore able to analyse the data of its now
More Releases for EXASolution OLAP MDX
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