Migrate the MongoDB data services to driver version 4.9.1

[Bhashinee]

Current Limitation

Current MongoDB data services use the MongoDB driver version 3.5.0 which is a very old version along with Jongo(An unmaintained library from a third party). Need to revamp the code to use the MongoDB driver version 4.9.1 whihc is the version that is being used in the latest MongoDB connector. So that the users can use data serivces MongoDB operations along with the connector.

Suggested Improvement

• Update the driver version to 4.9.1 and revamp the code. This includes adding mongodb-driver-sync, mongodb-driver-core and adding bson instead of Jongo library.

Testing

MongoDB configs(Check whether the configs are set properly in Mongo Client)

• mongoDB_read_preference
• mongoDB_ssl_enabled
• mongoDB_write_concern
• mongoDB_connectTimeout
• mongoDB_maxWaitTime
• mongoDB_socketTimeout
• mongoDB_connectionsPerHost

Operations that are supported by data services - REST

• Find
• FindOne (Need to test with query and without query {})
• insert
• Count
• Drop
• Remove
• Exists
• Update

Operations that are supported by data services - SOAP

• Find
• FindOne (Need to test with query and without query {})
• insert
• Count
• Drop
• Remove
• Exists
• Update

Odata

• Get service document
• Read metadata of the service
• Read details from the project service
• Read individual record
• Add a new record to table
• Delete record
• Update record
• Top option
• count option
• orderby option

Test with connector

• Test data services along with MongoDB connector

Version

MI 4.4.0