1 Reply Latest reply on Aug 3, 2012 8:47 PM by Robert Morton

    What is the difference between Data Source and Data Connection

    esteban revello

      What is the difference between Data Source and Data Connection?

        • 1. Re: What is the difference between Data Source and Data Connection
          Robert Morton

          Hi Esteban,

           

          A Data Connection represents the database server information required to log in (connect) to a database, and it also contains the relation for the underlying data. The relation may be a single table, a multi-table join, or a Custom SQL query that yields a result set.

           

          A Data Source represents the view of this data connection as it appears in the 'Data' pane on the left side of the Desktop product interface. This includes any changes you make to the fields, such as their caption, aliases, geographic role, default aggregation, etc. Additionally, a Data Source represents fields which do not exist in the underlying Data Connection, such as calculated fields, ad-hoc groups, sets, and Tableau-generated fields such as 'Measure Names', 'Measure Values', 'Latitude (generated)', and 'Longitude (generated)'. Collectively, this is sometimes referred to as the data model.

           

          I hope this helps,
          Robert

          1 of 1 people found this helpful