3 Replies Latest reply on Jan 7, 2019 7:24 AM by patrick.byrne.0

    Refresh Extracts Based on Trigger Instead of time

    Kashish Bhola

      Hi Community,

       

      I really Need your help with this topic, Below I've described my whole scenario-

      • I am using 2 databases HIVE and VERTICA and I have published it to tableau server(2018.2.2) then i have appended the data for the automation purpose.
      • As per our automation we kept Vertica's data in Tableau Server for Refreshing and for Appending the Hive's data we made a python script ( which 1st creates a tde file and then appends it to the Vertica which is kept in Tableau Server). So the process of the refresh is like, Firstly the Vertica's data gets refreshed with the help of the scheduler in tableau server at 9:30 AM and then the python script runs with the help of the scheduler that has been set in the linux system for 10:00AM.
      • Now , I wants that the process of Refreshing the extract should not be time based instead it should be based on the Source data availability (Trigger) i.e whenever the source data is ready/available  the vertica should get refreshed and then the python script should run.
      • Also, the client wants to know that how we can refresh the extracts without using tableau server (i.e with Tabcmd/tsm commands) scheduler for the automation and how can we check the completion status of the scheduled refresh extracts (which are running in Tableau Server).
      • Is there any script which can refresh my extracts?

       

      Your inputs will be really helpful for me!

       

      Thanks & Regards

      Kashish Bhola

        • 1. Re: Refresh Extracts Based on Trigger Instead of time
          patrick.byrne.0

          Hello Kashish,

           

          The ability to trigger a refresh based on the connections availability would be a feature request for the Tableau products. Please submit the idea to the Tableau Community Ideas Space.

           

          We run updates to a data source that has varying update finishing times. So we run multiple refreshes to make sure we captured the data.

           

          Hope this helps!

           

          Cheers,

          Byrne, Patrick

          Community Manager

          Tableau Software

          1 of 1 people found this helpful
          • 2. Re: Refresh Extracts Based on Trigger Instead of time
            Kashish Bhola

            Hi Patrick Sir,

             

            Can I put this same scenario in ideas space or I should only Specify the Event trigger based Refresh Problem?Though, Running multiple refreshes is also a solution but if i have 10 reports and I set multiples refreshes(Hour based Schedules) on each report will there be any performance issue in my Tableau server ?

             

            Hope You Have a Nice Day!

            Regards

            Kashish

            • 3. Re: Refresh Extracts Based on Trigger Instead of time
              patrick.byrne.0

              Hello Kashish,

               

              Please submit the event-based trigger refreshes as there own separate idea. There are additional resources and techniques for running a Tableau Server with a high number of extracts that can be discussed as well. The actual impact on performance is going to be dependent on several factors.

               

              But, the short answer is yes, running extracts every hour could impact the performance of the Tableau Server.

               

              We do have configuration suggestions for a Tableau Server that has an extremely heavy extract load. Performance Tuning Examples - Tableau I would review the example and then do a small test on how the Tableau Server performs when running 10 extracts each hour.

               

              Cheers,

              Byrne, Patrick

              Community Manager

              Tableau Software

              1 of 1 people found this helpful