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 solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"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."
"It is easy to integrate the solution with other tools."
"Provides a significant amount of control over the landscape and overall implementation."
"The scalability is excellent."
"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."
"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."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The technical support is very good."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The scalability of SSIS is good."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"It is easy to set up the product."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"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."
"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 needs better integration with other tools."
"The product's high costs can be an area of concern where improvements are required."
"I would like the stability to improve."
"Pushdown optimization could be improved."
"Video training would be a helpful addition."
"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."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"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."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"The solution could improve on integrating with other types of data sources."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
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, 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.