We performed a comparison between SSIS and TIBCO Spotfire based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."SSIS integrates well with SQL servers and Microsoft products."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"SSIS' most valuable feature is its reporting services."
"The solution is easy to use and developer friendly."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The scalability of SSIS is good."
"The out-of-the-box features are simple and easy to use across the board."
"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."
"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."
"The solution is an affordable one."
"Data discovery is very simple."
"One of the main features is integrated statistical analysis."
"I appreciate Spotfire's range of visualization options, advanced analytics features, and seamless integration with other TIBCO products."
"Live Query data on demand, R and Python integration, and the ability to write HTML and JavaScript text areas are all valuable features."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Video training would be a helpful addition."
"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."
"The solution could improve on integrating with other types of data sources."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"I would like to see more features in terms of the integration with Azure Data Factory."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"The initial setup can be difficult."
"Print capability and trigger-based events."
"I would like to see the visualization library in this solution expanded, so that I can increase what I can offer to our clients."
"When you do the data loading, it is slow."
"Compared to competitors, the UI is quite dated."
"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."
"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."
"One aspect where Spotfire could improve is its global recognition, especially in terms of support."
SSIS is ranked 2nd in Data Integration with 69 reviews while TIBCO Spotfire is ranked 13th in BI (Business Intelligence) Tools with 66 reviews. SSIS is rated 7.6, while TIBCO Spotfire is rated 8.2. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of TIBCO Spotfire writes "A robust BI tool, with good dashboard features and adverse event tracking". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas TIBCO Spotfire is most compared with Tableau, Microsoft Power BI, Qlik Sense, QlikView and Amazon QuickSight. See our SSIS vs. TIBCO Spotfire report.
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.