Denodo vs SSIS vs TIBCO Spotfire comparison

Cancel
You must select at least 2 products to compare!
Denodo Logo
1,577 views|1,005 comparisons
93% willing to recommend
Microsoft Logo
Read 69 SSIS reviews
19,568 views|15,878 comparisons
79% willing to recommend
TIBCO Logo
2,334 views|1,650 comparisons
96% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Denodo, SSIS, and TIBCO Spotfire based on real PeerSpot user reviews.

Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration.
To learn more, read our detailed Cloud Data Integration Report (Updated: March 2024).
768,740 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
"The most valuable features of Denodo are the extraction option for adapters, and there are many things for the views, that are cached. Denodo is not storing the data, it looks first to tune the query, and these things are for the agents.""It can support a number of data sources, and it can pull flat files, from cloud-based databases or from those on-premises. Denodo can pull from any data source and interface with the view. Then, we can publish the view.""Overall, the product works quite well and has a good set of features.""Data mining is one of the valuable features. We're able to connect all of the data sources with the installed driver, so that is a good advantage in Denodo. Being able to join the tables and view them is also valuable.""Denodo makes it easy to export data as a service or data link to other services.""It is a very stable solution.""Denodo is very stable.""It allows a lot of traceability and you can decide what data you want to collect"

More Denodo Pros →

"Like most Microsoft products, SSIS is user-friendly and easy to use.""It is easy to set up the product.""SSIS is easy to use.""It is easy to set up the solution.""It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better.""The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task.""The product's deployment phase is easy.""The performance is good."

More SSIS Pros →

"The most valuable features of TIBCO Spotfire are visualization. It's very nice, clear, and, flexible. You can analyze many data types and the user interface is very good.""It’s stable and straightforward.""The solution is an affordable one.""The product's initial setup phase was simple.""The ability to connect to many different data sources is one of the key features. The other would then be the different ways in which that data can be visualized.""We used it pretty heavily in gathering data, which goes to our VPs. They are able to base their next revenue planning based on this metric. So, it has been invaluable.""From a scalability standpoint, I would say it's pretty fantastic.""The two features that I have found most valuable are its ability to customize the dashboards when it comes to the evaluation. The second feature is its ability to handle a large amount of data, which is also something very unique about it."

More TIBCO Spotfire Pros →

Cons
"The solution is slow when there are many virtualization layers.""User-specific security at the column and row levels needs to be improved. Instead of applying security at every individual level, it would be better if it were at the group or tier level. It will save a lot of time.""The support is not the best and should be improved.""I would like to see a connectivity option with third-party apps, for example, JDBC, and ODBC drivers. Currently, we need to install it separately from the Denodo side and then connect it.""There have been some issues when you are at a table. Currently, Denodo exports data sets for a tabular model. When you are finished modeling your database or data warehouse they export a link to be used in Tableau. They should support other tools like Power BI.""It would be good if the solution provided a much-needed cellular platform.""Denodo currently integrates with ChatGPT, but the ability to manage and utilize them directly within Denodo would be a significant improvement.""There are a couple of areas that can be improved in Denodo. From a stability point of view, sometimes we see issues in the data management functionality. This only happens now and then, however, and usually takes place when we add in our own customization."

More Denodo Cons →

"We would like the solution to be expanded so that it is available for other platforms than just Microsoft.""It's difficult to refactor SSIS. It gets cumbersome to reuse the solution.""SSIS sometimes hangs, and there are some problems with servers going down after they've been patched.""We'd like more integration capabilities.""The solution could improve by having quicker release updates.""I would like to see better integration with Power BI.""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."

More SSIS Cons →

"The design of the UI could be improved.""The number of charts available out of the box in Spotfire can be enhanced.""One aspect where Spotfire could improve is its global recognition, especially in terms of support.""Personalising Spotfire, as a whole, is painful and is something that could be made easier.""The handling and consumption of realtime data could be improved.""I would like to see the visualization library in this solution expanded, so that I can increase what I can offer to our clients.""We would like an easier way to get the product to the cloud. Right now, we have the on-premise version, and we would like to find a way to make it easier to migrate it over to the cloud.""The Text Area feature needs to be more user-friendly. It is a little clunky to use, and it is difficult to consistently format text."

