使用脚本将密钥发送到Tableau [英] Sending keys to Tableau with a script

问题描述

我实际上是在使用Tableau Software Desktop，并将工作簿保存到.twbx(Tableau数据提取+ Tableau工作簿)，我需要每4小时刷新一次Tableau数据提取(不是视图).我发现有很多方法可以使用Tableau Online进行此操作，而没有任何方法可以使用Tableau Desktop.我在想的是将Power Shell脚本中的密钥发送到Tableau，以自动刷新.TDE(已连接到psql数据库).

I am actually using Tableau Software Desktop and saving my workbooks to .twbx (tableau data extract + tableau workbooks) and I need to refresh my tableau data extract ( not the view ) every 4 hours. I found out that there are plenty of ways to do it with Tableau online but none with tableau desktop. What I am thinking of, would be to send the keys in a power shell script to Tableau to automatically refresh the .TDE ( which is connected to a psql database ).

感谢您的帮助.

推荐答案

使用tableau命令行工具根据需要刷新或附加到提取物中，或从脚本中调用 http://onlinehelp.tableau.com/current/pro/online/mac/en-us/help.html#extracting_TDE.html

Use the tableau command line tool to refresh or append to an extract as often as desired, or call from a script http://onlinehelp.tableau.com/current/pro/online/mac/en-us/help.html#extracting_TDE.html

或者，如有必要，使用Tableau Data Extract API编写自己的提取实用程序

Or if necessary, write your own extract utility using the Tableau Data Extract API

您可能希望将提取数据源与引用它的工作簿分开保存.那就是将解压缩文件保存为.tde文件，然后将工作簿保存为.twb文件(而不是.twbx)，除非您出于其他原因打包工作簿.这样，您可以刷新或替换摘录，而无需接触引用它的工作簿.

You probably will want to save your extract data source separate from workbooks that reference it. That is save the extract to a .tde file and then save your workbook in a .twb file (not a .twbx) unless you have other reasons to package your workbook. That way you can refresh or replace the extract without touching the workbook(s) that reference it.

这篇关于使用脚本将密钥发送到Tableau的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！