Data Federator is a powerful multi-source SQL engine which help you to query your information systems uniformly.
In our last version, Data Federator XI 3.0 SP1 (aka 3.1), we developed a new connector to connect and query SAP BW using SQL.
This connector connects to BW at the aggregation engine layer bypassing the BW OLAP engine.
For instance, the table below summarizes the differences between OLAP universes and Data Federator relational Universes.
This means that OLAP features are not be supported but you will get other features like federation (be able to combine BW with other sources) and ad-hoc reporting scalability extremely well aligned with Web Intelligence and Universes.
The diagram below describes our connector architecture.
Today, the connector supports the InfoCube, Multiprovider and DSO Infoproviders and is fully compatible with BW Accelerator accelerations.
Data Federator exposes these info providers as star schema fully compatible with SQL 92.
This new connector complements the current BW access offering from the most advanced OLAP front end to the easy to use, scalable SQL connector.
This connector is a great opportunity to deploy WebI on top of SAP BW and deploy ad-hoc reporting for your end users.
For people who want to leverage this new opportunity, they have to upgrade their system to:
– SAP NetWeaver 7.01 (Enhancement Package 01) Support Package Stack 03 and install the collective note
– BOE XI 3.1 Fix Pack 1 or higher
– Data Federator XI 3.0 SP1 or higher
This connector is extremely easy to deploy and use as relational universes are automatically generated.
Stay tuned, I will explain the complete workflow in my How to configure the SQL BW connector.