Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Qlik Dropbox connector what are the purpose ?

Hi All

I have read the below blog post , but i am still blur.

Qlik Design Blog

Hope some one can share with me , does the dropbox connector able to solve my issue ?

Now i am using QS 3.2 , and i have upload the QVF file to cloud. now i like to make it automatic update the raw data, instead of manually upload the QVF file,

My question is does dropbox connector able to solve the problem. What i mean is my raw data and put at dropbox and Qlik dropbox connector will automatic reload thru the dropbox connector to update my raw date to cloud.

Hope some one can share with me.

Paul Yeo

30 Replies
robert99
Specialist III
Specialist III

Hi Paul

I think the answer to this is yes maybe.

Business cloud can be set up to automatically update once per day (hopefully it will be changed to make it at least hourly before too long). This can only update from Sales force or files manually uploaded to the cloud.  Eventually Qlik plan to have an automatic link to an in house server and many other cloud links apart from SalesForce. But it seems this could be some time off. So what to do

One option is to run the personal edition and create QVDs. And then to manually upload these QVDs. Qlik will then do the rest.

The Dropbox process could be used to simplify this process. For example create QVDs as above and save to a folder linked to Dropbox. Dropbox and Qlik business cloud will then do the rest. Likewise save say an Excel file to a linked Dropbox folder

Michael_Tarallo
Employee
Employee

Hi Paul,

To clarify - the log post is actually talking about the REST Connector that is included with Qlik Sense Cloud Business. There is a link in the post that references a discussion thread: Update your Qlike Sense Cloud Business workgroup data files with REST and Dropbox - Proof of Concept - Currently, QSCB allows you to connect to files that you upload, Salesforce, Qlik DataMarket and now REST based sources. QSCB also includes a scheduler that will allow you to refresh your Qlik Sense app with new data from these sources. However, if you are using FILES, you would need to first MANUALLY update / upload the new file to the group data import area - there isn't any automated process to do this. So if you have a Qlik Sense app that is scheduled to refresh daily - and that app is using files as a data source, then you need to make sure the new updated file has been uploaded first.

That being said - I created a proof of concept (POC) that will allow you to use the REST Connector AND the Dropbox REST API - a cloud-based file storage solution - in this case I used Dropbox and their provided REST / HTTP API. What this means - is that you can securely store your files in a dropbox folder instead of Qlik Sense Cloud - and create a Qlik Sense Cloud Business REST Connector that accesses the file on Dropbox instead and use that as your data source. THEN you can have some third party tool (such as windows task scheduler) copy a new updated file from the source system to the dropbox folder - and when the Qlik Sense scheduler refreshes the app - it will use the latest data from that file. Again this was more of a POC to help those that wanted to refresh Qlik Sense apps from files, without having to manually import / upload the new file to Qlik Sense Cloud Business.

NOTE: If the file is publicly available AND available in a public Dropbox folder and therefore is NOT in a SECURE LOCATION - you can simply reference with a public link as long as the file is JSON, XML or CSV - YOU CANNOT USE an EXCEL or other files with this method. Just another TIP to share.

Dropbox public folder

Copy Dropbox public link: - for file

Paste Public Dropbox link into REST Connector URL box

Get data (CSV)

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.

Regards,

Michael Tarallo (@mtarallo) | Twitter

Qlik

Regards,
Mike Tarallo
Qlik
paulyeo11
Master
Master
Author

Hi Michael

Thank you very much for your sharing . I want to try it out . As what you share I am able to follow .

May 1 know how can I create a trail Qlik Sense Cloud Business account ? So I can try it our how to do it ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Michael_Tarallo
Employee
Employee

Hi Paul - I replied to you in the other post on the blog:

"Hi Paul - do you mean a Qlik Sense Cloud Business - "TRIAL" - I believe you automatically get a 14 day trial with Qlik Sense Cloud Business when you sign up. DO NOTE - you can also do this with the FREE Qlik Sense Desktop product to test out the REST Connector as it comes included with Desktop and Enterprise."

HTH

Mike

Regards,
Mike Tarallo
Qlik
paulyeo11
Master
Master
Author

Hi Michael

Do you have the sample file for me to test on Dropbox connnector ? I mean just like you share with me below :-

https://community.qlik.com/thread/256068

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Michael_Tarallo
Employee
Employee

Sure - it can be any CSV file - here is a sample

Regards,
Mike Tarallo
Qlik
paulyeo11
Master
Master
Author

Hi Michael

I save the gettingstarteddata.csv to my computer folder :-

C:\Users\Paul Yeo\Dropbox\DataFile

I have create a QVF file , i get error msg.

error qs.png

I think it is some thing wrong with the below lines.

FROM [lib://DataFolder/gettingstarteddata.csv]

(biff, embedded labels, table is $gettingstarteddata);

I need to create the above QVF file and i will send to qlik cloud. and then i will need to use the dropbox connect to link to my dropbox to set it auto reload.

Hope you can help me to solve the error msg , so i can move on.

Paul Yeo

paulyeo11
Master
Master
Author

Hi Michael

Enclosed my QVF which have error msg.

Paul

Michael_Tarallo
Employee
Employee

I don't think you set up the data correctly using the data manager / wizard you must select these settings so  it should be like this:

Which will create the load script like this:

LOAD

    Address,

    CategoryID,

    CategoryName,

    City,

    ContactName,

    "COS",

    Country,

    Customer,

    CustomerID,

    Description,

    Discount,

    EmployeeID,

    Fax,

    Freight,

    GP,

    "Month",

    OrderID,

    Phone,

    PostalCode,

    ProductID,

    ProductName,

    Quantity,

    Quarter,

    Sales,

    ShipperID,

    SupplierID,

    OrderDate

FROM [lib://DataFolder/gettingstarteddata.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

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.

Regards,

Mike

Qlik

Regards,
Mike Tarallo
Qlik