SSIS vs Talend Data integration comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
Read 66 SSIS reviews
20,397 views|16,603 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between SSIS and Talend Data integration 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.
To learn more, read our detailed SSIS vs. Talend Data integration Report (Updated: January 2024).
756,468 professionals have used our research since 2012.
Q&A Highlights
Question: Which ETL tool would you recommend to populate data from OLTP to OLAP?
Answer: We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator). But OLAP exporting wasn't in our scope until now.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The performance is good.""This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language.""SSIS is easy to use.""SSIS' best feature is SFTP connectivity.""The solution is stable.""It is easy to set up the solution.""The performance and stability are good.""The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

More SSIS Pros →

"We have multiple use cases for this solution. We integrate with Salesforce, SAP and Oracle databases to build business logic and provide reporting.""I'm very passionate about this solution because if you look at any other tool that costs around $200 - $300,000, like Delphix which costs you a million dollars, Talend is very cheap and is almost is at par with what others can do. There is one thing which Delphix does which Talend cannot do, but overall, I would say apart from that, if you're looking for a solution, you should give it a try.""The product's integration with PostgreSQL and Jira has been helpful for us. Its performance is good. However, we do not use it for large data sets.""Talend Data integration has a wide library of connectors."

More Talend Data integration Pros →

Cons
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors.""I would like to see better technical documentation because many times information is missing.""SSIS sometimes hangs, and there are some problems with servers going down after they've been patched.""The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information.""The performance of this solution is not as good as other tools in the market.""Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion.""It would be nice if you could run SSIS on other environments besides Windows.""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."

More SSIS Cons →

"The tool's technical support needs to be better. It doesn't have a local data center but pushes everything to the cloud. They need to check in with customers to see if they're happy and how well the solutions work. They need to assign a customer success manager for the accounts they sell.""Due to using the open-source version of Talend Data Integration, which lacks a scheduler, our current approach involves developing jobs in Talend, exporting them as Java packages, and utilizing an external scheduler, such as Windows Scheduler, to manage the scheduling process.""Sometimes there are bugs which are unidentified and we have to follow-up with the Talend team to resolve them. In a critical situation, it takes time for them to update patches.""There are no concurrent licenses, they only have seat licenses on cloud. That's the whole challenge. For example, if in any project your headcount increases or decreases, you do not have that concurrence and you have a seat license, you run into challenges because you have to procure a few more licenses for getting the job done."

