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's initial setup is quite straightforward."
"The user interface which is very easy to use if we have any problems to solve."
"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 product is scalable and excellent for enterprise-level organizations."
"It is one of the best tools available for data integration."
"REST API: Excellent for scripting control and reporting mechanisms"
"The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"It's a competent product."
"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."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"It's already very user-friendly and has a good dashboard."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The setup is straightforward. It's very easy to install."
"User/group administration could use improvement."
"Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
"The cloud version of the Informatica, it's a very substandard product. They might say it's enterprise-ready but it's not at all ready. They need to add more features, such as improved data replication features. If you look at other tools, such as Matillion they are now cloud-native and flexible. Additionally, Informatica Cloud Data Integration should have a good migration strategy from Informatica PowerCenter to Informatica Cloud Data Integration."
"Its features for partitioning and optimization could be better."
"Error reporting and debugging need improvement."
"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."
"One area where Informatica Cloud Data Integration could improve is in providing more accelerators for certain functionalities."
"Connectivity could be improved, it can be a little slow."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"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."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"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."
"Options for scaling could be improved."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
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.