Mapping: Web Service Using HTTP Transformation
Posted by: DI Soln
A PowerCenter mapping example that demonstrates how you can make Web Service calls using Informatica HTTP transformation and get data from web servers.
Overview
In a matured data warehouse environment, you will see all sorts of data sources, like Mainframe, ERP, Web Services, Machine Logs, Message Queues, Hadoop etc. Informatica has provided a variety of connector to get data extracted from such data sources. Using Informatica HTTP transformation, you can make Web Service calls and get data from web servers. We will have this transformation explained in this article with a use case. What is HTTP Transformation:The HTTP transformation enables you to connect to an HTTP server to use its services and applications. When you run a session with an HTTP transformation, the Integration Service connects to the HTTP server and issues a request to retrieve data from or update data on the HTTP server.For example, you can get the currency conversion rate between USD and EUR by calling this web service call. http://rate-exchange.appspot.com/currency?from=USD&to=EUR Using HTTP Transformation you can :
- Read data from an HTTP server: It retrieves data from the HTTP server and passes the data to a downstream transformation in the mapping.
- Update data on the HTTP server: It posts data to the HTTP server and passes HTTP server responses to a downstream transformation in the mapping.
Features
Specifications:
- Informatica PowerCenter 9.1 and above
