#Model xtractor software#

Provide your own table and column aliases, and relationship names.

Relationship Properties showsР’В how individual join conditions of selected connectors propagated to define the new chain. A new derived chain relationship appears here between Customers and Suppliers, to give you all suppliers who delivered the orders for each customer. Easily create custom chain relationships, without actually changing the connected database at all! Create the chain from two or more selected connectors. Bypass intersection tables and show conceptual many-to-many connectors between shapes. It lets you hide, collapse, or minify table/view shapes.

#Model xtractor software#

Visualize and customize your linked columns.Р”В«uilt-in chains are automatically created for any many-to-many relationship, bypassing the intersection table. Model Xtractor is a software utility designed to inspect modeling for traditional or enhanced ER models, with support for most relational database platforms.

Enhance it by dragging another table column over another. Move the mouse over connectors, shapes and items, to highlight all related elements.Р”В®asily enhance your model with custom joins, without actually changing the connected database at all! Drag one table column over another to start creating a custom join. These diagram types outline the degree of connectivity between tables, through relationships.Р”В®xpand relationships into connectors with simple drag and drop of generated relationship items.Р’В Collapse connectorsР’В back by simply removing them from the diagram. Connectors are straight lines and show no other details. Shapes have been collapsed and renderedР’В transparent. Combine the reduced but powerful set of diagram options, to generate all sorts of effects.Р”В¬ustomize a large number of simplified generated models, such as the Simple,Р’В Topological, or Graph model here. Replace physical data types with short conceptual types (numeric, string, datetime).Р”В¬ustomize a large number of rich generated models, such as the Detailed, Structural, or Relationships model here. Hide, collapse or minify table/view shapes. Generic support for dozens of relational database platforms, including Oracle, SQL Server, PostgreSQL, MySQL, Azure, Amazon Redshift, SQLite and Firebird. One-time reverse engineer, to extract information about database tables, views, columns and relationships. Hide intersection tables and show virtual many-to-many connectors between the other shapes Provide your own alternative aliases for any table and column name, without changing the database at all Virtual relationships between tables, without actually changing the databaseР”В«ypass two or more chained relationships with one single virtual join Relationships are distributed as items on each of the participating shapes drag them out to simply display as connectors Simple topologies or graphs, for large numbers of database tables Customize new or extracted ER database models, in traditional Foot Crow's or IDEF1X notationР”В®xplore and customize ER models enhanced with new features and notations (see below)Р”В¬ollapsed and minimized shapes, expandable relationship items, many-to-many relationships and plenty of other original features you'll find nowhere else