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.
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.
SAP BusinessObjects Metadata Manager is used with SAP BusinessObjects Data Integrator. Metadata Manager collates and unifies Business Intelligence data including ETL packages and third-party metadata. Using a Web interface and pre-built metadata reports users can easily view and analyze metadata through the Organization. The pre-built reports provide information on data usage, end-to-end change impact analysis, and report-to-source data lineage. Metadata Manager is a tool intrinsic to Trusted BI helping to deliver trusted data for compliance requirements and internal controls.