Qlik Community

Qlik Cloud Data Services

Discussion Board to explore in-depth resources and chat with Qlik Cloud Data Services experts from around the globe.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
devarasu_rasave
Contributor II
Contributor II

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

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

 

Labels (3)
1 Solution

Accepted Solutions
Leigh_Kennedy
Employee
Employee

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.

View solution in original post

1 Reply
Leigh_Kennedy
Employee
Employee

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.