6 Replies Latest reply on Feb 5, 2016 4:44 AM by galaxy.tab

    Data Connections - SQL Server

    galaxy.tab

      Hi All,

       

      I have an excel source (200MB) loaded as data source with 7 sheets with data extracted using separate queries.

       

      In Tableau I have the joins defined where the tables have  separate queries and extracts data into a worksheet. In the other sheets I have the dimensions with the joins defined.

       

      Now I have access to SQL server database and want to create and replace the schema. So I have 7 queries and these will extract data from live DB to Tableau and extract data and later schedule on server. Do I need to build separate connections for every query and join them  in Tableau same as like I did in excel ?

       

      What is the right approach to take in this scenario. Can I have 7 connections and then blend them inside Tableau ?

       

      I have many dashboards built of this data.

       

      Please advise.