topic Re: Using Mongo DB as Source in Qlik Replicate

Using Mongo DB as Source

sush_1 — Mon, 20 May 2024 06:11:08 GMT

Hi team,

We are migrating data from Mongodb to Redshift. We need to convert the Json format to tabular format while transferring data .

Is there any way to do this transformation for mongodb as a source.

Regards,

Sushant

Re: Using Mongo DB as Source

SushilKumar — Tue, 21 May 2024 04:48:51 GMT

Hello @sush_1

There is nothing mentioned in Qlik Help doc .

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/MongoDB_Source/mongodb_advanced.htm

For Data transfer " We need to convert the Json format to tabular format while transferring data."

Qlik extract the data and store data in it required format. however not sure it can be done that easily. Requests you to engage PS Via your account manager for Further Assistance.

https://community.qlik.com/t5/Knowledge-Base/How-and-When-to-Contact-the-Consulting-Team/ta-p/1714936

Regards,

Sushil Kumar

Re: Using Mongo DB as Source

john_wang — Fri, 24 May 2024 04:10:04 GMT

Hello @sush_1 ,

We've a similar discussion before Parse json at Qlik Replicate level. Please check Heinvandenheuvel and myself comments there.

Hope it helps.

John.