Data Services

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.

Leave a Reply