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 agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"The user interface and user experience are perfectly all right."
"It is a scalable and versatile solution."
"The data transformation is the solution's most valuable feature."
"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 solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"Provides a significant amount of control over the landscape and overall implementation."
"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."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"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."
"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."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The initial setup was easy."
"It has good data integration and good processes."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"It's saved time using visualization descriptions."
"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."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"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 product is not suitable for application integration."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"I would like the stability to improve."
"Integration with the largest number of databases and other systems would be important."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"We have issues with SSIS connectors while extracting data from Excel sources."
"The high prices attached to the product can be an area of concern where improvements are required."
"Tuning using this solution requires extensive expertise to improve performance."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"I would like to see better integration with Power BI."
"Generic processes should be used instead of custom code for each table."
Informatica PowerExchange is ranked 20th 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, Informatica Cloud Data Integration, 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.