Skip to main content
Solved

How do you upload data from Tableau into Gainsight S3 bucket? Need some ideas.


meenal_shukla
Forum|alt.badge.img+5
Customer data resides in Tableau. They need to import this data into S3. Where does one start?

Any ideas or what you have seen working in past.

Best answer by jean.nairon

Hi @meenal_shukla. It will depend on what version of Tableau they are using. There’s Tableau Desktop which is the version individual users can download to their computers or Tableau Server and Tableau Online which are both in the cloud. Server is typically for enterprises who want to share and control access of a group of users. 

 

In any version of Tableau, a user can export a table to CSV manually. And they can of course manually upload it to the S3 bucket. But that is manual and would be only good for single use. Here is some information on how to manually export


If they are looking to automate this on Tableau Server which is most generally the use case I have seen, they can use Tabcmd to automate the export. Here are some how to steps. This will allow them to setup an export schedule but will save the file to whatever computer they are using. They can then use another utility to load ​​​​the file to the S3 bucket. Here is one example of a tool they can use. 

 

Hope this helps!

View original
Did you find this topic helpful?

5 replies

Forum|alt.badge.img
  • Contributor ⭐️⭐️
  • 9 replies
  • April 23, 2020

We have the same issue - has anyone found a resolution for this?


rakesh
Forum|alt.badge.img+1
  • Lets put your data to work!
  • 835 replies
  • May 5, 2020

Tableau has a lot of data ingest options, but exports usually need some additional help. Its really obvious why Tableau focuses on Data Ingest - because it needs data to be an effective BI. Tableau can export data as csv’s manually on demand. We can place them in S3 and use them 
For the automatic feed, some of Tableau’s customers were able to set up some FTP export data feeds from Tableau. This can work with S3, which supports FTP data feeds. I am posting one such solution I found online.  cc: @kunal_bhat 


jean.nairon
Forum|alt.badge.img+4
  • Expert ⭐️
  • 421 replies
  • Answer
  • July 11, 2020

Hi @meenal_shukla. It will depend on what version of Tableau they are using. There’s Tableau Desktop which is the version individual users can download to their computers or Tableau Server and Tableau Online which are both in the cloud. Server is typically for enterprises who want to share and control access of a group of users. 

 

In any version of Tableau, a user can export a table to CSV manually. And they can of course manually upload it to the S3 bucket. But that is manual and would be only good for single use. Here is some information on how to manually export


If they are looking to automate this on Tableau Server which is most generally the use case I have seen, they can use Tabcmd to automate the export. Here are some how to steps. This will allow them to setup an export schedule but will save the file to whatever computer they are using. They can then use another utility to load ​​​​the file to the S3 bucket. Here is one example of a tool they can use. 

 

Hope this helps!


meenal_shukla
Forum|alt.badge.img+5
  • Author
  • Gainsight Employee ⭐️⭐️
  • 208 replies
  • July 13, 2020

Thanks, @jean.nairon !


jean.nairon
Forum|alt.badge.img+4
  • Expert ⭐️
  • 421 replies
  • July 21, 2020

You’re welcome @meenal_shukla!!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings