RelationalCube for SAP BW

Access to Your Multi-dimensional Data Source With SQL
Overview
Features
Specifications
FAQs
Documentation

We Innovated the World’s First SQL to MDX Connection.

RelationalCube for SAP BW Connector DiagramSimba RelationalCube is an advanced ODBC driver developed by Simba Technologies that maps SQL to any SAP BW. Supports OLE DB and SAP® BAPI to provide a virtual star schema view of a multi-dimensional data cube, opening up your multi-dimensional data to all query and reporting tools that talk SQL. Runs on a client machine or server and allows you to retrieve data from InfoCubes, BEx query, MultiProviders and Virtual Cubes.

Use SAP NetWeaver Business Warehouse to capture, store, and consolidate vital information. Tightly integrate your warehousing capabilities for a single version of the truth, decision-ready business intelligence, and accelerated operations. The vast majority of query and reporting applications talk ODBC/SQL but very few tools talk MDX. Simba RelationalCube allows decision makers to use the familiar query and reporting tool and combines the strengths of SQL and MDX, supporting both SQL-based and MDX-based analytics within a multi-dimensional data cube.

Product Highlights

  • Easy to set-up
  • Easy to configure and use
  • Based on standard data protocols
  • SQL, ODBC, JDBC, MDX, OLE DB for OLAP (ODBO) and XML for Analysis (XMLA) compliant

Contact us today for a free software evaluation.

m4s0n501

Product Features

  • Retrieve data from InfoCubes, BEx query, MultiProviders and Virtual Cubes.
  • Direct BI connectivity to data without extraction
  • Full compatibility with leading analytic/reporting apps, including Alteryx, Microsoft Excel & Access, SAP Crystal Reports, Tableau and more
  • Maps ANSI SQL-92 to MDX
  • Provides full driver and query metadata

Product Specifications

  • Supports 32 bit apps
  • Complies with ODBC 2.5 specification
  • Compatible with SAP BW 3.5 and up
  • Supports Windows XP SP3 and later
  • Supports ANSI SQL-92: SELECT, JOIN, WHERE, HAVING, GROUP BY, ORDER BY, UNION [ALL] and most SQL-92 scalar and aggregate functions

Product FAQ

  • What is Simba RelationalCube?

    Simba RelationalCube is an ODBC driver for accessing multi-dimensional data sources using SQL.

  • Why should I use Simba RelationalCube for SAP BW?

    Until now, SAP has only provided the API centered on MDX for use with SAP BW. Simba RelationalCube for SAP BW enables you to connect to SAP BW from SQL-based applications.

  • How does Simba RelationalCube work?

    Simba RelationalCube features a dynamic transform engine that creates a virtual star schema from a multi-dimensional data cube. It also translates SQL statements into the required sequence of MDX statements.

  • Does Simba RelationalCube require any maintenance?

    Simba RelationalCube is designed as a streaming driver and does not use any external repository. The only maintenance required is that for your SAP BW instance.

  • What standards does Simba RelationalCube for SAP BW conform to?

    Simba RelationalCube for SAP BW is a full-fledged ODBC driver that conforms to the ODBC 2.5 standard. It includes Simba’s proven SQL-92 compliant SQL engine.

  • How does Simba RelationalCube for SAP BW connect to SAP BW?

    Simba RelationalCube for SAP BW uses the SAP OLAP BAPI and MDX via SAP RFC.

  • Can I use Simba RelationalCube for SAP BW from COM/OLE DB?

    You can use Simba RelationalCube for SAP BW as an OLE DB provider using any standard OLE DB to ODBC bridge.

  • How does Simba RelationalCube for SAP BW present SAP BW metadata?

    Simba RelationalCube for SAP BW uses a combination of SQL’s metadata model (tables, columns, joins) with special stored procedures to return all SAP BW metadata. One SAP BW catalog (group of cubes) is converted into a SQL catalog. One SAP BW cube is converted into a collection of tables.

  • Is Simba RelationalCube for SAP BW secure?

    Simba RelationalCube for SAP BW uses your existing SAP security infrastructure. It is as secure as using SAPGUI.

  • What version of SAP BW does Simba RelationalCube for SAP BW support?

    Simba RelationalCube for SAP BW is supported for SAP BW 3.5 and onward.

Contact Sales

+1 (604) 633-0008
solutions@simba.com

Webinar

How to Build an ODBC Driver in Just 5 Days!

Play Webinar