3 Replies Latest reply on Apr 12, 2018 5:01 PM by Cathy Bridges

    how to use multiple data sources (no join involved) from single database connection

    Francesco Dalla Libera

      revamping https://community.tableau.com/ideas/7003

       

      as a recap, I would like to do the following:

       

      1) use one single database connection

      2) using 1+ tables from said database

      3) such tables are unrelated: they do not share any kind of field, they must not be joint

       

      now, as the question highlights, if we relax (1) constraint, I can create multiple connections to the same database and I am good to go, if not for the fact that I would need to sign in to the database N times and that would also be detrimental to the server upon which the database is stored. therefore, it would be highly preferable that use a single database connection.

       

      is there any way to do it?