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."Mainstream integration and real-time integration are the best features."
"Provides a significant amount of control over the landscape and overall implementation."
"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 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 product’s flexibility is valuable."
"It is a scalable and versatile solution."
"From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."
"The product's initial setup phase was not complex. The tool is easy to install onto any of the servers, and you can integrate it."
"It's a competent product."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The most important features are it works well and provides self-service BI."
"It is easy to set up. The deployment is also very quick."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The solution needs better integration with other tools."
"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."
"I would like the stability to improve."
"The product is not suitable for application integration."
"The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue."
"Integration with the largest number of databases and other systems would be important."
"Pushdown optimization could be improved."
"Technical support can be improved with respect to delays in ticket response time."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"I would like to see more features in terms of the integration with Azure Data Factory."
"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."
"It's a legacy tool, that is nearing the end of its useful life."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
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 "Handles big data better than competitors". 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, Azure Data Factory, Qlik Replicate and Informatica Cloud Data Integration, 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.