Audience
Enterprises and database developers searching for a tool to work with logical and physical data models
About DTM Data Modeler
DTM Data Modeler is a CASE tool for database developers that supports both forward and reverse engineering. It is an easy-to-use tool allowing you to work both with logical and physical data models in the form of an entity-relationship diagram. The product is intended for database architects and developers and works with data sources via the ODBC interface, which means compatibility with all modern DBMS. Along with basic model properties (sets of entities and relationships between them), the program allows you to create indexes and triggers on the physical level corresponding to the tables of the database that is modeled. The foreign key migration feature makes schema development easier and more visual and also reduces the probability of errors in the integrity of the model. The program can create database schema objects directly in the database as well as create SQL scripts corresponding to the model and taking into account the settings specified by the user.
Other Popular Alternatives & Related Software
ERBuilder
ERBuilder Data Modeler is a GUI data modeling tool that allows developers to visualize, design, and model databases by using entity relationship diagrams and automatically generates the most popular SQL databases. Generate and share the data Model documentation with your team. Optimize your data model by using advanced features such as test data generation, schema compare, and schema synchronization.
Learn more about ERBuilder
ERDPlus
A database modeling tool for creating entity relationship diagrams, relational schemas, star schemas, and SQL DDL statements. ERDPlus is a web-based database modeling tool that lets you quickly and easily create Entity Relationship Diagrams (ERDs). Works with most contemporary RDBMS tools including Oracle, MySQL, Microsoft SQL Server, PostgreSQL, Teradata, IBM DB2, Microsoft Access, and others. The notation supports drawing regular and weak entities, various types of attributes (regular, unique, multi-valued, derived, composite, and optional), and all possible cardinality constraints of relationships (mandatory-many, optional-many, mandatory-one, and optional-one). The tool supports the quick creation of foreign keys and referential integrity lines by simple click-point-connect actions. This simplifies and quickens the process of creating relational schemas. The notation distinguishes fact tables from dimension tables by using a thicker frame around fact tables.
Learn more about ERDPlus
Looker
Looker, Google Cloud’s business intelligence platform, enables you to chat with your data. Organizations turn to Looker for self-service and governed BI, to build custom applications with trusted metrics, or to bring Looker modeling to their existing environment. The result is improved data engineering efficiency and true business transformation.
Looker is reinventing business intelligence for the modern company. Looker works the way the web does: browser-based, its unique modeling language lets any employee leverage the work of your best data analysts. Operating 100% in-database, Looker capitalizes on the newest, fastest analytic databases—to get real results, in real time.
Learn more about Looker
Toad Data Modeler
Visualize database structures and better understand existing databases and relationships. Create high-quality logical and physical data models. Reverse engineer existing database structures to view them in a diagram. Generate detailed HTML, RTF or PDF reports. Create quality database structures or make changes to existing models automatically, and provide documentation on multiple platforms. Build complex logical and physical entity-relationship models, and easily reverse and forward engineer databases. Connect multiple databases natively and simultaneously, including Oracle, SAP, MySQL, SQL Server, PostgreSQL, DB2, Ingres, and Microsoft Access. Synchronize models with existing databases using Change Script Generations and Update Model features. Easily convert data structures from one database platform to another to support business migration initiatives. Easily generate detailed hyperlinked reports on existing database structures in multiple formats like HTML and PDF.
Learn more about Toad Data Modeler
Pricing
Starting Price:
$75 per year
Free Version:
Free Version available.
Free Trial:
Free Trial available.
Integrations
Company Information
DTM Data Modeler
Founded: 1998
Canada
sqledit.com/dm/index.html
Videos and Screen Captures
Other Useful Business Software
Custom VMs From 1 to 96 vCPUs With 99.95% Uptime
Live migration and automatic failover keep workloads online through maintenance. One free e2-micro VM every month.
Product Details
Platforms Supported
Windows
Training
Documentation
Live Online
In Person
Support
Phone Support
Online
DTM Data Modeler Frequently Asked Questions
Q: What kinds of users and organization types does DTM Data Modeler work with?
DTM Data Modeler works with these users and organization types: Mid Size Business, Small Business, Enterprise, Freelance, Nonprofit, Government, and Startup.
Q: What languages does DTM Data Modeler support in their product?
DTM Data Modeler supports these languages: English.
Q: What kind of support options does DTM Data Modeler offer?
DTM Data Modeler offers support via phone support and online.
Q: What other applications or services does DTM Data Modeler integrate with?
DTM Data Modeler integrates with: IBM Db2, Oracle Database, and SQL Server.
Q: What type of training does DTM Data Modeler provide?
DTM Data Modeler provides training in the form of documentation, live online, and in person.
Q: Does DTM Data Modeler offer a free trial?
Yes, DTM Data Modeler offers a free trial.
Q: How much does DTM Data Modeler cost?
Pricing for DTM Data Modeler starts at $75 per year.
