topic Re: Store QVD in Amazon S3 in App Development

Store QVD in Amazon S3

Marco — Mon, 10 Oct 2022 09:54:44 GMT

Hi all,
in Qlik Cloud I created a data connection to Amazon S3. In the connection I have set "Access Key", "Secret Key", "Region" and "Bucket name".
So far, so good; I can correctly load the data of all files contained in the bucket.
Now, the problem is storing qvd. Which parameter should I set in "SSE header value (for use with STORE command only)" of the data connection?
Where Can I retrieve this information in Amazon S3? And what kind of encryption should I set in the bucket properties?

Regards,
Marco

Re: Store QVD in Amazon S3

-AA — Fri, 21 Oct 2022 07:50:34 GMT

I am also looking for the same but couldn't find the solution yet. About SSE header value it is mentioned at https://help.qlik.com/en-US/cloud-services/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Storage%20provider%20connectors/Amazon-S3-storage-provider-connector.htm

Let me know if you find something to make this work.

Best Regards,

Amit Arya

Re: Store QVD in Amazon S3

ToniKautto — Fri, 27 Jan 2023 07:42:24 GMT

The valid values are listed in Qilk Help;

https://help.qlik.com/en-US/cloud-services/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Storage%20provider%20connectors/Amazon-S3-storage-provider-connector.htm?_ga=2.31819518.1920011952.1674781180-423749451.1652755111#:~:text=If%20SSE%20header%20value%20is%20not%20empty%2C%20valid%20values%20are%3A

Re: Store QVD in Amazon S3

christianjmz — Wed, 16 Aug 2023 16:20:51 GMT

Hi @Marco and @-AA , I'm facing the same issue. Were you able to find a solution for this?

I'm able to connect to S3 but there is an error when trying to store a file in it ("Cannot open file").

Thanks,
Christian

Re: Store QVD in Amazon S3

-AA — Thu, 17 Aug 2023 18:53:39 GMT

Hi @christianjmz

Try store statement as: store test into [lib://SpaceName:Connection Name to S3/S3 Folder Name/test.qvd];

In connection use AES256 as SSE header value.

If above setting don't work than try to check and elevate the rights on S3 bucket.

Let me know if this works

Thanks,

Amit

Re: Store QVD in Amazon S3

Anjit — Thu, 29 Feb 2024 10:12:45 GMT

I'm getting the same error while executing the Store Command on Qlik Sense. How can we add the SSE value in connection string.

If SSE header value is not empty, valid values are:

aws:kms
AES256

Can anyone help with the format.