More Talend Data integration Cons →

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 →

  • "I have been using the open-source version."
  • More Talend Data integration Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    756,468 professionals have used our research since 2012.
    Answers from the Community
    RajneeshShukla
    AThiré - PeerSpot reviewerAThiré
    User

    There are two products I know about
    * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cubes . price approx 40K$, works with tables
    . Attunity (Bought by Qlik) : technology agnostic , nice web interface , expensive > 100K€. Works with transaction logs

    There are many other pure ETL tools
    * ERWIN has a nice one ,

    Phil Wilkins - PeerSpot reviewerPhil Wilkins (Capgemini)
    Consultant

    Depends upon the technologies being used. If you're using Oracle for both OLTP and OLAP then you'll get a lot of value from an Oracle solution.


    The other question is how up to date do you want your OLAP DB to be? Goldengate is a good answer if you're looking to minimize latency, but it can be expensive. ODI is less expensive but better suited to bulkier data sets.  If an Oracle product wasn't the option I'd probably consider something like Informatica.

    Karoly Krokovay - PeerSpot reviewerKaroly Krokovay
    Real User

    Hi Rajneesh,
    yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hitachi-overview.pdf

    And a short description of the community edition: https://www.predictiveanalyticstoday.com/pentaho-community-edition/

    And the download link: https://community.hitachivantara.com/s/article/downloads

    You can ask more from the great community: https://forums.pentaho.com/

    Regards
    Károly

    Stefan Schäfer - PeerSpot reviewerStefan Schäfer
    User

    We usually use Talend.
    Look here: https://community.talend.com/t5/Design-and-Development/The-way-from-OLTP-to-OLAP/td-p/116719

    GaryM - PeerSpot reviewerGaryM
    Real User

    As someone mentioned, if you're purely Oracle shop and staying that way then there's value with prioritizing Oracle tools.  However, let me contrast that with this caveat...


    Consider expectations for tool and vendor longevity. Oracle has a long history of retiring and/or replacing tools leaving customers in the cold with prior versions/tools (I've been burned multiple times by Oracle product retirements or replacements including OWB, Oracle Designer2k, Oracle Express, Oracle OEDW, their purchase of Sagent ETL which as later abandoned).


    But I would also consider these questions and relative prioritization:  


    What is your organization's plans for moving to other database technologies?  


    Where is your org going with on-prem versus cloud solutions?  How important are PaaS versus IaaS solutions?  


    Where is your current staff's expertise?  


    Prioritize mature over immature tools. 


    How many sources do you have?  What are their technologies and does the integration tool support them?


    Is it just moving data from a single ERP such as Oracle EBS to Olap? When you say Olap what do you mean by that?  Are you talking Oracle Olap product or something else?  That makes a really big difference of course - if your ETL tool doesn't support your source(s) and target(s) then it shouldn't be considered.


    Given the industry's trajectory, I myself would highly prioritize PaaS solutions over others.

    Yeap Jiun Aing - PeerSpot reviewerYeap Jiun Aing
    Real User

    What is the OLAP that you are using? Hosted in Cloud or on-premise? 


    The target DB should have its tool to extract data.

    Efe Dagistanli - PeerSpot reviewerEfe Dagistanli
    User

    Pentaho is a really nice tool if opensource is the only option. 


    Please think about issues such as upgrade and disaster in the future. These operations are very easy in Pentaho.


    I can only suggest one thing for replication and that is Qlik. (ex-Attunity).

    RajneeshShukla - PeerSpot reviewerRajneeshShukla
    Real User

    Hi Karoly, Thanks for your input. community: https://forums.pentaho.com/ is not allowing new registrations for new users. I guess they accept queries from customers only and not from any one. Do you know any other forum, community, SMEs contacts who can help on queries?

    Questions from the Community
    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:I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows.
    Top Answer:The pricing of SSIS is generally considered reasonable in comparison to other data integration tools in the market. In terms of licensing, I find Microsoft's pricing policy generally favorable… more »
    Top Answer:Talend Data integration has a wide library of connectors.
    Top Answer:The tool's technical support needs to be better. It doesn't have a local data center but pushes everything to the cloud. They need to check in with customers to see if they're happy and how well the… more »
    Ranking
    2nd
    out of 94 in Data Integration
    Views
    20,397
    Comparisons
    16,603
    Reviews
    34
    Average Words per Review
    466
    Rating
    7.7
    24th
    Views
    298
    Comparisons
    223
    Reviews
    1
    Average Words per Review
    325
    Rating
    8.0
    Comparisons
    Also Known As
    SQL Server Integration Services
    Talend Cloud Integration, Talend Integration Cloud, Talend Cloud Remote Engine for AWS
    Learn More
    Overview

    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.

    Talend Data Integration is a powerful solution that enables integration with various databases, including Salesforce, SAP, and Oracle, to build business logic and provide reporting. It offers TMC (for creating sub-admins, which are useful for organizations with multiple applications using Talend), profiling, and project creation. The cloud solution also provides automated upgrades, while on-premises solutions require manual upgrades. 

    Talend Cloud Integration has helped organizations by allowing teams to use remote engine concept on AWS, spin up their job servers, process their own data on the cloud, and seamlessly integrate cloud-to-cloud environments.

    Sample Customers
    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
    ACCOR, ADR, L'OREAL, AstraZeneca
    Top Industries
    REVIEWERS
    Financial Services Firm22%
    Government10%
    Healthcare Company8%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company12%
    Government7%
    Healthcare Company7%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Financial Services Firm10%
    Manufacturing Company8%
    Government7%
    Company Size
    REVIEWERS
    Small Business27%
    Midsize Enterprise19%
    Large Enterprise54%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise13%
    Large Enterprise67%
    Buyer's Guide
    SSIS vs. Talend Data integration
    January 2024
    Find out what your peers are saying about SSIS vs. Talend Data integration and other solutions. Updated: January 2024.
    756,468 professionals have used our research since 2012.

    SSIS is ranked 2nd in Data Integration with 33 reviews while Talend Data integration is ranked 24th in Cloud Data Integration with 3 reviews. SSIS is rated 7.6, while Talend Data integration is rated 8.0. The top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". On the other hand, the top reviewer of Talend Data integration writes "Data integration solution that assists with integration with Salesforce, SAP and Oracle". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and AWS Glue, whereas Talend Data integration is most compared with Talend Open Studio, SAP Cloud Platform, Microsoft Azure Logic Apps, AWS Glue and Oracle Data Integrator (ODI). See our SSIS vs. Talend Data integration 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.