Spotfire Ideas Portal
Lot of our application users use google sheet for data manipulation and we need a connector to connect spotfire directly to the google sheet. At present we follow a manual process of downloading the google sheet into csv and then to source into spotfire. if there is a direct connector to connect to google sheet from spotfire then this automates a lot of activity.
Greetings Arun. I also have a need for direct connection to Sheets through Spotfire Cloud Analyst. Until then, I may have discovered a work-around for Spotfire Cloud using Analyst to create the SBDF libraries and assign data types and relations, then using TIBCO Simplr to automatically get new data from Sheets and update the SBDF libraries in our Cloud directory.
1. First, download the Sheet as .csv, and import into Analyst as usual. Transform any columns, establish relationships between tables, then, for *each table* Export As-->Data to Library. You will have as many SBDF libraries as you had .csv files.
2. Using Simplr, setup a Flow:
Sheets connector-->Get Rows from the Google Sheet (not the csv)
TIBCO Spotifre Connector-->Update Rows in Spotfire Library (the SBDF you just created in step 1; verify mappings)
-->Create additional Flows for each table/library.
The SBDF libraries, even though they are separate tables, maintain the relationships setup in Step 1 above. This way, Simplr will get new data from individual Sheets and update your SBDF libraries so visualizations can simply be 'refreshed' rather than importing and combining new data from source every time.
Hope this helps.
Brandon