tableadapter - Tableau : Update external file in published twbx (Package Workbook) -
we have packaged workbook going publish on client machines. part of package have 1 external file needs updated (not refresh) new data (file format remain same) quarterly.
and problem comes here team dont want go maintenance mode. want user update external file quarterly. possible user access file in published data source in server , upload new file when ever available ? not aware of client file system not going option of placing in tableau repository. , dont want upload file part of db (has external file).
please suggest
thanks
you have multiple options. in cases described, should separate workbook data , publish workbook, not packaged workbook (i.e. don't check include files button)
briefly, can put file on share drive must accessible tableau server using run user account via same path used publish. kind of brittle , can have security issues if not careful.
you create extract , publish data separately tableau data source, , use tableau data extract command utility refresh , publish updated extract when desired. http://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#extracting_tde.html%3ftocpath%3dset%2520up%2520data%2520sources%7cextract%2520data%7c_____6
that work on windows only.
or use tableau data extract api (or sdk now) generate extract script , publish using rest api. approach work on system.
or use database. database.
Comments
Post a Comment