What users are saying about
78 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100
51 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 6.5 out of 100

Highlights

Informatica PowerCenter and Talend Data Integration are directly competing ETL tools supporting data integration. Talend aims to help users create a single source of truth for all their data no matter where it resides. PowerCenter is a metadata-based solution designed to serve as the foundation of data integration initiatives, supporting projects with accurate, valid data. Both solutions tend to be deployed in larger enterprises where data is generated by or resides in disparate applications and systems and that benefit most from operational analytics.

Features

Users of Talend Data Integration and Informatica PowerCenter describe a number of benefits to deploying either solution in the enterprise.

Talend Data Integration has an easy to understand and use interface. Users speak highly of its drag-and-drop process builder, and prebuilt components that save time and effort that might have been spent coding from scratch. Due to wide and general adoption, its active community of users presents solutions for many common issues, preventing the need for technical support for those getting started.

Informatica PowerCenter is known for its enterprise-readiness.It supports multi-user, multi-divisional environments well, as well as integrating data from disparate or legacy systems with multifarious data connectors.  PowerCenter also provides and supports many data transformation techniques. It is considered a relatively powerful and established ETL tool.

Limitations

Users give several reasons PowerCenter and Talend Data Integration might not represent the best solution for a particular data integration initiative.

While Talend Data Integration offers an open source free version, the open-source version is considered not a particularly effective tool for almost any project. Much of what users like about Talend is available on the licensed version only, which some users say is relatively expensive. Also, users say version management is a challenge, and its IDE is slow and its memory management is allegedly poor.

In contrast, Informatica PowerCenter lacks the ease of use of Talend. Its UI is less attractive and out-of-date, and some say plenty of training is required to get up and running. While a powerful ETL option, PowerCenter is not cheap, and Informatica offers no free or open source version at all, putting it out of reach of many users. Aside from its dated UI, Informatica PowerCenter also lacks compelling reporting and visualizations. 

Pricing

As stated, Talend Data Integration has a free and open source version. PowerCenter does not. Informatica PowerCenter For Windows (PAYG) is available from the vendor via AWS for $3.50 per hour or $24,528 per year, not counting AWS associated costs. A Microsoft Azure deployment is also available, with pricing by quote from the vendor. On-premise licensing for PowerCenter is undisclosed, and discussable directly with Informatica.

Talend Data Integration licensing is $1,170 USD per user monthly, or $12,000 USD per user annually, with similar pricing for cloud or on-prem deployments. If a user wants to use only the Talend Data Pipeline designer, a design tool used to prepare data for analytics projects that is included in Talend Data Integration deployments, is also available standalone via usage based hourly pricing.

Likelihood to Recommend

Informatica PowerCenter

PowerCenter is well equipped to handle large amounts of data movement in an organization with many disparate sources and a structured development team. It excels in enforcing enterprise development standards through things like metadata manager and the monitoring capabilities (as well as being able to design monitoring rules for everything from naming standards to design practices). It is especially well suited at handling flat-file data in addition to its many connectors and native support for just about any ANSI standard database. For large development teams or the desire to remain flexible at an enterprise scale, Powercenter is a top-tier solution.For small projects or even smaller development teams with mostly a single data source, expect frustration with being able to quickly test a solution as the design flow is very structured. It is also designed in a way that segregation of duties at a very high level can also cause small development teams to be counter-productive. Each step in the design process is a separate application, and although stitched together, is not without its problems. In order to design a simple mapping for example, you would first need a connection established to the source (example, ODBC) and keep in mind that it will automatically name the container according to how you named your connection. You would then open the designer tool, import a connection as a source, optionally check it in, create a target, optionally check it in as well, and design a transformation mapping. In order to test or run it, you will need to open a separate application (Workflow Manager) and create a workflow from your mapping, then create a session for that workflow and a workflow for those one or more sessions at which point you can test it. After running it, in order to observe, you then need to open a separate application (Monitor) to see what it is doing and how well. For a developer coming from something like SSIS, this can be daunting and cumbersome for building a simple POC and trying to test it (although from the inverse, building an enterprise scalable ETL solution from SSIS is its own challenge).
Jody Gitchel | TrustRadius Reviewer

