SSH or SSL/TLS database connections

In Luna Modeler and Moon ModelerProfessional editions, you can create both basic database connections and secure SSH/SSL/TLS database connections. To learn how to create a new database connection, see Database connections.

To create a secure connection, just set the options on the SSH and SSL/TLS tabs:

SSH settings

SSH settings

SSL/TLS settings

SSL or TLS settings

Once you create this type of connection, the item will be highlighted in green in the list of connections, so you can easily distinguish a secure connection from a classic connection.… Read the rest

AWS Amazon DocumentDB

In this article, we will explain how to connect to AWS Amazon DocumentDB in Moon Modeler and how to automatically create a 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.… Read the rest

Heroku Postgres and ER diagrams

How to create ER diagram of PostgreSQL database running in Heroku? With Luna Modeler, the process is simple. Just create a database connection, retrieve the information from Heroku Postgres and create a project containing the ER diagram. But let’s start one step at a time.

What is Heroku and Heroku Postgres?

Read the rest

Database connections

To manage your database connections, click the Connections button on the main toolbar.

Connections - main toolbar

Creating a new database connection

Click the button Create a new connection to open a modal form. Select the database platform, enter the connection name and connection details.

The settings are specific to each supported platform.

If you want to list all available databases, go back to tab Server and click Load databases.… Read the rest

How to connect to MongoDB Atlas?

Read how to create a connection to your MongoDB Atlas cluster, connect to the MongoDB database, and visualize your data structure in form of an ER Diagram.

You can create a new connection to MongoDB databases easily. (The process is described step by step in our documentation.) A quick summary follows:

Step 1 – Navigate to section Connections.… Read the rest