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."It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"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."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"It is easy to set up. The deployment is also very quick."
"The solution is stable."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"It's already very user-friendly and has a good dashboard."
"The most valuable feature is the map visuals that help us connect to the geo-specialized data which is more advanced than other solutions."
"The solution is an affordable one."
"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."
"Data discovery is very simple."
"This solution allows us to integrate data from across all client departments, for effective reporting via a single dashboard."
"Live Query data on demand, R and Python integration, and the ability to write HTML and JavaScript text areas are all valuable features."
"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 allows users to quickly analyze data from a variety of sources and visualize it with powerful, interactive graphs, and charts."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"Improvement as per customer requirements."
"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."
"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."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"Tuning using this solution requires extensive expertise to improve performance."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"The data compression has room for improvement."
"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."
"The solution might be generic."
"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."
"I would like more easy-to-implement analytical algorithms. At the moment they include things like forecasts and regressions. They need to add a lot more of these types of things to the product because not everyone is a data scientist."
"The way TIBCO Spotfire is designed, in my opinion, is the reason why it lags a bit, especially compared to other BI tools like Qlik."
"We encountered difficulties connecting the special data sets, as the post data set did not contain any shared columns, making it difficult to establish a connection between the data sets."
"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."
SSIS is ranked 2nd in Data Integration with 69 reviews while TIBCO Spotfire is ranked 10th in BI (Business Intelligence) Tools with 67 reviews. SSIS is rated 7.6, while TIBCO Spotfire is rated 8.4. 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 "Empowers us to extract insights and provide valuable business analytics to support decision-making within our organization". 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, QlikView, Qlik Sense and TIBCO Jaspersoft. 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.