move files (qvd/csv) from Qlik SaaS to On premise server?

[devarasu_rasave]

Hi Qlik Team,

can we have option to scheduled download/extract data (qvd/csv) files from Qlik Sense SaaS into on-premises local server. because we need to share the output data file with application/data warehouse team for their data ingestion/other business requirement.  upon checking Qlik DataTransfer tool we can upload on-premises data into Qlik SaaS but we don't have option to send back files from SaaS into on-premise server. 

Regards,

Deva

[Leigh_Kennedy · Accepted solution]

Yes, this is possible.  Firstly you will need a connection to a cloud file store like S3 or similar.

Then you need to build a simple app that loads the qvd and saves it to that storage as a CSV using the store command. E.g.

deliveries:
LOAD * FROM [lib://myspace:DataFiles/deliveries.qvd] (qvd);

LIB CONNECT TO 'myspace:Amazon_S3';

Store [deliveries] into 'LIB://myspace:Amazon_S3/deliveries.CSV' (TXT);

drop Table [deliveries];

Regards.