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."Informatica is good for integrating data and cloud applications. We have connectors for integrating cloud applications like Salesforce. You can quickly integrate anything with an exposed API or a REST API. The industry is increasingly shifting to the cloud, so we need more products that can connect to cloud-based applications. The integration is seamless and works in real time. It's also secure because you don't need to expose databases or tables."
"It has a more UI-based tool, and the scripting is good."
"The most valuable feature of Informatica Cloud Data Integration is Pushback. You are able to push the data to the solution itself, and it can handle the queries. It helps us a lot. With other tools, the burden is kept on the server."
"It has become an easy way to exchange information through any cloud application."
"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."
"Informatica Cloud Data Integration is stable."
"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."
"The data reader is the most valuable feature."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"It's a competent product."
"It's already very user-friendly and has a good dashboard."
"The performance is good."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"Overall, it's a good product."
"The product's deployment phase is easy."
"There are a small number of UI bugs that occur on occasion."
"It needs to be a little more intuitive but it’s really not bad."
"Its features for partitioning and optimization could be better."
"We would like to have accessibility to the repository."
"The cloud version could be better in terms of pricing."
"Connectivity could be improved, it can be a little slow."
"It could be improved by including a buffer that saves data when there is a connectivity issue."
"Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"It needs more integration tools, so you can connect to different sources."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"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 difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"It hangs a lot of the time."
"Options for scaling could be improved."
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.