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."It has a more UI-based tool, and the scripting is good."
"The solution provides increased efficiency while still being user-friendly and easy to operate."
"The solution is straightforward."
"Whether we need data cleansing or data mastering, we get it all in one platform."
"The program is stable and scalable."
"It is a scalable solution. Scalability-wise, I rate the solution a nine out of ten."
"I like the fact that you can find almost any product connection that you need and the list is always expanding."
"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 easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The data reader is the most valuable feature."
"It's already very user-friendly and has a good dashboard."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The scalability of SSIS is good."
"The setup was easy. All Microsoft products are easy to set up."
"SSIS integrates well with SQL servers and Microsoft products."
"The current features are a bit complicated, and we need to write big scripts and test."
"It could be improved by including a buffer that saves data when there is a connectivity issue."
"Informatica Cloud Data Integration could improve the price by making it less expensive."
"There may be some types of limitations with the performance."
"The integration process is not easy."
"Cost-wise, it could be better."
"I would also like to have profiling functionalities and quality transformations in the cloud."
"User/group administration could use improvement."
"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."
"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."
"The security could be improved, as it is more important in our context."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"It's a legacy tool, that is nearing the end of its useful life."
"I would like to see more features in terms of the integration with Azure Data Factory."
"It would be nice if you could run SSIS on other environments besides Windows."
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.