Digital Gridworks Studio Documentation Center Borderland Consulting Inc.

Cart | Search | Site Map

Home > Our Products > Digital Gridworks™ Studio > Documentation > Database Diagram Editor

Table of Contents

Managing Connections

Querying Data From The Connection Tree

SQL Editor

Table Designer

Data Migration Services Manager

Database Diagram Editor

Compare Table Definitions

Advanced Data Search

Application Extensions

Extra Information

Developer's Guide

Database Diagram Editor

The Database Diagram Editor provides an interface in which you can interactwith database structures visually in order to understand the model better. The editorcan create a database diagram from any current connection. It relies on foreign keyinformation stored in the target database in order to set up visual relationships betweentables. You can create new tables and edit existing tables directly from the diagram.

Creating a Diagram

To create a diagram, select New Diagram from the application Enterprise Services menu. Pick theconnection and database to use for this diagram. Once the diagram editor connects to the database,you will be prompted to select a list of tables that you would like on the diagram. You can alsoadd and remove tables later on.

Editing a Diagram

You can move and resize tables by clicking on them. The bottom-right corner contains a hotspot to resize tables. If you choose to set a grid on the diagram (which is located under Page Settings) youcan have the tables snap to the grid as you move them. Using the context menu for each table, youcan hide and show columns as well as launch the table editor.

The foreign key relationship arrows are calculated based on the data that is provided by the JDBC driver.If you wish to add foreign key relationships to the diagram, first edit the database to add them as needed,and then refresh the tables that are affected (the table context menu contains a Refresh option).

Designing Tables

To edit an individual table, right-click on the table to get the context menu and then select Edit Table. This will launch the table editor. You can make your desired changes in the table editor, and once you closeit, the diagram editor will refresh that current table from the database.

Printing a Diagram

To print a diagram, first use the Page Settings dialog to set the page margins. Then you can print the pageusing the Print menu. As of version 2.x, the pages are sent to the printer in raster format. On some systems thatonly provide low resolutions for raster image printing, these printouts may not be as crisp as we would like. Once printing support improves we will be switching to a vector printing model.

Exporting a Diagram

Alternatively, you can export an image of the diagram. Choose Export from the menu and then choose the filetype that you would like to export. Not all file types are available for all platforms. Also, if you are exporting a very large diagram, you may run out of memory and receive an Out Of Memory exception.