topic Re: Qlik Replicate- Excel as a source in Qlik Replicate

Qlik Replicate- Excel as a source

Megha_More — Mon, 18 Dec 2023 10:10:43 GMT

Hi team,

Can we use Microsoft Excel as a source ?

If yes, then which source point ?

Regards,

Megha

Re: Qlik Replicate- Excel as a source

john_wang — Mon, 18 Dec 2023 10:26:20 GMT

Hello @Megha_More ,

Thanks for reaching out to Qlik Community!

There is NO prebuilt driver for MS Excel files in current Replicate versions. The alternative options are

1. Export the MS Excel files to CSV format files (pre-process step), Qlik Replicate supports the delimited text files as source endpoint.

2. Using the generic ODBC Driver which connect to the MS Excel files. The ODBC Driver can be Microsoft Excel Driver or 3rd party ODBC Drivers. I'm pasting a driver sample below for your reference.

BTW, please take note the ODBC endpoint limitations and going through Professional Services and approved by your Account Manager .

Hope this helps.

Regards,

John.

Re: Qlik Replicate- Excel as a source

Megha_More — Mon, 18 Dec 2023 10:31:05 GMT

Hi @john_wang ,

Thank you for the response, will check with the same.

Regards,

Megha

Re: Qlik Replicate- Excel as a source

john_wang — Mon, 18 Dec 2023 10:40:40 GMT

Hello @Megha_More ,

Thanks for the feedback. Feel free to let me know if you need any additional assistance.

Best Regards,

John.

Re: Qlik Replicate- Excel as a source

raghujakkani — Fri, 15 Mar 2024 20:05:00 GMT

Hi John,

When using 2nd option - ODBC Driver. What is the Source type should be opted ?

Thank you,

Raghu.

Re: Qlik Replicate- Excel as a source

john_wang — Sat, 16 Mar 2024 01:54:38 GMT

Hello @raghujakkani ,

The generic ODBC source endpoint can be used. for example:

The type is "ODBC", and you may choose a pre-defined 64-bit ODBC DSN (in above sample it's "VSAMOFF"). Or you may compose the ODBC Connection String manually.

Regards,

John.

Re: Qlik Replicate- Excel as a source

raghujakkani — Thu, 21 Mar 2024 20:22:31 GMT

We have installed Microsoft 365 Access Runtime, Excel Driver is part of it. We were able to create a DSN using ODBC Data Source Administrator.

But when browsing to select the database for source connection, it couldn't find it. Are we missing anything here ?

Re: Qlik Replicate- Excel as a source

john_wang — Fri, 22 Mar 2024 01:21:39 GMT

Hello @raghujakkani ,

Please create SYSTEM DSN so far you may choose it from Replicate Endpoint Management GUI.

thanks,

John.