How to Consume Web Services in SAP Data Services

  • by Sunil Mehta, Solution Architect, SAP
  • Virendra K. Soni, SAP Data Services Consultant, SAP
  • Biswajit Biswas, Subject Matter Expert in SAP Analytics, SAP GD
  • November 22, 2013
Learn the steps to call Web services in SAP Data Services and use them in Data Services jobs. This how-to guide provides configuration steps for connecting with the Web services datastore. It includes configuration advice about which datastore type to use and how to configure it. Some real-life scenarios show where this technique can be used to complete complex tasks.
Learning Objectives

After reading this article, you will know how to:

  • Configure a Web services datastore.
  • Import available functions from the Web services metadata.
  • Call a Web service function in a Data Services job.
Key Concept

SAP Data Services integrates with multiple types of databases, including third-party applications, SAP ERP Central Component (SAP ECC), SAP NetWeaver BW, JD Edwards, and Web services. SAP Web services datastore provides you with the functionality to call programs hosted on external servers. It represents a connection from Data Services to an external Web service-based data source.

Before we explain the steps to set up a Web services datastore and consume it, let’s understand when its use is essential. Typically, in a data conversion or migration or a warehouse extraction, transformation, and loading (ETL) program, a few processes such as currency conversion or job scheduling are continuous or recurring. However, currency conversion and conditional job scheduling are not integrated with SAP Data Services.

Therefore, you need to connect with external programs to perform both tasks. You can use Data Services with services from many providers to perform currency conversion on the fly. Another example of a useful Web service is a weather map. Perishable goods, travel, logistics, and airline companies need weather information to be stored in their databases to manage and track the goods or the fleets efficiently.

We use a business scenario and step-by-step instructions to explain all the configuration points to enable consumption of Web services. We demonstrate the basics for configuring the Web services datastore and then consuming that Web service in a batch job.

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

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


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.