We performed a comparison between Informatica Cloud Data Integration and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"The mass ingestion functionality and the elasticity of the solution are great."
"The support is very good."
"Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job."
"The most valuable features of the solution are pushdown, optimization, and partitioning, which can be used for frequent data loading, especially when we have a huge data volume in our company."
"The features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
"Informatica Cloud Data Integration is stable."
"Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier."
"It is easy to set up the solution."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The setup is straightforward. It's very easy to install."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"It is easy to set up the product."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The setup was easy. All Microsoft products are easy to set up."
"Informatica Cloud Data Integration could improve the price by making it less expensive."
"There may be some types of limitations with the performance."
"The price modeling could be more flexible."
"The current features are a bit complicated, and we need to write big scripts and test."
"The vendor should have more training resources: online classes, free tutorial videos, etc."
"One area that needs to improve is the user experience because it is very complex. The trial version is very complex so it's not easy to start using the program immediately. You must study the rules first."
"The cloud version could be better in terms of pricing."
"With the solution, we had some issues, and we have every day, and we used to open a ticket. Sometimes, there are data issues and transformation issues."
"The performance of SSIS could improve when comparing it to Oracle Database."
"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."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"We'd like more integration capabilities."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"It hangs a lot of the time."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
More Informatica Cloud Data Integration Pricing and Cost Advice →
Informatica Cloud Data Integration is ranked 5th in Cloud Data Integration with 40 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Informatica Cloud Data Integration is rated 7.8, while SSIS is rated 7.6. The top reviewer of Informatica Cloud Data Integration writes "A stable, scalable, and user-friendly solution". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Informatica Cloud Data Integration is most compared with Informatica PowerCenter, Azure Data Factory, AWS Glue, Fivetran and Talend Open Studio, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and SnapLogic. See our Informatica Cloud Data Integration vs. SSIS report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.