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. We’ll take the SAP BusinessObjects suite as an example. The tool is based on an ETL program originally known as Data Integrator. Data Integrator is often used with another component tool known as Data Quality. As its name suggests Data Quality provides advanced data cleansing capabilities. Metadata Manager is a third component tool that can be used closely with Data Integrator to provide visibility into data lineage and data dependencies. There are several similar ETL tools in the market the best known of which are Informatica and Microsoft’s SQLServer Integration Serices (SSIS).
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.