MongoDB connector limits text field to 255 characters

[Sonja_Bauernfeind]

When loading data with MongoDB connector (Qlik ODBC connector package), if a text field value is longer than 255 characters, it will be trimmed to 255 characters.

Cause:

Currently the MongoDB driver of Qlik ODBC Connector package does not use the maximum string column length specified through the Schema Editor and defaults to 255. 

Environments:

• Qlik ODBC Connector Package , version 6.16.1 (Qlik Sense June 2019)

Resolution:

Maximum length of data filed can be increased by adding advanced parameter DefaultStringColumnLength in the connector dialog and set a higher number. Note that the maximum value that you can set for this option is 2,147,483,647

 

Internal Investigation IDs:

• QVXODBC-1752