This certification is valid only for the SAP BW NW 7.x systems. It is an SAP-certified, data-extraction integration solution based on the SAP Open Hub Service interface.
The software components in Figure 1 play different roles in designing and executing the ETL jobs for SAP BW. The SAP RFC library is a prerequisite for using the DataStage BW Pack and must be installed on both the DataStage Client and Server. The DataStage BW Pack uses the SAP RFC interface to call SAP BW and SAP BW functions.
Depending on the specific project requirements, you can choose to install a subset of the products in the IBM Information Server. Those products include Infosphere® DataStage®, Infosphere QualityStage®, Infosphere Information Analyzer, Infosphere Federation Server, and other companion products. IBM Information Server includes many software products for data integration and analysis tasks. Appendix B lists the tools for creating the examples shown in this article. In the SAP BW projects, IBM Information Server can be leveraged as an efficient ETL tool to process a large volume of data and build the enterprise data warehouse.Īppendix A explains the terminology used in this article. Businesses can use IBM Information Server to connect to various data sources, retrieve and process data contents, and deliver cleansed and high-quality information. IBM Information Server is a unified and comprehensive information integration platform. Designing the ETL jobs to load data into and extract data from SAP BW is often the most time-consuming task. It includes various activities such as planning, data modeling, data sizing, ETL job design, and performance tuning. Enterprises can use the SAP BW to read into their business, react to the market changes, and gain competitive advantages.īuilding an SAP BW data warehouse is a complex project.
SAP BW provides an Enterprise Data Warehouse solution for SAP customers to consolidate and analyse their business data.