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."REST API: Excellent for scripting control and reporting mechanisms"
"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."
"Whether we need data cleansing or data mastering, we get it all in one platform."
"The data mapping capability is a valuable feature."
"Informatica Cloud Data Integration is stable."
"The solution is straightforward."
"Data synchronization tasks."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"Overall, it's a good 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 product's deployment phase is easy."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The initial setup of this solution is very straightforward."
"Informatica Cloud Data Integration can improve by being more user-friendly. When you're working with the solution a lot of technical knowledge is required. It's not a solution that anyone can use properly, you need knowledge of what's happening at the back end, such as SQL. When you get stuck, you need to look into your logic. For other tools, such as Dell Boomi, anyone can use them."
"It would be helpful if there was a GenAI feature integrated into the system, especially regarding the data quality."
"One area that needs to improve is the user experience because it is very complex. The trial version is very complex so it's not easy to start using the program immediately. You must study the rules first."
"Connectivity could be improved, it can be a little slow."
"The cloud version could be better in terms of pricing."
"It could be improved by including a buffer that saves data when there is a connectivity issue."
"Certain applications are not being synced with the ION."
"I would like to see support for more data sources."
"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."
"We have issues with SSIS connectors while extracting data from Excel sources."
"This solution needs full support for real-time processing."
"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."
"The creation of the measure in the DAC's model could be improved."
"We'd like them to develop data exploration more."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
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.