Powered By Blogger

Saturday, March 5, 2011

Informatica and Service Oriented Architecture (SOA)

What is Informatica?
Informatica Corp was founded in 1993 in the Silicon Valley by Indian Entrepreneurs Gaurav Dhillon and Diaz Nesamoney. It was based on the idea that data warehouses should not be "handcoded", but instead can be built more efficiently with graphical tools.
PowerCenter 8.1 is the company's flagship product. The advanced edition includes Metadata Manager (formerly SuperGlue), Data Analyzer (formerly PowerAnalyzer) and other options.
New features in PowerCenter 8.1 include Grid Computing support for scalability, Java Custom Transformation Support, HTTP Transformation Support, High Availability, Push Down Optimization (ELT Architecture), Enhanced web services to leverage a service oriented architecture and Mapping Template Creation support through Microsoft Visio. It also comes with adapters to various data source systems ranging from RDBMS to Message-oriented middleware's to Web Services to Applications.

What is SOA?
It is an architectural style where all business functionalities are grouped in Services. Each service communicates which each other by passing data from one service to another or by co-coordinating activity between one or more services.
SOA is neither product nor professional application. It is just an Architectural concept.
SOA is not a platform like J2EE, Dot.Net. It can be used as a bridge between two platforms.

Why SOA?
SOA promotes the goal of separating users (consumers) from the service implementations. Services can therefore be run on various distributed platforms and be accessed across networks. This can also maximize reuse of services


1. Loose coupling reducing the chance that changes in one service necessitates changes in other service
2. Location transparency providing an enterprise the flexibility to move to a different service without affecting the application
3. Platform independence through an abstraction layer that enables integration without having to having understand individual components
4. Reliability and robustness through inherent scalability of and lack of single point failures in SOA
5. Improved responsiveness through a common architecture

How Informatica fits in SOA?
Informatica platform is designed to work in a Service Oriented Architecture

All richness of Informatica Data Integration Functionality can be exposed as Data Services over standards-based web service protocols

Using Web Services Hub, first time released with Informatica 7.X version, Web Services Provider provides some of the PowerCenter Server functionality through a service-oriented architecture.

Web Services Hub
1. A PowerCenter Service gateway for external clients.
2. Processes SOAP requests from web service clients that want to access PowerCenter web services.
3. Receives requests from web service clients and passes them to the PowerCenter Server or the Repository Server.

The PowerCenter Server or the Repository Server process the requests and send a response to the web service client through the Web Services Hub. The content of the response depends on the type of service.

Web services
1. Batch Web Services :
a. Allows running of PowerCenter Workflows from external application
b. Monitoring execution
c. Used in integration with External Scheduler
2. Metadata Web Services :
a. Allows logging into to Repository to browse Metadata
b. Used for performing Authentication Functions to log in and Log out of repository
3. Real-time Web Services :
a. Used to expose Transformation logic as a service.
b. Create service workflows that allow you to read and write messages to a web service client through the Web Services Hub

When you put all services together, the PowerCenter Web Service Architecture looks like as below.

From Business point of view, above architecture delivers all Data service in company’s SOA.


No comments: