Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

guptanupur
New Contributor II

How to connect s3 csv files to qlik sense through qlik web connector .

HI ,

I was trying to connect s3 throught qlik web connector ... it got connected but it is not giving an option to select csv file ... how do i load my csv in qlik sense through qlik web connector from S3

9 Replies
bdf
New Contributor III

Re: How to connect s3 csv files to qlik sense through qlik web connector .

Hello Nupur,

Greetings! Is the CSV file publicly shared or is it private. Also, did you try to access it via Amazon S3 connector?

You can try these - How to read Amazon S3 files - approach #1 - Web File or Using Amazon S3 with Qlik Sense

Thank You

Bala

================================================================================

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

guptanupur
New Contributor II

Re: How to connect s3 csv files to qlik sense through qlik web connector .

Hi Bala,

  yes the csv file is public ... but I couldn't select the csv file from the folders ..

bdf
New Contributor III

Re: How to connect s3 csv files to qlik sense through qlik web connector .

Hello Nupur,

Request you to post a screenshot of the error message or a screenshot wherein the connector is stuck.

Thank You

Bala

================================================================================

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

guptanupur
New Contributor II

Re: How to connect s3 csv files to qlik sense through qlik web connector .

HI Bala ,

in the first step I am getting an error - for list buckets after giving credentials  - it is showing access denied - I don't know what to do -- Does s3 owner has to give me some kind of access ...or I have to do from my side any kind of setting

qwe.PNG

guptanupur
New Contributor II

Re: How to connect s3 csv files to qlik sense through qlik web connector .

Also I am trying to run in qlik server not in my local host

bdf
New Contributor III

Re: How to connect s3 csv files to qlik sense through qlik web connector .

Hello Nupur,

I would normally test with postman from the machine the Web Connector request (For example : if running from a server, test with Postman from the same server)

1iSyKls.png

403 indicates that it's a permissions issue. So i would suggest you to use postman tools and verify the authentication.

Thank You

Bala

================================================================================

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

bdf
New Contributor III

Re: How to connect s3 csv files to qlik sense through qlik web connector .

You can also try using AWS Glue Crawler - It reads files (any formats from csv or parquet or headers) from S3 and loads it into AWS Athena. Qlik can connect to Athena with JDBC connector.

No server running, unlimited data space, lesser cost for storage (S3 pricing), also speed is acceptable for large files.

Thank You

Bala

================================================================================

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

guptanupur
New Contributor II

Re: How to connect s3 csv files to qlik sense through qlik web connector .

HI Bala ,

The connection issue is resolved ,

But I am facing some other issue

After loading data though lod script  it is not syncronizing in the data manager .. I was trying to load csv file in my app from s3 .

find below screen shot - Can you please help .. because I have to load all data through load script only .

qli.PNG

guptanupur
New Contributor II

Re: How to connect s3 csv files to qlik sense through qlik web connector .

Also is it only possible to give to only one csv connection to qlik in app ... what if I have to upload two files from same s3 bucket ?what url should I give to get bucket connection to qlik ?