SimbaProvider OLAP SDK 4.5OLAP / Multi-dimensional Data Connectivity / MDX query language
Industry’s Leading MDX and OLAP SDK for Advanced OLE DB for OLAP (ODBO) and XML for Analysis (XMLA) Data Access
SimbaProvider 4.5 is Here
Click here to find out all the new and advanced features.
SimbaProvider OLAP SDK is the leading Software Development Toolkit (SDK) for creating OLE DB for OLAP (ODBO) and XML for Analysis (XMLA) connectivity to multi-dimensional and relational data sources and to do more with that data than you can with SQL alone. Move beyond simple rows and columns and let your database do the heavy lifting for the types of calculations it does best. Simba’s MDX Engine performs advanced calculations that allow users to interactively slice and dice, filter, and explore data in BI tools.
MDX Engine implements built-in MDX functions such as filter to operate efficiently on sets of data which live on the server allowing it to calculate the summary values and to use one data model across many different BI clients. Easy to use point and click interface to connect to models, get summary values, and slice and dice data to integrate with the newest generation of analytical applications and development environments, such as SAP BusinessObjects, IBM Cognos, Microsoft Excel, ADOMD, ADOMD.NET and many others.
• Any Data – robust 32-bit and 64-bit ODBO Providers and 32-bit and 64-bit, .NET-based and Java-based XMLA Providers contain complete 32-bit and 64-bit MDX 2005 compliant engines, providing your database with full MDX capabilities
• Complete Solution – only complete ODBO SDK and XMLA SDK available, providing an open framework to quickly and easily develop a quality ODBO Provider or XMLA Provider without changing your existing product architecture
• Cost Effective – significantly reduce development time, simplify maintenance, and add interoperability with leading applications
• Independent Software Vendors (ISVs) – designed for ISVs that have multi-dimensional data or OLAP server data allowing them to remain competitive and satisfy customer demands for advanced data analysis capabilities
• Global Enterprises – provide an ODBO or XMLA interface to corporate data sources and cubes that are required to drive key business functions
- Real-time OLAP cube interface – no pre-aggregations or cube processing required
- High performance MDX engine written in C++
- OLE DB for OLAP (ODBO) and XMLA protocol support
- Advanced XMLA service layer written in Java
- Code in Visual Studio 2010, Visual Studio 2012, or Eclipse
- Compatible with many popular BI clients including Microsoft Excel, SAP BusinessObjects Analysis, Edition for OLAP
- ADOMD.Net programming interface to the XMLA service
- Full set of MDX functions implemented to specification
- JBoss and Tomcat web application server support
- Customizable to use power of underlying data source to perform query computations
- Windows and Linux sample provider
- Quick start guide and technical reference documentation
- Responsive customer support
- Easily and fully rebrandable
- Windows Vista Business (32 and 64-bit, SP1 required for .NET XMLA on 64-bit), Windows Server 2008 (64-bit), Windows Server 2012 (64-bit), Windows 7, Windows 8
- SUSE Linux ES11 SP2 (x64)
- Microsoft Visual Studio 2010 or 2012
If you plan to develop in Java, you will also need:
- JDK 1.7 SDK (64bit)
- Eclipse 3.7 or higher
- JBoss 7.1 or higher or Tomcat 7
- Ant 1.9
If you plan to develop in Java on Linux, you will also need:
- GCC 4.3.4
- ODBO: Microsoft Excel 2003, 2007, 2010, and/or 2013
- XMLA: SimbaO2X (link) plus Microsoft Excel 2003, 2007, 2010, and/or 2013, or access to any other BI client that uses the XMLA protocol
What is SimbaProvider SDK?
SimbaProvider SDK is a Software Development Toolkit (SDK) for building an OLE DB for OLAP (ODBO) Provider or a XML for Analysis (XMLA) Provider for your multi-dimensional or star schema relational data store.
Conventionally, building a data provider from scratch requires senior programmers experienced in ODBO, XMLA, as well as MDX. Building a data provider without an SDK is a long development process, requiring extensive knowledge/programming and testing/debugging with consumer applications.
SimbaProvider SDK significantly reduces the time and effort and protects your development investment. Using our OLAP SDK, you can have a finished ODBO Provider or XMLA Provider that works in the real world with popular applications at a fraction of the cost and development time. SimbaProvider SDK enables the development of robust 32-bit and 64-bit ODBO Providers and XMLA Providers (Java-based and .NET-based XMLA Providers), ensuring the utmost in interoperability and cross-platform enabled solutions.
How do I build an OLE DB for OLAP (ODBO) Provider and/or XML for Analysis (XMLA) Provider using SimbaProvider SDK?
Your first task is to decide on whether you wish to build an OLE DB for OLAP (ODBO) Provider or a XML for Analysis (XMLA) Provider. Because SimbaProvider SDK supports both ODBO and XMLA, you only need to develop a single implementation layer that can be used in either type of data provider. Once you have made this decision, simply follow the steps required to develop your ODBO Provider or XMLA Provider, as outlined in our comprehensive documentation, with the assistance of Simba’s support.
How long will it take to build an OLE DB for OLAP (ODBO) Provider or XML for Analysis (XMLA) Provider using SimbaProvider SDK?
Our customers can typically develop a production quality, read-only data provider in about six to 12 person-months, depending on the complexity of the underlying data source.
What are the technical benefits of SimbaProvider SDK?
SimbaProvider SDK provides solutions for the more difficult areas in implementing an ODBO Provider or XMLA Provider, making it easy for you to develop a robust data provider.
1. Dataset (Rowset) Flattening – Technically optional, Dataset flattening is required in order to work with certain consumer applications. Data flattening requires joining axis info tables and dataset cell information. The flattened dataset provides a quick and easy method for rowset-based consumer applications, such as Microsoft Excel, to display multi-dimensional data.
2. Asynchronous Execution and Rowset Population Support – Asynchronous Execution and Rowset Population requires the close coordination of several interfaces, (IRowset, ICommand, IAsynchStatus, and IConnectionPointContainer), as well as overall thread safety and thread scheduling/handling. This requires a good design and expert threading experience to implement. Without proper asynchronous execution, applications reading the data may otherwise appear slow and ill-behaved to your end-users. SimbaProvider SDK supports Asynchronous Execution and Rowset Population.
3. Full Fledged MDX Engine – Simba’s 32-bit and 64-bit MDX 2005 Engines have the ability to parse, resolve and evaluate MDX queries. They support the latest MDX 2005 enhancements to ensure utmost interoperability, including compatibility with the newest applications. The MDX language is otherwise very difficult to implement. Specifically, it is much more complex than SQL. Parsing MDX is very difficult because of its many keywords and ambiguities. SimbaProvider SDK makes implementing MDX functionality easy because it contains a full MDX 2005 Engine and its backed by Simba’s commitment to keeping pace as technologies evolve.
4. Caching – Many applications access datasets one cell at a time. This is extremely inefficient and caching is highly desirable. Because datasets are multi-dimensional and can be quite large, dataset read-ahead and caching requires sophisticated algorithms to pre-calculate and retrieve those areas of the cube that are most likely to be retrieved next. SimbaProvider SDK implements caching and allows you to custom extend this caching, if desired.
For additional information, please refer to the Features page.
Does Simba offer development services to create an OLE DB for OLAP (ODBO) Provider or XML for Analysis (XMLA) Provider?
Absolutely. Simba can provide consulting expertise throughout the development cycle for your data provider. For more information on the solutions offered by Simba, see our Data Driver Development Services.
What is the history of XML for Analysis (XMLA)?
The XMLA Council – chaired by Hyperion, Microsoft and SAS – was formed in 2001, shortly after the specification was first proposed. The Council is made up of a number of leading Business Intelligence and Business Performance Management software vendors that have announced their support and backing of XMLA. Simba is a member of the XMLA Council and chairs a Special Interest Group (SIG) on MDX Leveling and InterOperability/Conformance. Visit www.xmlforanalysis.com for more information and history on XML for Analysis (XMLA).
What is the history OLE DB for OLAP (ODBO)?
Microsoft recognized a rapid growth in multi-dimensional databases and on-line analytical processing (OLAP) tools. After all, people don’t think in two dimensions. Real world questions like, “How were last year’s monthly revenues broken down by store affected by back-order problems?” are more naturally handled by a multi-dimensional datastore than by a two-dimensional relational model.
As with all information-based technologies, your customers want to be able to access these multi-dimensional datastores and tools from popular desktop applications. The OLE DB for OLAP (ODBO) API has become the defacto standard for accessing multi-dimensional data. Coinciding with the availability of Excel 2010, Microsoft has defined a 64-bit ODBO interface specification as well. Visit www.xmlforanalysis.com for more information and history on OLE DB for OLAP (ODBO).
What is the cost of ownership for SimbaProvider SDK?
After your ODBO Provider or XMLA Provider is complete, SimbaProvider SDK continues to save you development effort in the future. When you build a data provider using SimbaProvider SDK, you do not have to worry about rewriting the data provider every time the ODBO or XMLA specifications change. We provide our customers with timely and regular updates that add functionality to your data provider. We provide the upgrade path to new versions of the ODBO and XMLA specifications.
How can I obtain more information about SimbaProvider SDK?
For more information about SimbaProvider SDK, contact us.
SimbaProvider 4.5 User Guides
- SimbaProvider for OLAP SDK 4.5 Developers Guide_Java
- SimbaProvider for OLAP SDK 4.5 Developers Guide_C++
- SimbaProvider for OLAP SDK 4.5 Quick Start Guide