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."It is a scalable and versatile solution."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"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."
"The scalability is excellent."
"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 most valuable feature is connectivity to data sources."
"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."
"Provides a significant amount of control over the landscape and overall implementation."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The solution is stable."
"The performance and stability are good."
"The most important features are it works well and provides self-service BI."
"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 most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"Technical support can be improved with respect to delays in ticket response time."
"Should diversify more, maybe with a reporting and visualization utility,"
"The product's high costs can be an area of concern where improvements are required."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"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."
"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."
"Pushdown optimization could be improved."
"The solution needs better integration with other tools."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"It's a legacy tool, that is nearing the end of its useful life."
"This solution needs full support for real-time processing."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Future releases should improve the data lineage, as it currently is not good."
"We'd like more integration capabilities."
Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews while SSIS is ranked 2nd in Data Integration with 68 reviews. Informatica PowerExchange is rated 7.8, while SSIS is rated 7.8. 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, Qlik Replicate and Azure Data Factory, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage 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.