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.
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
Name: Northwind
Use Connection String: Leave as selected
URI:
mongodb://erwinDMNoSQLUser:erwinDMNoSQLUser01@ds011429.mlab.com:11429/northwind
• 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.
• 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.
• 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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center