3 Replies Latest reply on Oct 7, 2016 4:06 AM by aqua.lover

    Publishing a data source on Tableau server and connecting to it using custom SQL

    aqua.lover

      Dear all,

       

      I am currently building my Tableau reports using tables from my database. The problem I have now is that I have a big amount a various data sources and they take some time to synchronize (I have a refresh schedule).

       

      My reports are built by using sometimes custom SQL or simply basic Tableau functions (left join, etc.).

       

      I would like to optimize the time it takes for Tableau to refresh all my data sources by publishing my tables on the Tableau server and then in my reports, to create a custom SQL query that points to these sources.

       

      Like this, if I have a table which is used in various reports (maybe in combination with other tables through joins) it will be refreshed once instead of many times.

       

      Is this something possible to do?

       

      Thanks a lot

       

      Cheers