https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Data-Transfer-QVD-split-batch-size-extraction/idi-p/1750579 <P>When extracting data from large fact tables via for example an MSSQL server, you have no idea of how large the actual QVD file will become.. And since the file size limit is 500 MB, you will in most cases hit that limit and the data extract will fail.</P><P>You need to be able to extract all data from a fact table without having to use a qlik sense desktop or qlikview client to handle the job <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>The Qlik Datatransfer should be able to split large extractions into x number of QVD files under 500 MB. This could be solved in many ways. But one could be a customized "batch size / number of rows" per QVD file...&nbsp;</P><P>&nbsp;</P><P>Regards,</P><P>Anders&nbsp;</P> Thu, 08 Oct 2020 07:39:37 GMT Florentin74 2020-10-08T07:39:37Z https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Data-Transfer-QVD-split-batch-size-extraction/idc-p/1753709#M3820 Mon, 19 Oct 2020 11:56:46 GMT https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Data-Transfer-QVD-split-batch-size-extraction/idc-p/1753709#M3820 Ian_Crosland 2020-10-19T11:56:46Z https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Data-Transfer-QVD-split-batch-size-extraction/idc-p/2012465#M11017 <P>Hi</P><P>This ability to achieve this is now possible via the Data Gateway Direct Access tool, which provides access to on prem sources via the DLE:</P><P><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway.htm" target="_blank" rel="nofollow noopener noreferrer">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-g...</A></P><P>Thanks</P> Sun, 04 Dec 2022 16:28:45 GMT https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Data-Transfer-QVD-split-batch-size-extraction/idc-p/2012465#M11017 Ian_Crosland 2022-12-04T16:28:45Z