RelationalCube is a family of ODBC drivers for accessing multi-dimensional data sources using SQL.
Until now, SAP has only provided the API centered on MDX for use with SAP BW. RelationalCube for SAP BW enables you to connect to SAP BW from SQL-based applications.
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.
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.
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.
RelationalCube for SAP BW uses the SAP OLAP BAPI and MDX via SAP RFC.
You can use RelationalCube for SAP BW from Java using our JDBC client. In this configuration, RelationalCube for SAP BW is a Type 4 JDBC driver.
You can use RelationalCube for SAP BW as an OLE DB provider using any standard OLE DB to ODBC bridge.
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.
RelationalCube for SAP BW uses your existing SAP security infrastructure. It is as secure as using SAPGUI.
RelationalCube for SAP BW is supported for SAP BW 3.0 and onward.
