https://community.qlik.com/t5/Management-Governance/SQL-Server-pre-processing-or-ETL-in-Qlik-Sense/m-p/1779558#M17270 <P>Raw Data from SQL and do Transform in Qlik - will give flexibility to transform data as needed and in case of multiple projects ..as many times as needed ...&nbsp; in long run will reduce rework&nbsp;</P> Wed, 03 Feb 2021 01:59:23 GMT AdiPai 2021-02-03T01:59:23Z https://community.qlik.com/t5/Management-Governance/SQL-Server-pre-processing-or-ETL-in-Qlik-Sense/m-p/1779557#M17269 <P>Hello,&nbsp;</P><P>We currently have dozens of stored procedures in Microsoft SQL preprocessing data. These stored procedures are out of data and need to go through a thorough data validation process.&nbsp;</P><P>In the process of building a new framework in QlikSense, we are looking at alternate options.&nbsp;</P><P>Option 1: Extract raw db from SQL server - Perform Transforms in QS (saved as QVD)</P><P>Option 2: Preprocess data in SQL server - extract preprocessed data - Perform additional transform in QS</P><P>Both appear to have pro's vs con's.&nbsp;</P><P>Any suggestions/advice is welcome.&nbsp;</P> Sat, 16 Nov 2024 00:41:55 GMT https://community.qlik.com/t5/Management-Governance/SQL-Server-pre-processing-or-ETL-in-Qlik-Sense/m-p/1779557#M17269 JohnMcPhee 2024-11-16T00:41:55Z https://community.qlik.com/t5/Management-Governance/SQL-Server-pre-processing-or-ETL-in-Qlik-Sense/m-p/1779558#M17270 <P>Raw Data from SQL and do Transform in Qlik - will give flexibility to transform data as needed and in case of multiple projects ..as many times as needed ...&nbsp; in long run will reduce rework&nbsp;</P> Wed, 03 Feb 2021 01:59:23 GMT https://community.qlik.com/t5/Management-Governance/SQL-Server-pre-processing-or-ETL-in-Qlik-Sense/m-p/1779558#M17270 AdiPai 2021-02-03T01:59:23Z