Can i connect DM NoSQL to my database for reverse engineering?
erwin DM NoSQL provides a connection manager to your hosted NoSQL instances, that enables the automated creation of native NoSQL model structures, based on statistical data analysis of chosen collections.
This provides the ability to visualize and manage structures in a model driven fashion without requiring the actual data to be stored in the model.
IMPORTANT: If you are having trouble connecting to your own NoSQL instance, then the first thing to do is ensure it's actually accessible from our SaaS tool. For this, it cannot be locked down to an internal ip address, it must be accessible externally.
We have improved validation for acceptable IP addresses. Ip addresses cannot be localhost (127.0.0.1) or within the private IP address range.
You can use any NoSQL client to test this, but you must attempt to connect to your instance remotely (from outside of your corporate network) to properly simulate the platform e.g. there's no sense in using the NoSQL client on the same machine as the DB instance.
Steps to follow:
To create a connection and reverse engineer a cloud-based NoSQL instance and manage existing connections
• Access the Connection Manager
• You can access the Connection Manager, using the option in the top panel.
• to create a new connection select the
- Enter your details (You can use the details for our example if you wish. This example shows the Northwind example MongoDB database)
Use Connection String: Leave as selected
• Toggling the option, allows you to choose to use a URI connection string (seen above), or to enter connection details individually (as below).
You can choose to use an authentication source and enable SSL for the connection.
• Test the connection if you like, before trying to reverse. If successful, the icon will turn green.
- Save the Connection.
• To use a saved connection, or create a new one on the fly, select the desired NoSQL database icon from the action menu in the bottom right hand corner of the Home page.
- Select the drop down list and select the saved connection you wish to use (or use the plus button to create a new connection to a hosted DB). Select Continue.
- If a successful connection is made to the hosted database, an option will show the Collections found, and you can select which ones you would like to reverse engineer. Click Continue.
• Name the model and select Finish to complete.
After a statistical analysis on the dataset, a 'schema' visualization will be created and presented as a card on the Home page. The data itself is not brought into the tool.
Reversed models have a different icon on them on the home page…
• The user will be updated via email and via an in-tool notification once the reverse engineering is complete
• The visualization will show the nested documents within collections. This example doesn’t make use of denormalization yet, so is a prime candidate for improvement and team collaboration.