Hi there,
Question title pretty much sums it up, but I am trying to figure out the best route to take for the long term. Is there a noticeable difference, and if so which is better, between creating stored procedures and linking them to a job that runs every 24 hours versus refreshing extracts from DB views on a schedule set on Tableau server?
I'm leaning towards views and updating extracts on a schedule (can't do real time pull due to enormous amount of data, but DB server can handle this) as it will be less updates on the backend unless the underlying code changes.
Appreciate any insights on this.
Hey Rahul,
It definitely depends on the environment. If there is going to be heavy processing, the Stored Procedure may be the best route, as it can give you access to additional processing features that may speed up the processing. (variables, breaking processing into steps, etc.)
In addition, the extract refreshes on server time out after awhile (2 hours by default, by can be adjusted), so if you are nearing that point, you may consider storing the data in a table in your database as well.
That being said, if the views are returning fast enough - it would save space to write them to the extract itself, as the view in the database does not have to be stored to disk.
Derrick Austin
InterWorks, Inc.
