1 Reply Latest reply on Feb 1, 2012 6:35 PM by Russell Christopher

    MSSQL views and extracts

    michel rathe

      Hi,

       

      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

        • 1. Re: MSSQL views and extracts
          Russell Christopher

          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?