We performed a comparison between Informatica PowerExchange and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"The user interface and user experience are perfectly all right."
"This product is easy to install and it can be done in a few hours."
"It is a scalable and versatile solution."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"The product’s flexibility is valuable."
"Mainstream integration and real-time integration are the best features."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"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."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"The most important features are it works well and provides self-service BI."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"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."
"The solution is stable."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The connectivity with T24 core banking could be improved."
"I would like to have easier integration with cloud platforms."
"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"The product's high costs can be an area of concern where improvements are required."
"Pushdown optimization could be improved."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"Integration with the largest number of databases and other systems would be important."
"Improvement as per customer requirements."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"Tuning using this solution requires extensive expertise to improve performance."
"The solution could improve on integrating with other types of data sources."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"At one point, we did have to purchase an add-on."
"I would like to see better technical documentation because many times information is missing."
Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Informatica PowerExchange is rated 7.8, while SSIS is rated 7.6. The top reviewer of Informatica PowerExchange writes "Comprehensive, capable of handling large volumes, and helpful for fast-paced movement of data". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Qlik Replicate and Azure Data Factory, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Informatica PowerExchange vs. SSIS report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.