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: KB0076211

calendar_today

Updated On:

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

Description

This Article is to explain how to Connect AWS DocumentDB using TIBCO ActiveMatrix BusinessWorks Plug-in for MongoDB.

Issue/Introduction

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

Environment

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

Resolution

Step-by-step guide:
  1. Create a new parameter group in Amazon DocumentDB with "tls" and "tls_monitor" disabled. Launch Amazon DocumentDB Cluster with the parameter group just created.
  2. Launch a new EC2 machine in the same VPC as DocumentDB instances cannot be accessed from outside.
  3. SSH into the EC2 machine and install a mongo shell so that you can connect to the DocumentDB instance from EC2. Follow the instructions on https://docs.aws.amazon.com/documentdb/latest/developerguide/getting-started.connect.html
  4. Create a sample database and sample collection for testing later.
  5. 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
  6. To run the BusinessWorks on the local machine, it needs SSH tunnel to the EC2 instance so it is possible 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
  7. Create a MongoDB shared resource in BW as shown in the screenshots below:
User-added image
User-added image

Notes:
Amazon DocumentDB implements the Apache 2.0 open source MongoDB 3.6 API. So TIBCO ActiveMatrix BusinessWorks Plug-in for MongoDB 6.2.1 or later is required because it supports MongoDB 3.6.x.
 

Attachments

How to Connect AWS DocumentDB using TIBCO ActiveMatrix BusinessWorks Plug-in for MongoDB get_app
Powered by Wolken Software