How to connect AWS DocumentDB using TIBCO ActiveMatrix BusinessWorks Plug-in for MongoDB

How to connect AWS DocumentDB using TIBCO ActiveMatrix BusinessWorks Plug-in for MongoDB

book

Article ID: KB0073090

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for MongoDB 6.2.1 or later

Description

​​​​​How to connect AWS DocumentDB using TIBCO ActiveMatrix BusinessWorks Plug-in for MongoDB

Issue/Introduction

How to connect AWS DocumentDB using TIBCO ActiveMatrix BusinessWorks Plug-in for MongoDB

Environment

Product: TIBCO ActiveMatrix BusinessWorks Plug-in for MongoDB Version: 6.2.1 or later OS: All Supported Operating Systems

Resolution

  1. Amazon DocumentDB implements the Apache 2.0 open source MongoDB 3.6 API. Hence it is needed to use TIBCO ActiveMatrix BusinessWorks Plug-in for MongoDB 6.2.1 (or later) as it supports MongoDB 3.6.x
  2. Create a new parameter group in Amazon DocumentDB with "tls" and "tls_monitor" disabled. Launch Amazon DocumentDB Cluster with the parameter group created.
  3. Launch a new EC2 machine in the same VPC as DocumentDB instances cannot be accessed from outside.
  4. SSH into the EC2 machine and install a mongo shell to connect to the DocumentDB instance from EC2. Follow the instructions on
    • https://docs.aws.amazon.com/documentdb/latest/developerguide/getting-started.connect.html
  5. Create a sample database and sample collection for testing it later.
  6. Copy the cluster URL and edit the hosts file like this:
    • 127.0.0.1 docdb-2019-10-10-06-29-12.cvihdnbch4bs.us-west-2.docdb.amazonaws.com
  7. Because the BusinessWorks is running on local machine, it is needed to use SSH tunnel to connect to the EC2 instance to access the DocumentDB instance from the local machine. Run the following command or follow the instructions at https://docs.aws.amazon.com/documentdb/latest/developerguide/connect-from-outside-a-vpc.html
    • ssh -i "your-key-pair-for-ec2.pem" -L 27017:docdb-2019-10-10-06-29-12.cluster-cvihdnbch4bs.us-west-2.docdb.amazonaws.com:27017 ec2-user@ec2-35-163-56-6.us-west-2.compute.amazonaws.com -N
  8. Now create a MongoDB shared resource in BW as shown in the screenshots below:
           User-added image