topic How to load data from MS Acess DB in QlikSense cloud trial version? in Connectivity & Data Prep

How to load data from MS Acess DB in QlikSense cloud trial version?

onkarkulkarni — Mon, 24 Jan 2022 22:16:57 GMT

Dear Qlik community,

I want to load data from MS Access database(.mdb) in QlikSense cloud (free/trial version). I can see number of connectors like apache, oracle etc but not MS Access. Do I need ODBC connection for it?

Please guide. Thanks in advance!

Regards,

Onkar

Re: How to load data from MS Acess DB in QlikSense cloud trial version?

Francisco_Fernandez — Mon, 07 Feb 2022 09:03:27 GMT

Hello @onkarkulkarni ,

Yes, an ODBC connection is needed for MS Access. Since the ODBC connector is not available in Qlik's cloud, I would suggest that you install Qlik Data Transfer.

You will find the download here:

https://tenantname.eu.qlikcloud.com/settings/tools

And here you will find a bit more information about QDT:

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

Best regards,

Francisco

Re: How to load data from MS Acess DB in QlikSense cloud trial version?

onkarkulkarni — Thu, 31 Mar 2022 03:40:25 GMT

Thanks @Francisco_Fernandez - This is really useful!