SSIS vs Spring Cloud Data Flow comparison

Cancel
You must select at least 2 products to compare!
VMware Logo
2,449 views|1,823 comparisons
100% willing to recommend
Microsoft Logo
Read 69 SSIS reviews
19,568 views|15,878 comparisons
79% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Spring Cloud Data Flow and SSIS based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration.
To learn more, read our detailed Data Integration Report (Updated: April 2024).
767,995 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"There are a lot of options in Spring Cloud. It's flexible in terms of how we can use it. It's a full infrastructure.""The most valuable features of Spring Cloud Data Flow are the simple programming model, integration, dependency Injection, and ability to do any injection. Additionally, auto-configuration is another important feature because we don't have to configure the database and or set up the boilerplate in the database in every project. The composability is good, we can create small workloads and compose them in any way we like.""The product is very user-friendly.""The most valuable feature is real-time streaming."

More Spring Cloud Data Flow Pros →

"SSIS integrates well with SQL servers and Microsoft products.""It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud.""It's saved time using visualization descriptions.""SSIS' best feature is SFTP connectivity.""The performance is good.""The scalability of SSIS is good.""SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together.""It's already very user-friendly and has a good dashboard."

More SSIS Pros →

Cons
"The configurations could be better. Some configurations are a little bit time-consuming in terms of trying to understand using the Spring Cloud documentation.""Spring Cloud Data Flow could improve the user interface. We can drag and drop in the application for the configuration and settings, and deploy it right from the UI, without having to run a CI/CD pipeline. However, that does not work with Kubernetes, it only works when we are working with jars as the Spring Cloud Data Flow applications.""Some of the features, like the monitoring tools, are not very mature and are still evolving.""On the tool's online discussion forums, you may get stuck with an issue, making it an area where improvements are required."

More Spring Cloud Data Flow Cons →

"I would like to see better technical documentation because many times information is missing.""Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included.""I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use.""The performance of this solution is not as good as other tools in the market.""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.""Performance could be better.""Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options.""SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

More SSIS Cons →

Pricing and Cost Advice
  • "This is an open-source product that can be used free of charge."
  • "If you want support from Spring Cloud Data Flow there is a fee. The Spring Framework is open-source and this is a free solution."
  • More Spring Cloud Data Flow Pricing and Cost Advice →

  • "This solution has provided an inexpensive tool, and it is easy to find experienced developers."
  • "My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
  • "This solution is included with the MSSQL server package."
  • "It would be beneficial if the solution had a less costly cloud offering."
  • "Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
  • "We have an enterprise license for this solution."
  • "It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
  • "All of my clients have this product included as part of their Microsoft license."
  • More SSIS Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    767,995 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations There are many third-party vendors offering ETL solutions, but two of the most popular are PowerCenter Informatica and Microsoft SSIS (SQL Server Integration Services). Each technology has its advantages but there are also similarities on how they carry out the extract-transform-load processes and only differ in terminologies. If you’re in the process of choosing ETL tools and PowerCenter Informatica and Microsoft SSIS made it to your shortlist, here is a short comparative discussion detailing the differences between the two, as well as their benefits. Package Configuration Most enterprise data integration projects would require the capacity to develop a solution in one platform and test and deploy it in a separate environment without having to manually change the established workflow. In order to achieve this seamless movement between two environments, your ETL technology should allow the dynamic update of the project’s properties using the content or a parameter file or configuration. Both Informatica and SSIS support this functionality using different methodologies. In Informatica, every session can have more than one source and one or more destination connections. There are… Read more →
    Questions from the Community
    Top Answer:On the tool's online discussion forums, you may get stuck with an issue, making it an area where improvements are required. The online discussion forum for the tool should include possible questions… more »
    Top Answer:I used the solution for a payment platform we integrated with our organization. Our company had to use it since we had to integrate it with different payment platforms.
    Top Answer:Spring Cloud Data Flow is a useful product if I consider how there are different providers with whom my company had to deal, and most of them offer cloud-based products. I can't explain any crucial… more »
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free… more »
    Top Answer:The product's deployment phase is easy.
    Top Answer:If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive.
    Ranking
    29th
    out of 100 in Data Integration
    Views
    2,449
    Comparisons
    1,823
    Reviews
    2
    Average Words per Review
    598
    Rating
    8.0
    2nd
    out of 100 in Data Integration
    Views
    19,568
    Comparisons
    15,878
    Reviews
    35
    Average Words per Review
    471
    Rating
    7.7
    Comparisons
    Also Known As
    SQL Server Integration Services
    Learn More
    Overview

    Spring Cloud Data Flow is a toolkit for building data integration and real-time data processing pipelines.
    Pipelines consist of Spring Boot apps, built using the Spring Cloud Stream or Spring Cloud Task microservice frameworks. This makes Spring Cloud Data Flow suitable for a range of data processing use cases, from import/export to event streaming and predictive analytics. Use Spring Cloud Data Flow to connect your Enterprise to the Internet of Anything—mobile devices, sensors, wearables, automobiles, and more.

    SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

    Sample Customers
    Information Not Available
    1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm29%
    Computer Software Company16%
    Manufacturing Company7%
    Retailer7%
    REVIEWERS
    Financial Services Firm23%
    Healthcare Company8%
    Computer Software Company8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company12%
    Government7%
    Healthcare Company6%
    Company Size
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise9%
    Large Enterprise78%
    REVIEWERS
    Small Business27%
    Midsize Enterprise18%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    Data Integration
    April 2024
    Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration. Updated: April 2024.
    767,995 professionals have used our research since 2012.

    Spring Cloud Data Flow is ranked 29th in Data Integration with 5 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Spring Cloud Data Flow is rated 8.0, while SSIS is rated 7.6. The top reviewer of Spring Cloud Data Flow writes "Provides ease of integration with other cloud platforms ". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Spring Cloud Data Flow is most compared with Apache Flink, Google Cloud Dataflow, Apache Spark Streaming, Azure Data Factory and TIBCO BusinessWorks, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.

    See our list of best Data Integration vendors.

    We monitor all 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.