Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajat1
Partner - Contributor II
Partner - Contributor II

Few fields in MongoDB database table not visible.

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

Labels (3)
4 Replies
marksouzacosta
Partner - Specialist
Partner - Specialist

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.

Read more at Data Voyagers - datavoyagers.net
RenuLalwani
Employee
Employee

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. 

Rajat1
Partner - Contributor II
Partner - Contributor II
Author

There is no nested JSON in the above mentioned column.

Can you please elaborate more on this ?

Regards,

Rajat

Rajat1
Partner - Contributor II
Partner - Contributor II
Author

Hi @marksouzacosta,

None of the fields are hidden by the Database Team.

Regards,

Rajat