KB485030: How to connect to MongoDB by JDBC driver in MicroStrategy 2021 Update 2 with different port numbers

Description

For MongoDB, server name and port number information are stored in the schema file. Therefore, when reusing this schema file to connect to the same MongoDB server with different port numbers, the following error is returned. 
The connection options used to open the database do not match the options used to create the database. 

Solution 

Windows Intelligence server

• Go to ODBC Administrator > ODBC MongoDB Driver Setup > Advanced.
• In the Extended Options field, set the parameter

  AllowPortNumber=1

  .
  

• Connection string format:
  

  JDBC;DRIVER={com.Strategy.jdbc.mongodb.MongoDBDriver};URL={jdbc:Strategy:mongodb://11.11.11.11:27017;DatabaseName=A;SchemaDefinition=C:\Users\Administrator\Downloads\schema\;ValidateServerCertificate=false;EncryptionMethod=noEncryption;AllowPortChange=true}

  
   
  

Linux Intelligence server

• Open the

  odbc.ini

  config file. 
• Add the parameter

  AllowPortNumber=1

  .
  

• Connection string format:
  

  JDBC;DRIVER={com.Strategy.jdbc.mongodb.MongoDBDriver};URL={jdbc:Strategy:mongodb://11.11.11.11:27017;DatabaseName=A;SchemaDefinition=/home/ec2-user/schema/;ValidateServerCertificate=false;EncryptionMethod=noEncryption;AllowPortChange=true};