-
1. Re: Automate the Process of extracting data from viz to Database
Manasa k Jul 6, 2016 12:47 PM (in response to Manasa k)i was checking few tableau blogs and came across some information related to this.Tableau experts let me know if this makes sense to give a try.
1)login to tableau server from my local machine using
tabcmd login -s http://<host>:<port> -u <username> -p <password>
2) Below export exports the data used in the viz to a csv and places it in local directory
tabcmd export "/views/Wow/SummaryReports" -f "progressReport.csv"
3)By using some scripting i can read data from csv and insert into my target database.
let me know if anyone of you tried this and did it work?
-
2. Re: Automate the Process of extracting data from viz to Database
Manasa k Jul 13, 2016 8:53 AM (in response to Manasa k)This worked.
We have the feasibility to pass parameter as filters to run view and export data for that particular filter.
proposed this to my client,awaiting a positive reply
-
3. Re: Automate the Process of extracting data from viz to Database
Tom WJul 13, 2016 11:35 AM (in response to Manasa k)
Out of curiosity, what's the value in extracting the data from a Tableau workbook? Tableau has been connected to a 'source' in the first place, why not extract into the new system directly from that source?