Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(2 Ratings)
facebook Twitter
Print Bookmark Alert me when this article is updated


FAQ: Data Services


How does PowerCenter work in a Service-Oriented Architecture (SOA)?

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. 

What are the key use cases supported by Informatica Data Services?

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:

  • enhancing the data warehouse with data that you cannot get access to fast enough, such as, where rapid on boarding of new data sources is a requirement or where transient or rapidly changing data needs to be integrated
  • where a timely and trusted single view of data is a needed.

How can Informatica Data Services be of use to an enterprise architect?

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.

What is different about Informatica 9 as compared to other data federation technologies?

Following are some of the primary differences:

  • Informatica 9 works as a logical model layer that is deployable as either web services or virtual tables
  • You can integrate data quality transformations/capabilities into the federation logic
  • You can deploy the data services directly to PowerCenter so they can be used in batch and real-time integration jobs without changing any logic
  • In future releases, you will have access to every data source that PowerCenter currently integrates with (Mainframe, Midrange, SaaS, and so on).

If all the logic is built to provision a logical data source, then what is the argument for letting it operate as a federated service instead of initiating the result as a physical database table?

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 into
the physical data warehouse or operational data store.


Will Informatica 9 Data Services allow us to create data /DAO layer without using traditional J2EE? And, what components of Informatica 9 do we need to be able to use Informatica 9 Data Services?

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.

How are Informatica Data Services different from Oracle ESB and other SOA tools?

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

How do Informatica Data Services compare with TIBCOs SOA offerings?

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.

Is it possible to access Data Services using other analytical tools, to run reports off it?

Yes, you may access Data Services from any tool that uses SQL or Web Services.

Can I work on any WSDL/API using Informatica 9? We use a variety of On- Demand products and data integration is a huge challenge.

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.

Is the Data Services option part of the Orchestration Services?

You can leverage the orchestration capabilities available in the Informatica Platform to orchestrate various data services into reusable combinations.


Will Informatica Data Services replace PowerCenter?

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.

How does the Informatica 9 Data Services compare to the PowerCenter 8 Data Federation Option? Do the new Data Services also perform data federation?

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. 

Is Composite Information Server used in Informatica 9 to provide DFO? Or, does Informatica develop its own federation engine?

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 is

Further, with Informatica Data Services, the data federation functionality leverages all the rich data transformation capabilities available in the Informatica Platform, including data quality.

How do we plan for (estimate) additional resources to support SOA on existing Informatica servers? Do you anticipate that we may need to add servers to increase capacity?

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.

More Information

Applies To
Product: Data Quality
Problem Type:
User Type:
Project Phase:
Product Version: PowerCenter 9.0
Operating System:
Other Software: Data Federation



Last Modified Date:12/16/2009 2:05 AMID:110165
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)