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 solution is straightforward."
"We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors."
"The solution has the best feature for parameterization."
"It has all the advantages of the Cloud in that you can use it without worrying about infrastructure, upkeep, or upgrades."
"The features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
"The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic."
"Whether we need data cleansing or data mastering, we get it all in one platform."
"Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"SSIS' best feature is SFTP connectivity."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The initial setup was easy."
"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."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The current features are a bit complicated, and we need to write big scripts and test."
"Error reporting and debugging need improvement."
"A general improvement in icons and the virtual interface would be good."
"It would be helpful if there was a GenAI feature integrated into the system, especially regarding the data quality."
"User/group administration could use improvement."
"Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
"We would like to have accessibility to the repository."
"Its pricing model can be improved. The response time from technical support can also be improved."
"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."
"The security could be improved, as it is more important in our context."
"The high prices attached to the product can be an area of concern where improvements are required."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"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."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"It's a legacy tool, that is nearing the end of its useful life."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
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.