The Informatica Platform, which includes Informatica Data Services and PowerCenter, enhances and complements an SOA by delivering timely, trusted, and relevant data as a standard service to SOA. With the Informatica Platform, you can rapidly and easily create data services that can address the data integration gap in SOA.
Informatica Data Services are best suited for situations where business needs are dynamic requiring rapid IT turnaround. Where, the time to deliver data is a defined business need and where there is a need for better operational visibility and faster decision making. It is also well suited for business scenarios where historical data needs to be combined with transactional data.
The key use cases for Informatica Data Services are:
With Informatica Data Services, you can standardize on a single platform and a single set of skills for all forms of data integration (physical or virtual), in addition to data quality. You can design data services one time and deploy it multiple times by reusing data integration and data quality logic in several ways for all applications and projects.
Following are some of the primary differences:
Using Informatica 9 you can build data services one time and deploy them in any way. Data services can be deployed through federation, web services, or batch ETL processes without any rework. For example, an organization may need to quickly provision a new data source to augment an existing data warehouse through federation. Then at a later time decide to reuse the same data service as a batch ETL process to move data intothe physical data warehouse or operational data store.
Yes, using Informatica 9 you can create a data access layer without using traditional J2EE. The existing Informatica infrastructure will be used to support large numbers of queries, high scale, etc. You must buy Informatica Data Services separately even if you have bought PowerCenter.
Informatica Data Services complement and enhance SOA by delivering timely, trusted and relevant data to the SOA. Typically, traditional SOA technologies such as ESB and EAI cannot handle large volumes of data sets and have limited support for proactive data quality, etc. David Linthicum has written a white paper on this topic which is available here http://vip.informatica.com/?elqPURLPage=6285.
The primary difference lies in the capability for Informatica 9 logical data objects to be provisioned either as web service or as virtual tables, such as, objects that you can directly access through SQL from ODBC or JDBC.
Informatica 9 works with open standards based WSDL. Informatica provides a variety of tools to help you integrate data in the Cloud, between the Cloud and also on premise applications.
You can leverage the orchestration capabilities available in the Informatica Platform to orchestrate various data services into reusable combinations.
Informatica Data Services will not replace PowerCenter. Data services can be created and deployed independently of PowerCenter for request-response style applications. Data Services can also be deployed to PowerCenter for batch and real-time integration.
Informatica has made Data Federation technologies usable and useful by integrating it into the core architecture. The reuse of logic across paradigms is powerful. The reimplementation of a virtual data object as physical manifestation for point to point integration (at the click of a button) is a powerful capability.
Informatica 9 Data Services is our primary federation capability, now built on Informatica technology. It does perform data federation, but it has some differences from the Informatica 8.x product. Primarily, you can integrate data quality transformations directly in data federation logic and deploy data services to PowerCenter for batch and real time integration.
With Informatica 9 and specifically with Informatica Data Services, Informatica provides its own integrated data federation or data virtualization capabilities. Informatica Data Services provides a single environment to handle both physical and virtual data integration.
Additionally, the data federation capabilities available in Informatica Data Services takes data virtualization to an all new level. You can now create virtual views across heterogeneous data sources and at the same time you can profile and cleanse the data to ensure that you deliver timely and trusted data to any application, in the exact way it isrequired.
Further, with Informatica Data Services, the data federation functionality leverages all the rich data transformation capabilities available in the Informatica Platform, including data quality.
There are lots of variables in capacity planning: number of users, types of requests (complexity of the SQL statements), data volume, and so on. Since data federation requests generally have a different profile than batch or real time processing, we do recommend deploying data services to separate servers, while still accessing the same metadata repository. Because we scale linearly, the best way to get a handle on the capacity needed would be to benchmark a sample set of users and queries and extrapolate the results to determine the total capacity needed.
What can we do to improve this information (2000 or fewer characters)