1 Reply Latest reply on Aug 28, 2018 7:20 AM by Paulo Dantas

    Data Source Connections and Initial SQL vs Custom SQL

    John Commissaris

      Hi All,


      I'm trying to develop the most efficient pathway for getting data from an Oracle Server to manipulations/displays in Tableau.  I see a few different pathways to achieve this:


      Oracle --> Scripts in Oracle to manipulate/refine data into a table that needs minimal work --> connect to Oracle in Tableau Desktop --> load tables


      Oracle --> connect to Tableau Desktop --> write initial SQL to manipulate/refine data --> write custom SQL to further manipulate/refine? --> load tables


      I'm not sure what the smartest/best pathway is for this, as there's multiple ways to achieve the end goal of presentation in Tableau Desktop/Server.


      Any advice would be much appreciate.