You can import application data from a database into JViews Diagrammer provided that the database is compliant with the JDBC API. The database must provide a JDBC driver and be accessible through SQL queries. For example, an SQLite® database file ( .db ) can be used; the driver for SQLite is called the SQLite JDBC driver.

The following figure shows the initial Arizona database in the ArizonaData.db file as loaded in Importing data from a database.

A database contains tables of columns and rows. Each row in a table represents an object in the data model. Each column in a table represents an attribute.

Nodes and links must be loaded from separate tables.

You must define a mapping between the columns in the tables and the properties proposed by the Designer in the New Diagram Wizard. Some columns may be unmapped and therefore not used in the diagram.