AWS Amazon DocumentDB

In this article, we will explain how to connect to AWS Amazon DocumentDB in Moon Modeler 4.6.6 and how to automatically create an ER diagram of an existing database.

What is AWS DocumentDB?

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. It implements the Apache 2.0 open source MongoDB 3.6 and 4.0 API by emulating the responses that a MongoDB client expects from a MongoDB server. For more information about Amazon DocumentDB, please visit https://aws.amazon.com/documentdb/

DocumentDB structure created in AWS

Please visit the following page and read the tutorial:
https://docs.aws.amazon.com/documentdb/latest/developerguide/get-started-guide.html

Creating a DocumentDB database connection in Moon Modeler

To create a new connection to the DocumentDB, click the Connections button and then click Create new connection. Enter a name for the connection and enter the DocumentDB connection string to the URL field.

  1. Start with mongodb://
  2. Specify URL
  3. Include the 27017 port number
  4. Enable the Direct connection option
  5. Keep the Retry writes option turned off

The path should be specified as:

mongodb://docdb-xxxxx.docdb.amazonaws.com:27017/
Connecting to AWS Document DB

Then go to the Authentication tab

DocumentDB authentication

In the next step, enable SSH and enter the values on the SSH tab.
Enter the host, port, username, and private key path.

SSH settings for AWS DocuementDB

Now it’s important to enable TLS. So go to the TLS tab and just enable this option and specify the path to the CA Certificate. Then make sure the Allow invalid hostnames option is enabled.

TLS settings

Now you can go back to the first tab. If you don’t know the name of the database and didn’t fill in this value directly, click on Load databases. A list of available databases will load and you can conveniently select the one you want to visualize with the drop-down element. Then select the database and save the connection settings.

Reverse engineering

A new database connection is created. Now just click on the Connect and load existing database structure link.

Connecting to AWS DocumentDB

Moon Modeler will load the information from the database and create the project including the diagram.

Editing connection properties

If you need to optimize the speed of reverse engineering, or if you have data without references in the structure, you can change the database connection Settings and run reverse engineering again.

For more information visit page Database connections

Creating documentation for Document DB

Once you have successfully created a project, you can add logical information to it, such as labels, set captions to references, specify estimated sizes, and add other important information to the project that is useful to document or use when communicating with others. You can generate an interactive HTML report for these purposes, or export the diagram to PDF.

Forward engineering and script generation

Another option you have is to generate validation scripts for your DocumentDB schema design.

Get started today and try Moon Modeler

Download