Talend Data Integration

Talend Data Integration is easy to use and learn. Talend Data Integration can perform bulk data migrations of up to a few million records without any issues. We have not tried it or had use case which required more than a few million records at a time. It works particularly well with databases and CRM software.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Informatica PowerCenter
8.4
Talend Data Integration
10.0
Connect to traditional data sources
Informatica PowerCenter
9.1
Talend Data Integration
10.0
Connecto to Big Data and NoSQL
Informatica PowerCenter
7.8
Talend Data Integration
10.0

Data Transformations

Informatica PowerCenter
9.0
Talend Data Integration
10.0
Simple transformations
Informatica PowerCenter
9.5
Talend Data Integration
10.0
Complex transformations
Informatica PowerCenter
8.6
Talend Data Integration
10.0

Data Modeling

Informatica PowerCenter
8.2
Talend Data Integration
6.1
Data model creation
Informatica PowerCenter
7.7
Talend Data Integration
8.0
Metadata management
Informatica PowerCenter
8.5
Talend Data Integration
9.0
Business rules and workflow
Informatica PowerCenter
9.0
Talend Data Integration
9.0
Collaboration
Informatica PowerCenter
7.9
Talend Data Integration
1.0
Testing and debugging
Informatica PowerCenter
7.7
Talend Data Integration
3.4

Data Governance

Informatica PowerCenter
8.5
Talend Data Integration
7.5
Integration with data quality tools
Informatica PowerCenter
8.3
Talend Data Integration
7.0
Integration with MDM tools
Informatica PowerCenter
8.6
Talend Data Integration
8.0

Pros

Informatica PowerCenter

  • Informatica has a wide range of support for databases. Pretty much every mainstream DBMS is compatible here.
  • Designing ETL mappings and workflows is a very intuitive process, and takes minimal learning time and effort even for a beginner.
  • Informatica's biggest strength is its sheer performance. It is unmatched in terms of handling large volumes of data.
Anonymous | TrustRadius Reviewer

Talend Data Integration

  • JSON parsing, if you are into highly nested JSON object parsing Talend has the ability to display the structure of JSON and allows you to define the extraction logic in the metadata. Same with XML source.
  • Customization, For mostly all ETL work you will have a component in Talend. And in case you have a very specific requirement you can end up easily designing a custom component that you can code and reuse and share with others.
  • Talend has a connectivity option to almost all the databases (relational or NOSQ)L and sources available. It also has generic JDBC/ ODBC drivers in case you need it.
  • I like the ease of deployment across environment (DEV and PROD) with the use of context variables.
Anonymous | TrustRadius Reviewer

Cons

Informatica PowerCenter

  • One of the challenges of PowerCenter is the lack of integration between the components and functionality provided by PowerCenter. PowerCenter consists of multiple components such has the repository service, integration service, metadata service. Considerable time and resources were required to install and configure these components before PowerCenter was available for use.
  • In order to connect to various data sources such as Netezza database or SAS datasets, PowerCenter requires the installation and configuration of separate plug-ins. We spent considerable time trouble-shooting and debugging problems while trying to get the various plug-ins integrated with PowerCenter and get them up and running as described in the documentation.
  • PowerCenter works well with structured data. That is, it is easy to work with input and output data that is pre-defined, fixed, and unchanging. It is much more difficult to work with dynamic data in which new fields are added or removed ad-hoc or if data format changes during the data ingest process. We have not been as successful in using PowerCenter for dynamic data.
  • One of the challenges of learning PowerCenter is that it is difficult to find documentation or publications that help you learn the various details about PowerCenter software. Unlike SAS Institute, Informatica does not publish books about PowerCenter. The documentation available with PowerCenter is sparse; we have learned many aspects of this technology through trial and error.
Anonymous | TrustRadius Reviewer

Talend Data Integration

  • Syncing with Git should be made easier
  • Can face issues with certain big data spaces
  • Support find it difficult to resolve complex issues
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Informatica PowerCenter

Informatica PowerCenter 10.0
Based on 4 answers
Our team enjoys using Informatica and feels that it is one of the best ETL tools on the market.
Robert Goodman | TrustRadius Reviewer

