Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
sharankv
Contributor
Contributor

Need a connection to Amazon S3

Hello Qlikview experts,

I have a requirement to directly connect qlikview with Amazon S3. Is there any possible way to do the same?

If connection exists, please specify the native drivers or the third-party drivers and also the step-by-step procedure to connect the same.

I appreciate for your replies.

Thanks

Sharan KV

9 Replies
Frank_Hartmann
Master II
Master II

have a look at attached pdf. might be helpful!

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Have a look at the link below.

http://wiki.qvsource.com/Amazon-S3-Connector-For-QlikView-And-Qlik-Sense.ashx

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sharankv
Contributor
Contributor
Author

Hi Frank,

The pdf you have shared is how to connect to Redshift Database (Correct me if Iam wrong). Is this the same way to connect to the Amazon S3 even?

Thanks

Sharan KV

sharankv
Contributor
Contributor
Author

Hi Kaushik,

I had a look at the link, which I understand is the required connector is still in progress and it may get release at any time by the Qlik team. But I can see the snapshot connecting to Amazon S3 with some credentials and not the connector. Please post the download link of connector.

Thanks

Sharan KV

peter_turner
Partner - Specialist
Partner - Specialist

Hi,

I came across a software product called TNT drive, which allows you to map an S3 bucket to a drive letter in windows, and use that as a normal drive.

Not used it in production yet and I'm sure there are other ways/software, but it might provide a way forward for you.

Anonymous
Not applicable

Does anyone know what the status is on the Amazon S3 connector? It looks like it's in beta according to QVSource but I can't seem to find any information on it through Qliks web page.

petter
Partner - Champion III
Partner - Champion III

What do you need to do? S3 can be used directly with "Web File" from both QlikView and Qlik Sense as long as the file is public.And with an obfuscated filename that should be pretty safe since you would use https to have a secure channel.... Using a Web File connection you can even read QVD-files from S3 - if you want.

If you use the Qlik REST connector you can even provide credentials via a header so the file does not need to be "public". Then you could read CSV, JSON and XML off of S3.

vb00494773
Partner - Contributor III
Partner - Contributor III

Hi Petter Skjolden,

Thanks for the reply,

For connecting direct web file in qlik sense we need S3 bucket url , but the file URL which was there in S3 will get expire within  30 minutes.

Please suggest which url need to pass in the webfile ?

In the above case it is not dynamic , every time we need to pass url which and all file we need from S3 . Do you have idea , how to make it in dynamic way (where we have one dedicated URL to list all the files in S3) ?


Second option Rest API:

Can you give a snap how to configure the REST API in qlik sense ?

Thanks,

Venkatesh

Troy1
Contributor III
Contributor III

Did you try TNT drive with QlikView/QlikSense, how did it work. Please share your experince.