Pull Data More Easily with SAP NetWeaver BW 7.3 and SAP Data Services 4.0

  • by Biswajit Biswas, Subject Matter Expert in SAP Analytics, SAP GD
  • Sunil Mehta, Solution Architect, SAP
  • Virendra K Soni, SAP Data Services Consultant, SAP
  • December 9, 2013
This step-by-step guide demonstrates the integration between SAP Data Services 4.0 and SAP NetWeaver BW 7.3. With the introduction of Data Services as a new source system in SAP NetWeaver BW, data flows from SAP BusinessObjects Data Services can now be integrated to create a complete data model for Analytics.
Learning Objectives

Reading this article will teach you how to:

  •  Create Remote Function Calls (RFCs) in SAP NetWeaver BW and in SAP Data Services
  •  Create SAP Data Services DataSources
  •  Load data to the SAP NetWeaver BW Persistent Staging Area (PSA)
Key Concept
A new type of DataSource, Data Services, was introduced in SAP NetWeaver BW 7.3. (Before the release of SAP Data Services 4.0 it was known as BODS.) The integration makes it very easy to pull data from non-SAP and SAP systems directly into SAP NetWeaver through Data Services or from the SAP NetWeaver BW interface itself. The data pulling mechanism in earlier versions had limitations. For example, data had to be sent to SAP NetWeaver BW in a particular format. Now SAP and non-SAP systems’ data can be pulled using the same method so you do not need different options for different DataSources.

It’s well known that SAP NetWeaver BW works extremely well with SAP ERP Central Component (ECC) and other SAP products as its source systems. However, when it comes to integrating with non-SAP products, SAP NetWeaver’s options have a set of limitations. New functionality has been introduced that permits integration between the new SAP Data Services (formerly known as BODS) 4.0 and SAP NetWeaver BW 7.3. Creating SAP Data Services as a DataSource in SAP NetWeaver BW caters to all the previous challenges and also provides additional extraction, transformation, and loading (ETL) features.

The prerequisites are:

  • Access to SAP Data Services 4.0
  • User access to at least one SAP NetWeaver BW 7.3 system
  • Prior knowledge of the SAP NetWeaver BW Workbench and Data Services Management Console is helpful

Biswajit Biswas

Biswajit Biswas works at SAP GD and is a subject matter expert in SAP analytics. He has five years’ experience. He is proficient in the SAP BusinessObjects suite of reporting tools and SAP Data Services. He has been associated with development of Rapid Deployment Solutions for analytics on SAP HANA, focusing on the utilities industry.

See more by this author

Sunil Mehta

Sunil Mehta is a solution architect at SAP. He received his master’s degree in Computer Management from Symbiosis in Pune, India. He is a certified SAP FI/CO/BOBJ consultant, working in analytics. During his career he has been associated with Accenture, IBM, Capgemini, and KPMG, and has worked in various roles, including as a consultant solution architect and a project manager.

See more by this author

Virendra K Soni

   

Virendra K Soni is a Certified SAP Data Services Consultant and is currently associated with SAP. He has 6.5 years of industry experience in Data Migration, Data Conversion, and Data ware Housing with the Retail and Self-insurance industries. Prior to SAP he has worked with Capgemini, CSC, and HCL Technologies.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.