Informatica PowerCenter Competitors and Alternatives

Get our free report covering Informatica, Microsoft, Microsoft, and other competitors of Informatica PowerCenter. Updated: July 2021.
521,189 professionals have used our research since 2012.

Read reviews of Informatica PowerCenter competitors and alternatives

RM
Managing Director at a consultancy with 11-50 employees
Reseller
Top 10
Frees staff to focus on data workflow and on what can be done with data, and away from the details of the technology

What is our primary use case?

Equalum is used to take legacy data, siloed data and information in the enterprise, and integrate it into a consolidated database that is then used, for the most part, for data transaction, whether it's an actual transaction within the enterprise itself, or a BI dashboard. BI dashboards and analytics are a big area, but overall the main use case is for large data integration across disparate data sources. The way it's deployed is a combination of on-premises and cloud. It's mainly on-prem, but in Japan and Korea, the adoption of cloud is definitely nowhere near the same as in North America or… more »

Pros and Cons

  • "It's a really powerful platform in terms of the combination of technologies they've developed and integrated together, out-of-the-box. The combination of Kafka and Spark is, we believe, quite unique, combined with CDC capabilities. And then, of course, there are the performance aspects. As an overall package, it's a very powerful data integration, migration, and replication tool."
  • "It's got it all, from end-to-end. It's the glue. There are a lot of other products out there, good products, but there's always a little bit of something missing from the other products. Equalum did its research well and understood the requirements of large enterprise and governments in terms of one tool to rule them all, from a data migration integration perspective."
  • "They need to expand their capabilities in some of the targets, as well as source connectors, and native connectors for a number of large data sources and databases. That's a huge challenge for every company in this area, not just Equalum."

What other advice do I have?

It's a great tool to use in any data transformation opportunity, especially focusing on real-time. The word "batch" should never be used in an organization, going forward. I know it's useful and it has its use cases and there are situations where it's helpful. Batch is a form of history and it will probably always be there until that legacy finally disappears. But, overall, if anybody wants to look at migrating and transforming their overall data into a real-time enterprise, there's not a better tool in the market today, in terms of its performance, price, usability, and support. Those four…
Ursula Fladeruf
Owner at mip GmbH
Real User
Top 20
Powerful, reliable and the ability to run it in parallel mode makes it very fast

What is our primary use case?

We are a consultancy company, so we are not using DataStage for our own purposes. We deploy it for our customers. We use it to supply data integration and data warehousing solutions based on the specific needs of clients.

Pros and Cons

  • "The product is a stable and powerful data management solution that can run in parallel mode for enhanced speed."
  • "The interface needs work to be more user-friendly."

What other advice do I have?

I would rate this particular product as a nine out of ten. It is very powerful and very fast, but the problems with the interface make it less than perfect. As far as other advice that I would have for other people considering this as a solution, the first and most important is to examine your needs and decide on the processes you want to build. From that, you can immediately have a better idea of the type of solution that might be best for you. Then it is a good idea to get the advice of a consultant — like us.
Hemant Raorane
Technical Architect at Team Computers
Real User
Top 20
Excellent data integration but needs better scheduling and monitoring features

What is our primary use case?

The primary use cases can change according to the company and requirements. We originally began using it as a data preparation tool, where you could do a data migration afterward.

Pros and Cons

  • "As long as you pick the solution that best fits with your requirements, you won't find that performance is a problem. It's good."
  • "The solution has room for improvement in the ETL. They have an ETL, but when it comes to the monitoring portion, Qlik Compose doesn't provide a feature for monitoring."

What other advice do I have?

We are partners with Qlik. Right now, I have not worked on the system in a hands-on capacity. I have an architectural understanding of the solution. Implementing the product is totally dependent upon the business side of an organization. If a company is just mid-scale or smaller in size, Qlik might be perfect. If you have a giant company, then you should aim for bigger products. Qlik Compose only provides for unique capabilities. There are other solutions, like Informatica, which may be better for larger firms with broader needs. I would rate the solution six out of ten.
EP
Senior Enterprise Information Architect at a transportation company with 10,001+ employees
Real User
Smart tool to design data pipelines that has good connection capabilities

What is our primary use case?

We are using the on-premises version. It is a smart tool for us to design data pipelines. It lets us populate our three data lake instances. We like this solution for its connection capabilities since it is very important to be able to use many different types of software. We tested a lot of SAP sources successfully, including cloud sources with SAP. It is also very easy to anonymize data with TIBCO, as well as populating HDFS files, packet files, and raw files. It is very easy to do that with Talend Data Fabric.

Pros and Cons

  • "It is a smart tool for us to design data pipelines. It lets us populate our three data lake instances. We like this solution for its connection capabilities, since it is very important to be able to use many different types of software. We tested a lot of SAP sources successfully, including cloud sources with SAP. It is also very easy to anonymize data with TIBCO, as well as populating HDFS files, packet files, and raw files. It is very easy to do that with Talend Data Fabric."
  • "Deployment can be difficult, but I didn't test the latest version yet. With Talend products, every release brings a lot of new features and functionalities. This is never a small adaptation, because the tool is maturing, but we need to test the latest version and to check its deployment capabilities."

What other advice do I have?

We needed a smart supporter because this is the first type for the users. The first time the user plays with the tool is always the most difficult period. We have a couple of experts to help with that. It is very, very important to have technical experts on the sources. If you want to connect an ACP source, for example, whatever the flavor, if you don't have your team or you don't ask the SAP expert, you will fail. This is very easy for a SAP expert, because the Talend documentation is very smart. You fill in talend.com and everything is well explained. If, however, you are not able to…
EB
Data Integration Specialist/CTO at Asset messages
Real User
Top 20
A complete product with good integrations and excellent flexibility

What is our primary use case?

I primarily use the solution for integration. I consolidate data from several different databases and spreadsheets and merge systems into Amazon Redshift.

Pros and Cons

  • "The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily."
  • "The server-side should be completely revamped."

What other advice do I have?

I am an IT Consultant. I use it currently in my job. I'm providing services to a company in Australia, using Talend. I would advise others to use the Studio. If you have to pay for some license to use the key parallelize component, it's a good idea to do it. However, don't use the TAC. Use the other orchestration services like Control-M or AWS functions such as AWS Lambda. Don't use the TAC. The TAC is really ugly. Overall, I'd rate the solution eight out of ten. I'd rate it higher, however, the TAC is unreliable. It's a big part of the solution, and, while I do really appreciate Talend Studio…
Get our free report covering Informatica, Microsoft, Microsoft, and other competitors of Informatica PowerCenter. Updated: July 2021.
521,189 professionals have used our research since 2012.