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 is quite easy to use and flexible."
"I like the fact that you can find almost any product connection that you need and the list is always expanding."
"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."
"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."
"We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors."
"The solution's initial setup is quite straightforward."
"The most valuable features of Informatica Cloud Data Integration for our clients are the AI capabilities within Informatica Intelligent Cloud Services."
"The data reader is the most valuable feature."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"SSIS is easy to use."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The UI is very user-friendly."
"The interface is very user-friendly."
"The performance is good."
"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."
"Connectivity could be improved, it can be a little slow."
"Certain shortcomings in the product's UI make it an area where improvements are required."
"A general improvement in icons and the virtual interface would be good."
"The error information provided is not informative, as compared to Power Center."
"There is room for improvement at the highest level in terms of useability and connectors for various types of new applications. The row processing performance could be better because you experience some latency dealing with high volumes of data. Most organizations will be dealing with multiple cloud applications, so you could see performance issues moving from one system to another."
"I have received feedback from certain teams and there is a steep learning curve to use this solution."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"We have issues with SSIS connectors while extracting data from Excel sources."
"Video training would be a helpful addition."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"At one point, we did have to purchase an add-on."
"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."
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 SnapLogic, 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.