Spotfire Ideas Portal
Spotfire webplayer or server should implement google sheets as a datasource.
1
Future Consideration
0
Future Consideration
Here is a video tutorial detailing how to use Google Sheets with Spotfire: https://youtu.be/aGvYOQnxyA4
I've been having great success with the custom connector for google sheets available on the community. The link has changed as per the "new" community website: https://community.tibco.com/s/exchange/aCv4z0000008Od7CAE/custom-connector-for-tibco-spotfire-to-read-data-from-google-sheets
There is now a custom connector for Google sheets, CSV and Excel files on Google Drive or Google Shared Drives available on TIBCO Exchange:
https://community.tibco.com/modules/custom-connector-tibco-spotfirer-read-data-google-sheets
The cdata driver/connector is bunk. We tried it on several occasions, received assistance from the manufacturer, and still it didn't work at all. Nice attempt at punting what should be an an easy solution.
Hey Sadaq / Neil,
One way of addressing this out of the box is with the recently released native Google BigQuery connectivity:
Spotfire -> BigQuery -> Google sheets
The BigQuery -> Google Sheets real-time connection is easy to set up: https://cloud.google.com/blog/products/gcp/how-to-crunch-your-business-data-from-sheets-in-bigquery
.. and you���re in business ����
You can access Google Sheets in Spotfire using this 3rd party driver. It's just not a native connector.
https://www.cdata.com/drivers/gsheets/odbc/
Any tabular data located on any cloudish place (dropbox, Google, iCloud...).
HTML table located somewhere in a URL could also be fun.