1

We currently have a database that can only be accessed via a Tableau front end.

Is it possible with R (or any other means) to be able to extract the underlying data table into csv or txt? I don't really care what it ends up as so long as it is structured and can read into a data frame.

I can see from some looking around that I can use R scripting within Tableau but I cannot see a method to go the other way and pull data out of the Tableau Worksheet.

Any help appreciated!

Andy Cullen
  • 19
  • 2
  • 1
    If its not too much you can export the data from tableau to an excel file. There's also an extraction API that I would suggest you take a look at here https://www.tableau.com/learn/tutorials/on-demand/extract-api-introduction – Dinesh.hmn Nov 06 '17 at 16:48
  • 1
    http://onlinehelp.tableau.com/current/pro/desktop/en-us/save_export_data.html – tyvich Nov 06 '17 at 19:03
  • If the database can be accessed from Tableau than what is the technical or security controls barrier preventing access from R? Time wld be better spent filing tickets to remove those barriers than hack a closed, expensive, designed-for-lock-in dragon-droppings platform like Tableau. – hrbrmstr Nov 06 '17 at 19:18
  • Are you using Server or Desktop? – Sam M Nov 07 '17 at 04:08

0 Answers0