The Familiar and Powerful Capabilities of Excel – Powered by Your Real-Time Enterprise Data

 

Now you can use the powerful ad hoc query and analysis capabilities of Microsoft Excel® PivotTables® and PivotCharts® with your Oracle® 11g OLAP business intelligence data. Using Excel with Simba’s MDX Provider for Oracle OLAP, you can slice, dice, pivot and gain meaningful insight from your Oracle data the same way that you would if you were connecting Excel directly to Microsoft Analysis Services or SAP® NetWeaver® BW.

 

Take your data analysis to a new level with the latest Excel 2010 functionality, including slicers, sparklines, named sets and drill-through. You can also hot-link your Excel data to other Microsoft Office applications like Word and PowerPoint® – imagine a sales analysis chart in PowerPoint that updates automatically, via the connected Excel sheet, as new sales transactions are recorded in Oracle. Published reports and presentations need never become out of date again.

 

Don't Waste Time Learning Yet Another BI Tool

 

Gain the choice of which BI tool to use to analyze and report on your data. Simba’s MDX Provider for Oracle OLAP is an open OLAP connectivity solution for many MDX query language emitting clients, so you can continue to use the tools you're familiar with. It supports Microsoft Excel 2010 (both 32-bit and 64-bit), Excel 2007, Excel 2003, arcplan Enterprise 7 and SAP BusinessObjects Voyager, with Oracle Database 11g OLAP Option Release 1 and 2.

 

Control the Dangerous Proliferation of Out-of-Date Spreadsheets

 

Direct connectivity to live data means that you don’t have to load a static copy of your data into Excel or a mid-tier server. Critical Excel files are always up-to-date with your current enterprise data. In addition, Simba’s MDX Provider for Oracle OLAP preserves all security policies set by your Oracle Database Administrator to ensure your data stays protected.

 

Since MDX Provider for Oracle OLAP fully supports Excel thin-client deployment (Excel Services) and integration with the SharePoint® platform, you can securely distribute reports to other agents and users.

 

Save Time and Money with a Solution that’s Easy to Deploy, Low Cost and Requires No Training

 

Why use an expensive mid-tier server when you can connect directly to your Oracle data cube? And why use other spreadsheet tools and add-ins with different user paradigms when you can use Excel itself? Simba’s MDX Provider for Oracle OLAP has low total cost of ownership. As a client-side driver, it’s easy to deploy, cost effective and low maintenance. No additional mid-tier servers or add-ins are needed. No special training is required. If users are familiar with Microsoft Excel PivotTables, accessing Oracle data is the same as Excel connecting to any data source.

 

How It Works

 

MDX Provider for Oracle OLAP is a client-side driver that natively connects Microsoft Excel and other OLAP-based client applications with Oracle Database 11g OLAP Option. It works seamlessly to parse and process multi-dimensional queries from BI tools and integrate with Oracle OLAP via SQL/ODBC, while preserving all Oracle Database security policies in place. Also, the high performance engine in your Oracle database, accelerated by Exadata hardware, processes massive amounts of data in seconds, so that you get lightning-fast performance in your Excel PivotTable. (see diagram)

 

Get your free evaluation copy.