Coming October 25: PeerSpot Awards will be announced! Learn more

SSIS vs TIBCO Spotfire comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
Read 23 SSIS reviews
26,746 views|20,727 comparisons
TIBCO Logo
6,800 views|4,603 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between SSIS and TIBCO Spotfire 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. TIBCO Spotfire report (Updated: August 2022).
635,987 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 performance is good.""The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product.""Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools.""The technical support is very good.""The UI is very user-friendly.""It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world.""SSIS' best feature is SFTP connectivity.""The initial setup was easy."

More SSIS Pros →

"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.""Spotfire is excellent for scientific applications, especially because of its integration with RNG.""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 scalable.""It’s stable and straightforward.""From a scalability standpoint, I would say it's pretty fantastic.""The ability to create a real-time data mark, using just one piece of software, is the best feature of this product.""This solution allows us to integrate data from across all client departments, for effective reporting via a single dashboard."

More TIBCO Spotfire Pros →

Cons
"The solution could improve by having quicker release updates.""I would like to see better integration with Power BI.""It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well.""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.""It's a legacy tool, that is nearing the end of its useful life.""Options for scaling could be improved.""You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price.""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."

More SSIS Cons →

"The initial setup can be difficult.""When it comes to data manipulation, there are features which are good, but one of the features which has really been missing in Spotfire is an offline ability for data manipulation.""I would like to see the visualization library in this solution expanded, so that I can increase what I can offer to our clients.""The design of the UI could be improved.""When you do the data loading, it is slow.""The handling and consumption of realtime data could be improved.""The initial setup of TIBCO Spotfire is in the middle range of difficulty. The initial setup of Power BI is easier.""We would like to see some improvement in the default properties of the solution, so that there is less need for us to spend our time coding."

More TIBCO Spotfire Cons →

Pricing and Cost Advice
  • "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."
  • "SSIS is a cheaper option compared to the cost of other ETL tools."
  • "Our license with SSIS is annual."
  • "t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."
  • More SSIS Pricing and Cost Advice →

  • "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."
  • 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.
    635,987 professionals have used our research since 2012.
    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:What is the OLAP that you are using? Hosted in Cloud or on-premise?  The target DB should have its tool to extract data.
    Top Answer:Like most Microsoft products, SSIS is user-friendly and easy to use.
    Top Answer:The ability to create a real-time data mark, using just one piece of software, is the best feature of this product.
    Top Answer:The price-point for this solution is negotiable depending on usage levels.
    Top Answer:I would like to see the visualization library in this solution expanded, so that I can increase what I can offer to our clients. I would also like an option for dashboard creation on mobile and tablet… more »
    Ranking
    3rd
    Views
    26,746
    Comparisons
    20,727
    Reviews
    21
    Average Words per Review
    475
    Rating
    7.8
    Views
    6,800
    Comparisons
    4,603
    Reviews
    9
    Average Words per Review
    799
    Rating
    8.4
    Comparisons
    Also Known As
    SQL Server Integration Services
    Spotfire
    Learn More
    Overview

    SQL Server Integration Services (SSIS) is a Microsoft platform designed to build enterprise-level data integration and data transformation solutions. Users now have the ability to solve intricate business queries by downloading and copying files, cleansing and mining data, loading data warehouses, and managing SQL Server objects and data through Integration Services. SSIS is a component of the Microsoft SQL Server data software used for many data migration tasks.

    SSIS loads data into one or more destinations by extracting and transforming data from a wide variety of sources such as XML data files, flat files, and relational data sources.

    Integration Services include:

    • An SSIS catalog database to manage, store, and run packages.
    • An ample set of built-in transformations and tasks.
    • Graphical tools for building packages.

    Create packages programmatically and code custom tasks through programming the extensive Integration Services. With graphical Integration Services, you can create solutions without writing any code.

    Benefits of SSIS

    There are many benefits of SSIS, such as:

    • Solve complex business problems - encrypt files with SSIS and send them to various network locations.

    • Migration of DTS packages to SSIS - users can migrate DTS packages to SSIS while choosing to run DTS packages using DTS runtime or incorporate DTS packages into SSIS.

    • Development of ETL processes - Microsoft’s SSIS packages provide the ability to extract, transform, and load data into data warehouses. This service takes data from various sources, like CSV files, XML files, flat files, and relational data sources and transforms and loads them to their destinations.

    • Data migration from other databases - with Integrations Services, users can transform data to make sure it complies with the rules of the database they are migrating to.

    • Managing and automating SQL server objects - SSIS packages can manage and automate SQL server objects which will help save you time and resources.

    Reviews from Real Users

    The SSIS platform stands out among its competitors for a variety of reasons. Two major ones are its debugging capabilities during data flow execution and its easy connectivity with other Microsoft tools.

    Muhammad J., a senior manager software developer at Techlogix, notes, "The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."

    Ismail L., a data engineer at a tech service company, writes, "The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."

    TIBCO Spotfire is your secret weapon. You can create beautiful, interactive visualizations that will help you find the critical insights hiding in your data - fast. Spotfire gives you the tools to quickly and easily examine, organize, analyze and comprehend your data to see connections, patterns, and opportunities.

    Offer
    Learn more about SSIS
    Learn more about TIBCO Spotfire
    Sample Customers
    PKP Energetyka, UniCredit Bank, Mostar, waldwasser, Ashok leyland, Florida Atlantic University, Stadt Frankfurt am Main
    Allergan, ASSS de Montreal, Avantium, Blue River, Bank of Montreal, Citibank, FrieslandCampina, Hellmann Logistics, Merck, Novartis
    Top Industries
    REVIEWERS
    Financial Services Firm21%
    Healthcare Company8%
    Manufacturing Company8%
    Transportation Company8%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Financial Services Firm15%
    Comms Service Provider11%
    Insurance Company7%
    REVIEWERS
    Energy/Utilities Company26%
    Financial Services Firm16%
    Pharma/Biotech Company10%
    Manufacturing Company10%
    VISITORS READING REVIEWS
    Computer Software Company15%
    Energy/Utilities Company15%
    Pharma/Biotech Company9%
    Manufacturing Company8%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise21%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise13%
    Large Enterprise70%
    REVIEWERS
    Small Business26%
    Midsize Enterprise14%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise9%
    Large Enterprise77%
    Buyer's Guide
    SSIS vs. TIBCO Spotfire
    August 2022
    Find out what your peers are saying about SSIS vs. TIBCO Spotfire and other solutions. Updated: August 2022.
    635,987 professionals have used our research since 2012.

    SSIS is ranked 3rd in Data Integration Tools with 23 reviews while TIBCO Spotfire is ranked 8th in BI (Business Intelligence) Tools with 9 reviews. SSIS is rated 7.8, while TIBCO Spotfire is rated 8.4. The top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". On the other hand, the top reviewer of TIBCO Spotfire writes "Excellent for scientific applications with a good ability to customize". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and AWS Glue, whereas TIBCO Spotfire is most compared with Microsoft BI, Tableau, QlikView, Qlik Sense and Alteryx. See our SSIS vs. TIBCO Spotfire 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.