2 Replies Latest reply on Apr 12, 2018 11:03 PM by Gunarathinam Mahaligham

    Multi-Database Visualization- Best Practices

    Gunarathinam Mahaligham

      Novice Tableau author here. My project got a requirement to develop the Tableau Sales dashboard of 5 years of sales data.

      The current year sale data always resides on the OLTP MSSQL database, and all prior year data got archived end of year and all resides in respective database. In summary we got 5 years of data in 5 database.

       

      The challenges are

      1) The number of years will vary from customer to customer

      2) Same tableau worksheet should work for multiple customer, just pointing to the same MSSQL Instance

      All database has the same schema, and what's the best way to bring this data in Tableau?