This still does work on Tableau 8.2 however, the normal driver will not work. You have to email RSSBus via their support forum and they will respond to you with an update that will allow it to work with 8.2. They responded in less than 24 hours.
Responding to my own post, I just had to setup the data connection as System DSN so that it is valid for all users, rather than an individual User DSN. Now all the worksheets and dashboard are available through Tableau Server as well.
That is terrific news. Can you do a screenshot/walkthrough: maybe anonymous, for the server set up (so that others can benefit? Did you have to push a copy of the System DSN to server?
- Open the ODBC Data Source Administrator in Windows.
- Click on the System DSN tab at the top (you need admin rights to do this).
- Click Add.. and setup using the same info as originally posted
- Select "RSSBus Driver for Google Spreadsheets"
- Provide a "Data Source Name"
- Enter the Authentication details
- Connect to the Other Databases (ODBC) option in Tableau
- "Connect Using" the name of the Data Source in the DSN dropdown.
This should connect you to the data source. Any data connections you had connected via the user DSN will need to be updated.
Just for clarity - does a copy of the System DSN need to be placed on the server? Thanks!
I believe that would just depend on the setup being run. In my case, Desktop and Server are running off my same machine, so I did not have to install anything anywhere besides that machine.
Thanks for your continued testing of RSSBus for Googlesheets. I have just purchased the desktop license and was able to connect to a spreadsheet live. However when I went to use one of the fields as a filter I received an error.
> Malformed SQL Statement: Expected identifier but found 3 with value
> 1 instead.
> Statement:SELECT `NYP2_Pacing_Output`.`Perf` AS `none_Perf_nk`
> FROM `GoogleSheets`.`NYP2_Pacing_Output` `NYP2_Pacing_Output`
> GROUP BY `NYP2_Pacing_Output`.`Perf`
> ORDER BY 1 ASC
The error went away when I reverted to an extract rather than a live connection. Have you encountered this? Any thoughts on how to filter the live connection?
I have Tableau desktop and server on the same machine also. Does that mean that I only need the RSSBus desktop license to make this work for all users accessing Tableau server (plus the System DSN config you described)? Or do you also have the RSSBus server product installed?
I was curious if you have been able to get this to work Tableau Desktop Pro 8.3? I would appear to working for me. Should I ask for a new version of the driver from RSSBus? Definitely looking forward to this becoming a standard feature.
You don't really need a special driver for this. If you are in a Google Spreadsheet for example, you can see the .csv url in Firebug when you select Download As.... It will look something like this:
Just use that url in Excel under Data; From Text (ie, where you can import csv files). Then you make the report using Excel. The report will update automatically in Excel if you set the Data; Properties values to update when opening the workbook. You also need to put in the full URL in the Properties name. FYI
I've just tried to do what you've suggested here, but cannot seem to find success.
Could you give a more detailed outline with how to accomplish this through your method?
3 of 3 people found this helpful
I constructed a very easy and detailed walk-through of the process. I hope this helps, as I was very frustrated as well (at first). See attached.
In summary, the steps are to use an ODBC driver to connect to the Google sheet. Also, you will need a google OAuth client and secret code to allow them to connect. I am not a developer, so the steps have very simple language that anyone can understand and follow.