We performed a comparison between Informatica PowerCenter, Jitterbit Harmony , and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"It has good standard features for ETL development."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"The number of docs has been reduced drastically, which is very good."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"It is very easy to build integrations and processes to pull and push data."
"It is a scalable solution."
"Jitterbit provides the ability to quickly map data between files and databases."
"It runs like an appliance and has tremendous throughput."
"Easy integration with Salesforce"
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"The Cloud Console for monitoring and troubleshooting data operations."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The setup is straightforward. It's very easy to install."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The product's deployment phase is easy."
"There is some room for improvement in terms of pricing."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside."
"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"Sometimes additional connectors are needed."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"I would like the ability to offer a dedicated cloud version for security."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"Its API management capabilities need improvement."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"The initial setup can be a little bit difficult."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"The security could be improved, as it is more important in our context."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"We'd like more integration capabilities."
"Future releases should improve the data lineage, as it currently is not good."
"I would like to see better integration with Power BI."
"Improvement as per customer requirements."
