topic Re: Can we connect qliksense cloud with Sqlite database in Connectivity & Data Prep

Can we connect qliksense cloud with Sqlite database

shilpagupta1687 — Fri, 11 Dec 2020 21:42:18 GMT

Hello friends,

I have a requirement where I need to connect qliksense cloud to Sqlite database. I have some idea that we can do so in qliksense desktop version by creating an ODBC connection, but is it possible in cloud version. If yes can someone please guide and share the details ?

Thanks & Regards,

Shilpa

Re: Can we connect qliksense cloud with Sqlite database

kmmqlick — Sun, 13 Dec 2020 07:21:26 GMT

Yes. Follow same procedure as did in desktop version

Re: Can we connect qliksense cloud with Sqlite database

shilpagupta1687 — Sun, 13 Dec 2020 10:14:32 GMT

Hi There,

Thank you for your response. In the desktop version we have the ODBC connection through which we can do as I have understood from old community chats but I don't see that in the cloud(Business version). Could you please advice.

Regards,

Shilpa

Re: Can we connect qliksense cloud with Sqlite database

Francisco_Fernandez — Wed, 23 Dec 2020 09:01:28 GMT

Hi @shilpagupta1687 ,

You can use QDT to establish ODBC connections.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikDataTransfer/install-Qlik-DataTransfer.htm

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataSource/ODBC.htm

Best regards,

Re: Can we connect qliksense cloud with Sqlite database

Ken_T — Fri, 07 Apr 2023 14:59:07 GMT

This looks like it is still a gap for Qlik SaaS.
@shilpagupta1687 you will need to install Qlik Data Transfer QDT on one of your servers to be able to do this. then Qlik Data Transfer can push QVDS to Qlik SaaS cloud on a schedule.

If the data does not change often you could do the same totally by hand with qlik desktop, but QDT will allow this to be automated, but you have to have this QDT utility installed in your network to set up the ODBC, so it is kind of a workaround for getting that data into your Qlik SaaS tenant.