Talend Data Integration

No score
No answers yet
No answers on this topic

Usability

Informatica PowerCenter

Informatica PowerCenter 9.1
Based on 3 answers
Positives;- Multi User Development Environment- Speed of transformation- Seamless integration between other Informatica products.Negatives;- There should be less windows to maintain developers' focus while using. You probably need 2 big monitors when you start development with Informatica Power Center.- Oracle Analytical functions should be natively used.- E-LT support as well as ETL support.
Gurcan Orhan | TrustRadius Reviewer

Talend Data Integration

Talend Data Integration 9.0
Based on 1 answer
We use Talend Data Integration day in and day out. It is the best and easiest tool to jump on to and use. We can build a basic integration super-fast. We could build basic integrations as fast as within the hour. It is also easy to build transformations and use Java to perform some operations.
Anonymous | TrustRadius Reviewer

Performance

Informatica PowerCenter

Informatica PowerCenter 9.6
Based on 3 answers
PowerCenter is robust and fast, and it does a great job meeting all the needs, not just the most commercially vocal needs. In the hands of an expert power user, you can accomplish almost anything with your data. It is not for new users or intermittent users-- for that the Cloud version is a better fit. Be prepared for costly connectors (priced differently for each source or destination you are working with), and just be planful of your projects so you are not paying for connectors you no longer need or want
Anonymous | TrustRadius Reviewer

Talend Data Integration

No score
No answers yet
No answers on this topic

Support Rating

Informatica PowerCenter

Informatica PowerCenter 8.6
Based on 2 answers
Informatica power center is a leader of the pack of ETL tools and has some great abilities that make it stand out from other ETL tools. It has been a great partner to its clients over a long time so it's definitely dependable. With all the great things about Informatica, it has a bit of tech burden that should be addressed to make it more nimble, reduce the learning curve for new developers, provide better connectivity with visualization tools.
Anonymous | TrustRadius Reviewer

Talend Data Integration

Talend Data Integration 5.9
Based on 5 answers
Good support, specially when it relates to PROD environment. The support team has access to the product development team. Things are internally escalated to development team if there is a bug encountered. This helps the customer to get quick fix or patch designed for problem exceptions. I have also seen support showing their willingness to help develop custom connector for a newly available cloud based big data solution
Anonymous | TrustRadius Reviewer

Alternatives Considered

Informatica PowerCenter

PowerCenter is the industry leader when it comes to interfacing with multiple source and target systems. The graphical interface increases employee productivity while reducing human resource expenditures and training requirements. These other tools offer some similar capabilities, but lack the range and depth when compared with the PowerCenter platform.
Brian Randolph | TrustRadius Reviewer

Talend Data Integration

Talend is much versatile in assimilating various different business use cases. It covers more functionality and is packed with tons of features to explore. It has the ability to fine tune to each project, and not be a one-fits all solution. Problems with Excel, is that it is not suited for large projects, collaboration work. Alteryx is a very costly alternative.
Sanket Bharaswadkar | TrustRadius Reviewer

Return on Investment

Informatica PowerCenter

  • Positive - Easy to maintain processes built in Informatica Power Center.
  • Positive - Rapidly build and deploy ETL data mappings.
  • Positive - Develop the overall workflow process to run all ETL processes for the project.
  • Negative - Informatica Power Center can be a bit expensive, so your application needs to warrant the enterprise support.
Anonymous | TrustRadius Reviewer

Talend Data Integration

  • Easy to build complex data transformations.
  • Licensing model isn't that flexible.
  • Memory mangement for huge volumes of information. You have to modify ETL designs to handle it properly.
Josep Coves Barreiro | TrustRadius Reviewer

Pricing Details

Informatica PowerCenter

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Talend Data Integration

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Informatica PowerCenter
8.7
Talend Data Integration
5.3

Likelihood to Renew

Informatica PowerCenter
10.0
Talend Data Integration

Usability

Informatica PowerCenter
9.1
Talend Data Integration
9.0

Performance

Informatica PowerCenter
9.6
Talend Data Integration

Support Rating

Informatica PowerCenter
8.6
Talend Data Integration
5.9

Add comparison