More TIBCO Spotfire Cons →

Pricing and Cost Advice
  • "The licensing should be improved, as the cost per connector is quite expensive."
  • "I don't know the actual cost, but it's tens of thousands of dollars per month."
  • "The licensing charges for this solution are payable annually."
  • "The pricing is pretty good, and I would rate it at four out of five."
  • "Cost wise, on a scale from one to five, with one being the cheapest and five being the most expensive, Denodo would be at three. We get all the features in a bundle."
  • "Depending on the size of the client you want to work with, it can be prohibitively expensive at times."
  • "There is an express edition and a licensed enterprise edition."
  • "Talking with my manager and others, nobody has complained about the pricing so far which is a positive sign."
  • More Denodo 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 →

  • "The ROI is nearly impossible to calculate."
  • "The pricing seems competitive and reasonable. The value delivered by the product far exceeds the cost."
  • "The Tibco sales teams have been very difficult to work with - ignoring requests, misrepresenting level of demand, etc."
  • "The cost is a few hundred dollars per user per year."
  • "The cost of TIBCO Spotfire could improve. It should be less expensive. It's the most expensive visualization tool in our company."
  • "The price-point for this solution is negotiable depending on usage levels."
  • "This product carries a monthly licensing charge, with the amount depending on the features that are to be included. This costs also covers the use of technical support."
  • "In comparison to other solutions such as IBM Cognos, TIBCO Spotfire is more affordable."
  • More TIBCO Spotfire Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    768,740 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: If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit from… more »
    Top Answer: I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I… more »
    Top Answer:Denodo is suitable for pretty much all sectors that deal with Big data Cloud solutions Data governance Logical data… more »
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called… 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… more »
    Top Answer:The solution is an affordable one.
    Top Answer:There were a couple of issues with Spotfire. But in the new releases, they have they have covered them. We had some… more »
    Ranking
    8th
    Views
    1,577
    Comparisons
    1,005
    Reviews
    20
    Average Words per Review
    718
    Rating
    7.8
    2nd
    out of 100 in Data Integration
    Views
    19,568
    Comparisons
    15,878
    Reviews
    35
    Average Words per Review
    471
    Rating
    7.7
    Views
    2,334
    Comparisons
    1,650
    Reviews
    9
    Average Words per Review
    477
    Rating
    8.3
    Comparisons
    Azure Data Factory logo
    Compared 15% of the time.
    AWS Glue logo
    Compared 6% of the time.
    Delphix logo
    Compared 6% of the time.
    Mule Anypoint Platform logo
    Compared 6% of the time.
    Informatica PowerCenter logo
    Compared 21% of the time.
    Talend Open Studio logo
    Compared 11% of the time.
    IBM InfoSphere DataStage logo
    Compared 8% of the time.
    AWS Glue logo
    Compared 6% of the time.
    Also Known As
    SQL Server Integration Services
    Spotfire
    Learn More
    Overview

    Denodo is a leading data integration, management, and delivery platform that uses a logical approach to enable data science, hybrid and multi-cloud data integration, self-service BI, and enterprise data services. Organizations of different sizes across various industries utilize the product to get above the data silos. The solution offers organizations the freedom to migrate data to the cloud, or logically unify data warehouses and data lakes, without affecting business. This can ultimately result in the evolution of data strategies.

    The platform accelerates data provisioning through reduced data replication, provides business users the freedom to select their preferred applications, and enables consistent security and governance across multiple systems. The solution offers one of the leading logical data fabric solutions by initiating data virtualization and eliminating the complexity and exposing the data in business-friendly formats.

    Denodo also offers modern data integration and management for hybrid and multi-cloud environments for Denodo Platform for Cloud. This service can be purchased through the bring-your-own-license (BYOL) option. Users seeking faster deployment can license the product to popular cloud providers, including Amazon AWS, Google Cloud Platform, and Microsoft Azure. The solution integrates, manages, and delivers data in complex environments with high performance, governance, and security. It also offers additional solutions, such as the Denodo Platform for Cloud Modernization, the Denodo Platform for Cloud Data Integration, and the Denodo Platform for Cloud Analytics, which overcome common cloud data challenges.

    Denodo Features

    At the beginning of 2022, version 8.0 of Denodo introduced several new key features of the platform. These include:

    • Scalability: Denodo can scale from departmental or project to enterprise-wide with geographically distributed nodes. It can also handle large transactional loads of users, sources, and transactions as well as analytical loads of data volumes.

    • Query optimizers: This feature offers advanced cost-based and source constraint-based query optimization that includes query rewrite, query delegations, data movements, and join optimization.

    • Intelligent caching: This feature makes full, portal, and time-based caching possible.

    • Fine-grained security model: This Denodo feature makes integration with external systems possible.

    • Monitoring and auditing: Denodo offers enterprise-grade monitoring and auditing, which allows for integration with system management products, including Tivoli, Unicenter, and HP BTO.

    • Development and deployment support: The product offers full lifecycle support for the development and deployment of applications, providing users with all required tools.

    Denodo Benefits

    Denodo offers various benefits for its users through its services. Some of the greatest advantages of using this platform include:

    • The solution accelerates time to market for all types of business data through its services.

    • Denodo provides IT agility, which helps companies respond to business-changing demands in a timely manner.

    • Users can decide how much data replication they want to reduce through Denodo and use the product in full control.

    • The solution meets the industry's security and privacy requirements by providing high-grade protection for users' data.

    • Users can benefit from centralized control of data query executions for complete governance and full security.

    • Denodo offers legacy replacement, multi-cloud deployments, and cloud migrations with minimal disruptions and a fair price.

    • The solution utilizes artificial intelligence (AI) and machine learning (ML) to unlock data potential for customers.

    Reviews from Real Users

    Naresh M., a senior application developer at a financial services firm, appreciates Denodo because it offers quick and simple web services creation.

    Alisson M., a senior BigData DevOps engineer at Schaeffler, says that Denodo is great for queries and scouting data.

    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.

    TIBCO Spotfire is a versatile data analytics platform that can handle large datasets and be deployed on-premise or in the cloud. Its dynamic reporting, easy creation of dynamic dashboards, and highly customizable tool make it a valuable asset for process data analysis, industrial performance dashboards, problem root cause analysis, business intelligence, and real-time analytics for IoT devices in the energy sector. 

    The solution also offers data science functions, map visuals, R and Python integration, and the ability to write HTML and JavaScript text areas. Spotfire has helped organizations deliver projects more efficiently and cost-effectively, allowing for faster data analysis.

    Sample Customers
    Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta
    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
    Allergan, ASSS de Montreal, Avantium, Blue River, Bank of Montreal, Citibank, FrieslandCampina, Hellmann Logistics, Merck, Novartis
    Top Industries
    REVIEWERS
    Financial Services Firm25%
    Manufacturing Company19%
    Computer Software Company13%
    Government6%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Manufacturing Company10%
    Computer Software Company9%
    Energy/Utilities Company8%
    REVIEWERS
    Financial Services Firm23%
    Government8%
    Retailer8%
    Insurance Company8%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company12%
    Government7%
    Healthcare Company6%
    REVIEWERS
    Energy/Utilities Company22%
    Financial Services Firm17%
    Computer Software Company11%
    Manufacturing Company11%
    VISITORS READING REVIEWS
    Manufacturing Company15%
    Energy/Utilities Company12%
    Financial Services Firm11%
    Computer Software Company10%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise13%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise9%
    Large Enterprise77%
    REVIEWERS
    Small Business27%
    Midsize Enterprise18%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    REVIEWERS
    Small Business27%
    Midsize Enterprise13%
    Large Enterprise61%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise9%
    Large Enterprise78%
    Buyer's Guide
    Cloud Data Integration
    March 2024
    Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration. Updated: March 2024.
    768,740 professionals have used our research since 2012.