I currently run a daily report in Excel with an output deriving from an SQL query written through VBA linked to an Oracle database, so Oracle -> VBA -> SQL in an Excel sheet calling VBA -> Excel output. I would like to modernize my approach and convert the report to Tableau. I know I could import the Output file into Tableau after running the SQL, but know there’s a smarter way.
Any recommendations on how to most efficiently retrieve the daily update data in Tableau?