Please I need a quick answer on that topic.
Are there any risks for MSSQL DB to extract from SQL views (virtual tables)?
Are those views recognized by Tableau?
Will it slow the performances of the erp system as a whole?
Is the extract a long process
HI Michael -
Tableau can use a SQL Server view as a source for an extract - no problem there.
Your other questions are harder to answer definitively. Depending on what fields the view contains and how many rows will be returned, extracting (reading) could be very quick, or take a little while.
Do you know how much data you're dealing with?