A critical component in the BI System is the ability to take your source system data, clean it, and then load it into data your warehouse. It is this quality assured data that forms the backbone of your ‘single version of the truth’ in Business Intelligence. To achieve the timely loading of quality assured data a software program known generically as an ETL tool is used. In the SAP BusinessObjects suite the tool is a best of breed ETL program known as Data Integrator. Data Integrator is often used with another tool known as Data Quality. As its name suggests Data Quality provides advanced data cleansing capabilities. Metadata Manager is a third tool that can be used closely with Data Integrator to provide visibility into data lineage and data dependencies. It helps organisations to realise ‘trusted BI’ (quality assured data delivered to the information consumer). Finally, Data Federator is a program that will allow you to create a virtual data mart when you need data quickly. These four tools form the Information Management component of the SAP BusinessObjects BI suite known as Data Services.
The new SAP BusinessObjects Business Intelligence Platform release BI 4.0 ushered in a new era by providing multi-source universes. In earlier versions developers attempted joined up data through ‘linked’ universes and synchronised data providers within Web Intelligence, and the now deprecated, Desktop Intelligence.
BI 4.0 universes are now integrated with Data Federator connectivity. This connectivity then exploits further powerful integration between Data Federator and SAP Netweaver. This means that in a single SQL based universe relational SQL data can be joined with SAP Netweaver data and is no longer being forced to use the MDX Engine and an OLAP based source.
The original Data Federator product was acquired by BusinessObjects a few years ago at the time that Russell Beech was employed with BusinessObjects UK. Consequently he has had an interest in and knowledge of Data Federator for several years.
BISB have now established a Data Federator system and are currently developing multi-source universes to support their live customer demos. Customers wanting to know more or to see Data Federator in action should contact BISB via the BI System Builders website.
SAP BusinessObjects Data Quality is the industry’s most advanced enterprise data quality solution, offering centralized data quality services through a service-oriented architecture. It offers powerful data parsing, cleansing, standardization, matching, and consolidation capabilities to ensure that users can build a data quality solution that meets any business need.