Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guptanupur
New Contributor II

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

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 ?

6 Replies
MVP
MVP

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

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.

guptanupur
New Contributor II

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

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

MVP
MVP

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

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-driv...

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:

2018-06-27 16_42_11-Kalkulator.png

By pressing Enable as you can see above...

MVP
MVP

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

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

2018-06-27 16_45_58-Microsoft Edge.png

2018-06-27 16_46_17-Kalkulator.png

MVP
MVP

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

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...

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

guptanupur
New Contributor II

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

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 ??

Community Browser