Kde…

Informatica PowerCenter Connect for Web Services

(You may find similar contents in Informatica Documentation. I have borrowed some description from the manuals to keep single version of truth alive.) 

Overview:

Informatica PowerCenter Connect for Web Services works as a consumer of a Web Service. You can use PowerCenter Connect for Web Services to integrate with PowerCenter to read data from a web service source and write data to a web service target. You can also transform data during a session using PowerCenter Connect for Web Services.

For example, in a financial system where you are required to submit only ‘validated’ data to your financial application (eg. peoplesoft). Your financial application may provide you with a functionality that lets you validate incoming data. It may provide you with a web services oriented functionallity to do that. In such case, while processing incoming data for some other validation, you would use Web Services Consumer Transformation using PowerCenter Connect for Web Services to send and recieve messages from the provided web service.

A web service is a set of operations that you can ‘consume’ over a intranet or the internet. You can look at a web service as one or more functions that return results. When you access a web service, you request that the web service perform an operation and return data. A web service can contain many web service operations.

Web service operations contain input and output messages. These messages are XML-formatted messages. They specify how to structure a request for a web service. Web service access involves providers and consumers. A web service provider refers to the server that hosts the web service. A web service consumer refers to the client that requests a web service. PowerCenter Connect for Web Services accesses web services as a web service consumer.

The web service you access can be remote or local. Someone at another organization can create and publish the web service, or someone at your organization can create and publish it.

You only use PowerCenter Connect for Web Services as a web service consumer. To expose a PowerCenter workflow as a web service and make it available to others, you use PowerCenter Web Services Provider.

To read data from a web service, write data to a web service, or transform data using a web service, you must import a web service operation. You can import a web service operation from a Web Services Description Language (WSDL) file. WSDL files describe web services and web service operations. PowerCenter Connect for Web Services uses the information in the WSDL file to access a web service operation.

PowerCenter Connect for Web Services uses the Simple Object Access Protocol (SOAP). SOAP is a protocol for exchanging information between computers. It specifies how to encode XML data so that programs on different operating systems can pass information to each other.

Web services hosts contain WSDL files and web services.

Coming soon : WSDL Files

One Response to “Informatica PowerCenter Connect for Web Services”

  1. July 1st, 2009 at 4:09 am

    partha says:

    Hi,
    I have an issue in webservices.pls help me
    I am using webservices as source in mapping which has a date column and i need to pull the data from the webservices based on the date column. i need to pass the date value dynamically.
    .Let me know how shall i pass this date value as a parameter.
    for reference : I am attaching the first line of my webservices source

    I need to pass the date dynamically for the above date column where currently i have given 2009-05-15 00:00:00 .When ever i run my mapping i will update a table called load driver which will have the status and the last date time for each mapping. So the date from the webservices needs to be picked up based on the last succes date from the load driver table.

Leave a Reply