topic Re: Is it possible to connect S3 to qlik sense without making my buckets and files public in Visualization and Usability

Is it possible to connect S3 to qlik sense without making my buckets and files public

Anonymous — Wed, 27 Jun 2018 05:56:40 GMT

HI,

Is it possible to connect S3 to qlik sense without making my buckets and files public . Is there any other work around to do so to connect to S3 ?

Re: Is it possible to connect S3 to qlik sense without making my buckets and files public

petter — Wed, 27 Jun 2018 06:33:20 GMT

The Qlik Sense June 2018 release comes with Apache Drill as a connector. Apache Drill is a connector that can connect to several different sources - so it is not a "single" connector but a multi-connector. Amongst the sources it support is Amazon S3:

https://drill.apache.org/docs/s3-storage-plugin/

and according to the documentation and my own tests full use of credentials is supported too.

Re: Is it possible to connect S3 to qlik sense without making my buckets and files public

Anonymous — Wed, 27 Jun 2018 10:06:35 GMT

If we are using the older version of qlik sense - Sep 2017 ... Will this work ?

Re: Is it possible to connect S3 to qlik sense without making my buckets and files public

petter — Wed, 27 Jun 2018 11:01:08 GMT

Yes, it is quite possible to download the Apache Drill ODBC-driver manually and install it. I have done that with Qlik Sense versions going back about two years already.

https://drill.apache.org/docs/installing-the-driver-on-windows/#step-1:-download-the-drill-odbc-driver

You will also have to download and install Drill locally if you don't plan to have a Drill cluster/server. This is called embedded mode and you find the instructions here:

https://drill.apache.org/docs/embedded-mode-prerequisites/

Finally you will have to enable the Storage Plug-In for S3:

By pressing Enable as you can see above...

Re: Is it possible to connect S3 to qlik sense without making my buckets and files public

petter — Wed, 27 Jun 2018 14:48:06 GMT

and finally you can specify your Amazon S3 credentials by updating the S3 Storage Plugin:

Re: Is it possible to connect S3 to qlik sense without making my buckets and files public

petter — Wed, 27 Jun 2018 14:54:25 GMT

Another option is to use the Qlik WebConnectors and the standard S3 connector that is available for free - not licensed:

https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Data-Source-Connectors/Amazon-S3-Connector…

This also has authentication/credentials included so you don't need to have public access.

Re: Is it possible to connect S3 to qlik sense without making my buckets and files public

Anonymous — Thu, 05 Jul 2018 09:27:27 GMT

HI Peter ,

Itried connecting S3 bucket through the qlik web connector ...I got the authentication as well .. but I was able to upload only one csv file at a time .. is it possible to load full folder and access files in it.

Also can u pls guide me through the AWS Athena connection to s3 bucket ??