4 Replies Latest reply on Sep 1, 2016 1:33 PM by Rahul Upadhye

    Union All - across data servers

    Rahul Upadhye

      Hi Developers,

       

      Im facing some challenge due to some limitations.

       

      Limitations: Can't use ETL, Read Only permission for the db.

       

      Challenge: Union two data tables (exact same schema), prod table union with archived table such that - Data tables resides in two different SQL Servers.

       

      Im looking for some hack/work around in Tableau itself.

      My last hope will be to do the union outside of Tableau.

       

       

      Currently its possible to union using custom sql from tables residing in same database, but is it possible to union across two diff. data servers?

      [ref: Defining Custom Joins with the Custom SQL Option | Tableau Software ]