Solved

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

  • 26 June 2019
  • 5 replies
  • 305 views
meenal_shukla
Rank
Userlevel 7
Badge +1
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.

icon

Best answer by jean.nairon 11 July 2020, 02:46

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

5 replies

B
Rank
Userlevel 1

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

rakesh
Userlevel 7

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
Rank
Userlevel 7
Badge +1

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
Rank
Userlevel 7
Badge +1

Thanks, @jean.nairon !

jean.nairon
Rank
Userlevel 7
Badge +1

You’re welcome @meenal_shukla!!

Reply