如何在 Tableau Desktop 中以特定时间间隔自动刷新提取的数据源 [英] How to refresh the extracted datasource automatically in Tableau Desktop at specific intervals

问题描述

我使用 Tableau Desktop 8.0 通过从 MySQL 数据库中提取数据来创建可视化(.twbx 文件).但是这个数据库每周更新一次.也就是说，在每周开始时，数据库中的数据都会发生变化.那么我是否可以安排在特定时间间隔(即在我的情况下每周一次)自动刷新提取的数据源的任务，以便在每周开始时根据数据库中的新更新刷新数据源报告应相应反映结果.这可以通过 Tableau Desktop 自动安排吗?我知道它可以在 Tableau Server 上轻松完成这一事实.但是我买不起服务器，所以我想在 Tableau Desktop 版本中得到同样的答案.

I'm using Tableau Desktop 8.0 to create a visualization (.twbx file) by extracting the data from MySQL database. But this database is updated on weekly basis. That is, at the beginning of every week the data in the database changes. So is it possible for me to schedule a task of refreshing the extracted datasource automatically at specific interval of time(i.e. on weekly basis in my case) so that, at beginning of every week the datasource should be refreshed according to the new updates in database and the report should reflect results accordingly. Can this be scheduled through Tableau Desktop automatically? The very fact that it can easily be done on Tableau Server is known to me. But I cannot afford for a Server so trying to get an answer if the same is possible with Tableau Desktop edition.

推荐答案

有完全相同的问题，只是我必须每小时更新我的​​数据库 :)

Have exactly the same problem, only I have to update hourly my database :)

最终的解决方案是针对 Tableau Server.虽然我没有它，但我没有找到任何合理"的解决方案.可以使用提取数据 API(需要付出很多努力)来更新(替换).tde 文件，但是您将无法自动生成 .twbx(这可能是您想要做的.这就是我需要的最少).

The final solution is going for Tableau Server. While I don't have it, I didn't find any "reasonable" solution for the problem. Extract data API can be used (with lots of effort) to update (replace) .tde files, but yet you'll not be able to generate a .twbx automatically (which is probably what you want to do. It's what I need at least).

于是我去了一个非优雅的解决方案，使用win32 api制作一个脚本来给出键盘命令.基本上我打开 .twb 文件(如果还没有打开)，把它放在前面，给出 alt + d + x 命令(刷新所有提取物)，按 Enter，等待一段时间(以秒为单位，不知道如何发现过程是否完成)，再次按回车，alt + f + k(导出打包的工作簿)，一些 shift+tabs 进入文件夹提示，输入路径，几个选项卡进入名称提示，输入名称，再次输入，瞧

So I went to a non-elegant solution, used win32 api to make a script to give keyboard commands. Basically I open the .twb file (if not already open), bring it to front, give an alt + d + x command (refresh all extracts), hit enter, wait for some time (in seconds, didn't figure out how to discover if the process is done), hit enter again, alt + f + k (export packaged workbook), some shift+tabs to go to folder prompt, enter the path, a few tabs to get to name prompt, enter the name, enter again, voila

这不仅是一个不优雅的解决方案，而且也是一个非常不稳定的解决方案.我在虚拟机上运行 Tableau Desktop，我的脚本只有在我实际登录到计算机时才能运行(否则它不会运行键盘命令).如果您在实际机器上安装了 Tableau，那么您需要确保在运行脚本时没有任何东西会干扰您的脚本.

It's not only a non-elegant solution, but a very unstable one too. I run Tableau Desktop on a virtual machine, and my script will only work if I'm actually logged in to the machine (otherwise it will not run the keyboard commands). If you have Tableau on your actual machine, well, you need to make sure there's nothing there to mess with your script when you run it.

不是很好的解决方案，但我拥有的最好的 :(

Not good solution, but the best I have :(

这篇关于如何在 Tableau Desktop 中以特定时间间隔自动刷新提取的数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！