2 Replies Latest reply on Jan 4, 2019 11:41 PM by Dmitry Chirkov

    SFDC Extract Time Issues

    Macy Miller

      Hello Tableau Community!

       

      I am working with my company's sales and marketing team that primarily use Salesforce data, blended with some other data that is in our data lake. After we connect to our salesforce instance and bring in one of the standard connections that have been created, the load time runs for so long that it times out (it was running for almost a full work day). The current workaround that we have is to download the data from salesforce, saving it to our machines locally, and then importing it as an extract from our local machine. This is much more manual than we would like, so if anyone has experienced this issue in the past and has a solution that would be greatly appreciated!

       

      I cannot attach a packaged workbook because of the aforementioned scenario, but we are using Tableau Desktop version 2018.1.Screen Shot 2018-11-21 at 12.29.01 PM.png

       

      I understand this screenshot is a poor example because the elapsed time is only 22 seconds, but this screen will remain open for hours, and even if we select cancel, the field names will load in the "Sheet" tab, but there will be no data, and an error message that appears whenever we select any dimension or measure.

      Screen Shot 2018-11-21 at 12.32.55 PM.png

        • 1. Re: SFDC Extract Time Issues
          patrick.byrne.0

          Hello Macy,

           

          Thanks for posting in the Tableau Community Forums! This could be an expected time for the extract to complete depending on the size of the tables that are being joined. As well as the relationships being established. one to many, many to one etc...

           

          Does reducing the size of the extract allow for the successful connection to the SFDC.

           

          Information on reducing the extract size can be found in the following Knowledge Base article: https://kb.tableau.com/articles/howto/reducing-the-size-of-a-salesforce-extract

           

          Hope this helps!

           

          Cheers,

          Byrne, Patrick

          Community Manager

          Tableau Software

          • 2. Re: SFDC Extract Time Issues
            Dmitry Chirkov

            Patrick,

            we do not perform join when we create Salesforce extract - we fetch all tables one by one and materialize them separately.

            I suspect that one or some of the tables are huge and takes forever to download.

             

            Macy,

            From my experience this flow is typically has a bottleneck on Salesforce side as their API are not super fast.

             

            What I would do:

            1) Open Tableau's log file (Documents\My Tableau Repository\Logs\log.txt) and figure our during which table extraction does the process get stuck

            2) Try to hide as many columns as possible to prevent them from being queried and extracted

            3) Try extracting one table at the time to find a problematic one

            1 of 1 people found this helpful