Qlik Replicate- Excel as a source

[Megha_More]

Hi team,

Can we use Microsoft Excel as a source ?

If yes, then which source point ?

Regards,

Megha

[john_wang · Accepted solution]

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.

[Megha_More]

Hi @john_wang ,

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

Regards,

Megha

[john_wang]

Hello @Megha_More ,

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

Best Regards,

John.

[raghujakkani]

Hi John,

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

Thank you,

Raghu. 

[john_wang]

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.

[raghujakkani]

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 ?

[john_wang]

Hello @raghujakkani ,

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

thanks,

John.