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 features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
"Whether we need data cleansing or data mastering, we get it all in one platform."
"Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job."
"I like the fact that you can find almost any product connection that you need and the list is always expanding."
"The solution provides increased efficiency while still being user-friendly and easy to operate."
"The serverless capability and the packaging application of the solution are valuable."
"It has a more UI-based tool, and the scripting is good."
"The solution's initial setup is quite straightforward."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The initial setup was easy."
"It is easy to set up the solution."
"SSIS integrates well with SQL servers and Microsoft products."
"We can connect with multiple data sources easily using an external connector in SSIS."
"SSIS is easy to use."
"Its features for partitioning and optimization could be better."
"User/group administration could use improvement."
"I would also like to have profiling functionalities and quality transformations in the cloud."
"The price modeling could be more flexible."
"While my company operates on the cloud, we have seen that Informatica Cloud Data Integration has some performance issues causing it to lag."
"It needs to be a little more intuitive but it’s really not bad."
"Its pricing model can be improved. The response time from technical support can also be improved."
"A general improvement in icons and the virtual interface would be good."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"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."
"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 this solution is not as good as other tools in the market."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"The performance of SSIS could improve when comparing it to Oracle Database."
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 Qlik Replicate. 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.