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

    Data Connections - SQL Server


      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.