表到计划的集成
评论
-
问题解决了。
Hi Everyone,
\nI was doing POC for Integration between Tableau and Anaplan, where we export the data from Tableau as a file(.csv) and load the file into Anaplan.
\nThought of sharing my approach here.<\/p>Below are the prerequisites we would need to proceed further.<\/p>
- Download the latest Tableau Desktop from the Tableau Website and install it on your Windows.
- Link:
https:\/\/www.tableau.com\/products\/desktop\/download<\/a><\/p><\/li><\/ul><\/li>
- Download the Tabcmd.exe file from GitHub and place the file in the bin folder of the Tableau desktop(path where Tableau is installed on Windows).
- Link:
https:\/\/github.com\/tableau\/tabcmd\/releases<\/a><\/p><\/li><\/ul><\/li>
- We need the below information to export the file from Tableau using a batch script.
- Server URL(Example:https:\/\/prod-Japan-a.online.tableau.com)<\/li>
- Workbook name(Example:Data01_Tableau_Integration)<\/li>
- View Name(Example:Tableau_Export_Data01)<\/li>
- User Id and Password to access Tableau.<\/li>
- Path where the file needs to be downloaded in Windows.<\/li>
- An action details to load the data(from a .csv file) into Anaplan.<\/li><\/ul><\/li><\/ul>
https:\/\/us.v-cdn.net\/6037036\/uploads\/VXRHKIP3DQ7J\/image.png<\/a><\/p>
- Download the Anaplan Connect.zip file from Anaplan and extract the zip in the respective folder.
- Link:
https:\/\/anaplanenablement.s3.amazonaws.com\/Community\/Anapedia\/anaplan-connect-4.1.0.zip<\/a><\/p><\/li><\/ul><\/li><\/ul>
Attaching the script for your reference.<\/p>
https:\/\/us.v-cdn.net\/6037036\/uploads\/5WHUAQ5X1AOE\/tableau-anaplan-intergraton.txt<\/a><\/p>
Kindly suggest if there are any other ways to achieve the same.
\nRegards,
\nVenkatesh<\/p>","bodyRaw":"[{\"type\":\"p\",\"children\":[{\"text\":\"Hi Everyone,\\n\\nI was doing POC for Integration between Tableau and Anaplan, where we export the data from Tableau as a file(.csv) and load the file into Anaplan.\\n\\nThought of sharing my approach here.\"}]},{\"type\":\"p\",\"children\":[{\"text\":\"Below are the prerequisites we would need to proceed further.\"}]},{\"type\":\"ul\",\"children\":[{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"Download the latest Tableau Desktop from the Tableau Website and install it on your Windows.\"}]},{\"type\":\"ul\",\"children\":[{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"Link:\"},{\"type\":\"rich_embed_inline\",\"dataSourceType\":\"url\",\"url\":\"https:\/\/www.tableau.com\/products\/desktop\/download\",\"embedData\":{\"body\":\"Download Tableau Desktop today and start visualizing your data. Start a 14-day free trial and discover the power of fast and easy data visualization.\",\"url\":\"https:\/\/www.tableau.com\/products\/desktop\/download\",\"embedType\":\"link\",\"name\":\"Thanks for choosing a free trial of Tableau Desktop.\",\"faviconUrl\":\"\/themes\/custom\/tableau_www\/favicon.ico\"},\"children\":[{\"text\":\"https:\/\/www.tableau.com\/products\/desktop\/download\"}]},{\"text\":\"//www.adhocstaff.com/community/discussion/155572/\"}]}]}]}]},{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"Download the Tabcmd.exe file from GitHub and place the file in the bin folder of the Tableau desktop(path where Tableau is installed on Windows).\"}]},{\"type\":\"ul\",\"children\":[{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"Link:\"},{\"type\":\"rich_embed_inline\",\"dataSourceType\":\"url\",\"url\":\"https:\/\/github.com\/tableau\/tabcmd\/releases\",\"embedData\":{\"body\":\"A Python based app that replicates the functionality of the existing TabCMD command line utility - tableau\/tabcmd\",\"photoUrl\":\"https:\/\/opengraph.githubassets.com\/5c077cadc0ebc2cf9f87ba9ca29495a90735c71f6c45a98f338e024e6405d4e6\/tableau\/tabcmd\",\"url\":\"https:\/\/github.com\/tableau\/tabcmd\/releases\",\"embedType\":\"link\",\"name\":\"Releases · tableau\/tabcmd\",\"faviconUrl\":\"https:\/\/github.com\/fluidicon.png\"},\"children\":[{\"text\":\"https:\/\/github.com\/tableau\/tabcmd\/releases\"}]},{\"text\":\"//www.adhocstaff.com/community/discussion/155572/\"}]}]}]}]},{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"We need the below information to export the file from Tableau using a batch script.\"}]},{\"type\":\"ul\",\"children\":[{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"Server URL(Example:https:\/\/prod-Japan-a.online.tableau.com)\"}]}]},{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"Workbook name(Example:Data01_Tableau_Integration)\"}]}]},{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"View Name(Example:Tableau_Export_Data01)\"}]}]},{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"User Id and Password to access Tableau.\"}]}]},{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"Path where the file needs to be downloaded in Windows.\"}]}]},{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"An action details to load the data(from a .csv file) into Anaplan.\"}]}]}]}]}]},{\"type\":\"rich_embed_card\",\"children\":[{\"text\":\"//www.adhocstaff.com/community/discussion/155572/\"}],\"dataSourceType\":\"image\",\"url\":\"https:\/\/us.v-cdn.net\/6037036\/uploads\/VXRHKIP3DQ7J\/image.png\",\"embedData\":{\"url\":\"https:\/\/us.v-cdn.net\/6037036\/uploads\/VXRHKIP3DQ7J\/image.png\",\"name\":\"image.png\",\"type\":\"image\/png\",\"size\":20042,\"width\":1587,\"height\":49,\"displaySize\":\"large\",\"float\":\"none\",\"mediaID\":35591,\"dateInserted\":\"2023-05-03T04:19:03+00:00\",\"insertUserID\":80604,\"foreignType\":\"embed\",\"foreignID\":80604,\"embedType\":\"image\"}},{\"type\":\"ul\",\"children\":[{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"Download the Anaplan Connect.zip file from Anaplan and extract the zip in the respective folder.\"}]},{\"type\":\"ul\",\"children\":[{\"type\":\"li\",\"children\":[{\"type\":\"lic\",\"children\":[{\"text\":\"Link:\"},{\"type\":\"rich_embed_inline\",\"dataSourceType\":\"url\",\"url\":\"https:\/\/anaplanenablement.s3.amazonaws.com\/Community\/Anapedia\/anaplan-connect-4.1.0.zip\",\"embedData\":{\"body\":\"PK yNV AnaplanClient.batUT cux YmoHinCӐ}i\/+V%dDTn!c{^4Qzw7ae^3o)%[^'+1C_dF$'yd1aa#1]1s\",\"url\":\"https:\/\/anaplanenablement.s3.amazonaws.com\/Community\/Anapedia\/anaplan-connect-4.1.0.zip\",\"embedType\":\"link\",\"name\":\"//www.adhocstaff.com/community/discussion/155572/\"},\"children\":[{\"text\":\"https:\/\/anaplanenablement.s3.amazonaws.com\/Community\/Anapedia\/anaplan-connect-4.1.0.zip\"}]},{\"text\":\"//www.adhocstaff.com/community/discussion/155572/\"}]}]}]}]}]},{\"type\":\"p\",\"children\":[{\"text\":\"Attaching the script for your reference.\"}]},{\"type\":\"rich_embed_card\",\"children\":[{\"text\":\"//www.adhocstaff.com/community/discussion/155572/\"}],\"dataSourceType\":\"file\",\"url\":\"https:\/\/us.v-cdn.net\/6037036\/uploads\/5WHUAQ5X1AOE\/tableau-anaplan-intergraton.txt\",\"embedData\":{\"url\":\"https:\/\/us.v-cdn.net\/6037036\/uploads\/5WHUAQ5X1AOE\/tableau-anaplan-intergraton.txt\",\"name\":\"Tableau_Anaplan_intergraton.txt\",\"type\":\"text\/plain\",\"size\":1753,\"displaySize\":\"large\",\"float\":\"none\",\"mediaID\":35589,\"dateInserted\":\"2023-05-03T04:14:38+00:00\",\"insertUserID\":80604,\"foreignType\":\"embed\",\"foreignID\":80604,\"embedType\":\"file\"}},{\"type\":\"p\",\"children\":[{\"text\":\"Kindly suggest if there are any other ways to achieve the same.\\n\\nRegards,\\nVenkatesh\"}]}]","format":"rich2","dateInserted":"2023-05-03T05:38:57+00:00","insertUser":{"userID":80604,"name":"Venki9902","url":"https:\/\/community.anaplan.com\/profile\/Venki9902","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/D83ETBO0T865\/nLLLBBE4TYQ6D.JPG","dateLastActive":"2023-06-07T07:45:23+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/community+boss.png\")
"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.anaplan.com\/discussion\/155579\/tableau-to-anaplan-integration","embedType":"quote","name":"Tableau to Anaplan Integration","embedStyle":"rich_embed_card"}">
https://community.anaplan.com/discussion/155579/tableau-to-anaplan-integration
- Link:
- Download the Anaplan Connect.zip file from Anaplan and extract the zip in the respective folder.
- We need the below information to export the file from Tableau using a batch script.
- Download the Tabcmd.exe file from GitHub and place the file in the bin folder of the Tableau desktop(path where Tableau is installed on Windows).
- Link:
1 - Download the latest Tableau Desktop from the Tableau Website and install it on your Windows.
