Use of Spotfire to make quick user interfaces to see bug amounts of data
April 27, 2019

Use of Spotfire to make quick user interfaces to see bug amounts of data

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Software Version

TIBCO Cloud Spotfire Enterprise

Overall Satisfaction with Spotfire

Spotfire is actually used by one of Radix's clients and we are just developers. Since last year, an application for report generation was developed by Radix with an interface for the user to see the data from OSISfot PI System and mark events, generating a PDF at the end of the process. The application also is integrated with a SQL Database to save any progress by the users.
  • Processing big amounts of data quickly.
  • Intuitive platform to design user interfaces for databases.
  • Calculates new columns and transforms the data quickly.
  • Has many possibilities of development using IronPython.
  • PI Integration has many limitations.
  • PI Integration is also very slow to pull data (it gets very slow with more than 13M points).
  • PDF Generation is also very limited, just prints the screen.
  • We learned a new intuitive and useful platform to use in another project.
  • The client is happy with the application, even with some performance issues.
  • The company got close to the clients because it was the first project.
We didn't integrate with other Spotfire products.
I've never used a product like Spofire, but we chose Spotfire for 2 basic reasons: 1. The client already has Spotfire and was using the platform a lot. 2. We needed an interface to mark data and generate a PDF, which Spotfire can do well. But at the end of the project, our solution had too many business rules and complicated functionalities, which resulted in a very slow application (but functional). So, if you need to develop an application using Spotfire and it has complex functionalities (interactions with the user, write on SQL database, integration with PI), I recommend you to use the C# library sometimes, instead of IronPython.
Spotfire is highly recommended if you want to provide a simple user interface to a huge database, especially SQL and it's even better if you want just to read data (to write data it needs some IronPython coding, but a developer should handle it well) and run some calculations over (Spotfire does this VERY fast!). Also, the platform is very intuitive, so any person can develop solutions on it and learn very fast if some complicated operation is needed. Also, it is very intuitive for developers, but don't get too many expectations, the platform doesn't provide a good interface for coding or debugging. It also can have many performance issues (be careful with your code). I don't recommend Spotfire if the solution you want needs too much IronPython coding to implement business rules.

Spotfire Feature Ratings

Customizable dashboards
10
Report Formatting Templates
6
Drill-down analysis
10
Formatting capabilities
5
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
7
Publish to Web
7
Publish to PDF
4
Report Delivery Scheduling
9
Pre-built visualization formats (heatmaps, scatter plots etc.)
10
Location Analytics / Geographic Visualization
10
Predictive Analytics
10
Multi-User Support (named login)
10
Role-Based Security Model
10
Multiple Access Permission Levels (Create, Read, Delete)
10
Responsive Design for Web Access
Not Rated
Mobile Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
Not Rated
REST API
10
Javascript API
8
iFrames
10
Java API
10
Themeable User Interface (UI)
10
Customizable Platform (Open Source)
10

Spotfire Training

  • Self-taught
I learned by my mistakes. I begun knowing nothing (and also my team), but we did a lot of wrong solutions before we came up with the final project. We had a lot of delay in the project (most of this due to inexperience when deciding the schedule) and had a lot of headaches to learn how to use the platform, but it was worth it ate the end of the day.