I am curious - Do you use just Tableau Desktop or do you have a combination of Desktop and Server or Desktop and Online?
We are working on a solution but trying to make sure it fits your platform.
Thanks for the update...
After experimenting with publishing a data source to Tableau Server (we are running V. 9.2), it became apparent to me that the data source on the server points to a "live" file and not an extract. Our challenge now becomes creating an automated process to refresh the "live" file, which will in turn get used by Tableau to update the extract. (Or, at least, this is how I understand the process.) For all data that originates in MS SQL Server (or any other RDBMS), we will be able to eliminate Alteryx from the picture. Unfortunately, not all of our data resides in MS SQL Server, but, rather, in MS Excel. Until we eliminate MS Excel as a data source, we will need to use Alteryx or a similar tool for preprocessing.
Matthew P. Seltzer
P.S. Our environment consists of 64-bit Tableau Desktop (V. 9.2) and 64-bit Tableau Server (V. 9.2).
It sounds like you have a good understanding of published data sources and how the extract and extract refresh process works with Tableau Desktop and Server. As you have identified, the next step will be your internal process of how you update your MS Excel data. Once you get a system that automates the update process for the MS Excel data, then you can use the scripting method and tabcmd commands (refreshextracts: http://onlinehelp.tableau.com/current/server/en-us/tabcmd_cmd.htm#id4cdb3410-1c41-4dad-b1d2-306542ac9b32 ) or use Tableau’s solution for Refreshing Extracts.
You should also check out the section in our help files on the Tableau Data Extract Command-Line Utility this may be a solution.
Please let us know how we can continue to help.
Any luck yet?
I'm using SSIS to ALTER VIEW and calling tabonlinsyncclient.exe to incrementally refresh and append it to tableau online. I've been able to append hundreds of millions of rows this way.
But sometimes there are errors, so I'm looking for alternative methods of automating local TDE updates.
1) I've got a big tde on tableau online
2) I can manually create new tde's on my c: drive from my tds (connected to my sqlsvr view)
3) Then I can easily use tabcmd to append them to my big tableau onlne extract.
(Note: my source data is not a csv, and my tds contains lots of curation I've performed on it, so my tde updates must come from my tds structure.)
The question is for step 2: how do I use my tds to generate the local c: drive tde without manually doing so with the tableau desktop UI ? In other words, how do I automate the generation or full-refresh of a local tde file on my c: or unc path ?
btw - Kosta has a similar question here: https://community.tableau.com/message/473655#473655