topic Re: Few fields in MongoDB database table not visible. in Connectivity & Data Prep

Few fields in MongoDB database table not visible.

Rajat1 — Thu, 30 May 2024 12:49:34 GMT

Hi Everyone,

I have a MongoDB connection in Qlik Sense Enterprise and I am accessing a table from that database. However, I can only access 17 fields in that table, and 2 fields are missing.

The MongoDB team has ingested those fields on their end, and they are visible in their database, but they are not visible in the Qlik MongoDB table.

We have two connections: one for the PRODUCTION server and one for the DEV server. This issue is occurring in the PRODUCTION server but not in the DEV server.

What could be the cause of this issue?

Thanks & Regards,

Rajat

Re: Few fields in MongoDB database table not visible.

marksouzacosta — Tue, 11 Jun 2024 05:29:35 GMT

I believe in MongoDB you can hide fields from users. Maybe this is the settings that is missing from the user that connects Qlik to your Production Database. You'll have to double check that again with your DBA.

Re: Few fields in MongoDB database table not visible.

RenuLalwani — Sat, 15 Jun 2024 05:34:18 GMT

Is this a nested collection/Json. MongoDB Driver (behind Qlik connector) flattens nested jsons. Do you see another tables also listed. Check if that other table has those fields. In that case, the other table will have a foreign key associated with the main table.

Re: Few fields in MongoDB database table not visible.

Rajat1 — Fri, 05 Jul 2024 12:11:18 GMT

There is no nested JSON in the above mentioned column.

Can you please elaborate more on this ?

Regards,

Rajat

Re: Few fields in MongoDB database table not visible.

Rajat1 — Fri, 05 Jul 2024 12:10:22 GMT

Hi @marksouzacosta,

None of the fields are hidden by the Database Team.

Regards,

Rajat