Try our new research platform with insights from 80,000+ expert users

Denodo vs SSIS vs TIBCO Spotfire comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
8.0
Denodo enhances ROI by speeding processes, improving strategic accuracy, reducing churn, and boosting customer loyalty within six months.
Sentiment score
7.3
SSIS provides cost-effective data management efficiency, delivering ROI without extra costs apart from the SQL Server license.
Sentiment score
6.6
TIBCO Spotfire boosts productivity through reduced maintenance and enhanced analysis, justifying its cost with aligned organizational adoption.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
 

Customer Service

Sentiment score
7.2
Denodo's service and support are praised for expertise and promptness, but initial support and training need improvement.
Sentiment score
6.0
Many users prefer online resources over Microsoft's good but occasionally slow and expensive technical support for critical issues.
Sentiment score
7.1
TIBCO Spotfire customer service is praised for responsiveness and knowledge, with ratings ranging from 7 to 9 out of 10.
Denodo's customer support team is very competent and responsive.
The documentation is very thorough.
They are proactive in conducting webinars and connecting with customers.
TIBCO's support, especially for integration products, is swift.
 

Scalability Issues

Sentiment score
7.6
Denodo offers scalable architecture with successful integration and deployment, overcoming financial and query delegation challenges to ensure performance.
Sentiment score
6.8
SSIS is moderately scalable, better for batch processing, with varied performance depending on infrastructure and implementation challenges.
Sentiment score
7.3
TIBCO Spotfire offers strong scalability, supporting large datasets and real-time processing, though setup and updates may pose challenges.
While the solution scales well on a single machine, I have doubts about its scalability when deployed as part of a Java component cluster.
Its complexity in configuring and the requirement to install different connectors for different sources affects its scalability.
 

Stability Issues

Sentiment score
7.1
Denodo is stable, handles stress well, but faces occasional challenges with complex queries and external dependencies.
Sentiment score
7.4
SSIS is a reliable, mature tool with minor performance concerns, praised for stability in diverse projects despite occasional issues.
Sentiment score
6.6
TIBCO Spotfire is reliable but may face stability issues with complex tasks, dataset size, and improper real-time data integration.
I would rate it nine out of ten because it is very reliable, always performing as expected.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
It processes large volumes of data quickly.
There are no significant stability issues as long as the product's capabilities are understood and not overly pushed.
 

Room For Improvement

Denodo requires improvements in data catalog, integration, modernization, connectivity, security, performance, visualization, documentation, and user-friendliness.
SSIS requires enhancements in error logging, real-time processing, and scalability while depending on external tools increases costs.
TIBCO Spotfire struggles with customization, user-friendliness, data integration, and requires enhancements in training, support, and mobile functionality.
The system has dependencies on other environments, like JVM, which can affect its performance.
Ensuring data caching is up to date is critical.
Denodo needs better communication on how the product can be deployed for specific solutions.
SSIS has a difficult learning curve when dealing with complex transformations.
TIBCO Spotfire and ClickView need improvement in scheduling, which is critical yet lacking in quality.
 

Setup Cost

Denodo's pricing is expensive but fair for enterprises, with various editions and licensing often based on CPU or core.
SSIS is cost-effective for enterprises, bundled with SQL Server, but add-ons can increase costs; overall valued for integration.
TIBCO Spotfire's pricing is high yet competitive, offering value with comprehensive features despite challenges in transparency and negotiation.
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
TIBCO Spotfire's pricing is high, particularly in traditional markets like Turkey, impacting market penetration.
 

Valuable Features

Denodo offers efficient data virtualization with robust integration, optimized queries, and secure access, enhancing analytics and data management.
SSIS offers user-friendly, cost-effective ETL solutions with C# scripting, cloud deployment, and extensive support, enhancing data integration and automation.
TIBCO Spotfire excels in interactive visualizations, real-time analytics, and seamless integration, praised for handling large datasets efficiently.
The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
Its catalog is useful for data governance and helps document information for databases and fields.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
TIBCO Spotfire integrates with R and Python, offering a differentiator from the competition.
 

Featured Reviews

Vishal_Goyal - PeerSpot reviewer
The data catalog feature helps define data structures without storing data
The data catalog feature is valuable as it helps define data structures without storing data. Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy. It supports API usage to call and present data in JSON or Tableau format without visualization capabilities.
BobAmy - PeerSpot reviewer
Robust and does a good job of handling overload conditions
We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.
Mohsin Pathan - PeerSpot reviewer
Flexible, offers a single pane of glass, and is highly customizable
There's one area I see that specifically needs improvement. That is when you do the data loading. It is slow. For historical data, when you talk about gigabytes of data, terabytes of data, then it becomes prolonged. Loading could be improved. That's one part. That is actually there with every tool. I would not say that this is a specific problem with Spotfire. However, it is a problem with all the BI tools. That is one area which can be improved. When you are doing analytics, you see that the value has to come perfect. There was a missing feature of alerting out of the box within Spotfire. However, they have released this in version 12.
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
851,042 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
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…
 

Top Industries

By visitors reading reviews
Financial Services Firm
22%
Computer Software Company
9%
Manufacturing Company
9%
Government
7%
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Manufacturing Company
6%
Manufacturing Company
18%
Financial Services Firm
14%
Computer Software Company
10%
Energy/Utilities Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Does Denodo provide useful data virtualization education? Is it useful to attend their training?
If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit fro...
In experience, what might Denodo be lacking or need improvement on?
I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I ...
Which industries can benefit from Denodo the most?
Denodo is suitable for pretty much all sectors that deal with: Big data Cloud solutions Data governance Logical data...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called ...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
What do you like most about TIBCO Spotfire?
TIBCO Spotfire is easy to use. We initiated Spotfire as POC, with support from a tech team based in South Africa. Whi...
What is your experience regarding pricing and costs for TIBCO Spotfire?
TIBCO Spotfire's pricing is high, particularly in traditional markets like Turkey, impacting market penetration. Ther...
What needs improvement with TIBCO Spotfire?
ClickView ( /products/clickview-reviews ) offered more visually appealing visualizations. TIBCO Spotfire and ClickVie...
 

Comparisons

 

Also Known As

No data available
SQL Server Integration Services
Spotfire
 

Overview

 

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
Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Salesforce and others in Cloud Data Integration. Updated: May 2025.
851,042 professionals have used our research since 2012.