Using Mongo DB as Source

[sush_1]

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

[SushilKumar]

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...

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/171493...

Regards,

Sushil Kumar

[john_wang]

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.