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 user interface which is very easy to use if we have any problems to solve."
"Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier."
"The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic."
"The most valuable features of Informatica Cloud Data Integration for our clients are the AI capabilities within Informatica Intelligent Cloud Services."
"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 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."
"It is one of the best tools available for data integration."
"The product is scalable and excellent for enterprise-level organizations."
"It's saved time using visualization descriptions."
"The solution is stable."
"The scalability of SSIS is good."
"The solution is easy to use and developer friendly."
"The performance is good."
"The setup is straightforward. It's very easy to install."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"SSIS' best feature is SFTP connectivity."
"It would be helpful if there was a GenAI feature integrated into the system, especially regarding the data quality."
"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."
"Informatica Cloud Data Integration could improve the price by making it less expensive."
"I would also like to have profiling functionalities and quality transformations in the cloud."
"The biggest challenge I see is the IDE's for the cloud and automization are different."
"The vendor should have more training resources: online classes, free tutorial videos, etc."
"The current features are a bit complicated, and we need to write big scripts and test."
"The price modeling could be more flexible."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"It needs more integration tools, so you can connect to different sources."
"We have issues with SSIS connectors while extracting data from Excel sources."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"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."
"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."
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.