Connecting to Mongo DB from webMethods Integration Server

Pre-requisite: Download and install the BigData Drivers for Mongo DB (contact SAG sales or the account manager) and you can connect to Mongo DB via JDBC Adapter.

IS: 10.3

Mongo DB: 4.0.6

Supports:  NO_TRANSACTION and LOCAL_TRANSACTION

Limitations: This driver does not support the following features:
                    - StoredProcedure services
                    - Polling Notifications
                    - Support for XA_TRANSACTION

Make sure the Mongo DB driver is in the server classpath eg., C:\SoftwareAG103\IntegrationServer\lib\jars\mongo-db-6.0.0.jar

Connection Params: 

MongoDBDemo:MongoDBConnection Details
Connection Type webMethods Adapter for JDBC Connection
Package Name MongoDBDemo
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class wm.jdbcx.mongodb.MongoDBDataSource40
Server Name localhost
User  
Password  
Database Name demo_database
Port Number 27017
Network Protocol  
Other Properties schemaDefinition=D:\Mongo-DB\mongodb-data\schema_definition;TransactionMode=Ignore;readOnly=false;
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

Demo package "MongoDBDemo" attached.

Feel free to contact me via email or comment below if you have any questions.

Cheers,

Mahesh K Sreenivas

Senior Integration Consultant and Architect

MongoDBDemo.zip (14.4 KB)