1 of 1 people found this helpful
If I understand correctly:
- you don't have Tableau Sever that can automatically refresh your extracts every morning
- you cannot connect live to a huge database for performance reasons
- Tableau views need to be updated daily
Given this situation, you don't have too many options.
If your Tableau views present aggregated data and there is no need to drill into lower levels, then the best approach would be to set up, in your database, materialised views that would aggregate large amounts of data into manageable sizes and refresh overnight. Then it is a straight live connection to those views (which are essentially tables).
Creating plain views or custom SQL may or may not work, as in both cases database will have to execute a query almost every time the user interacts with the view, which might take a very long time.