Chapter 5. Setting up Database Support

Table of Contents

Adding a New Database Type
Defining the JDBC Driver

Creating a New Database Connection
Adding or Removing Database Connections for a Project
Modifying or Deleting Database Connections

There are many features within Power*Architect that involve connecting to a database, such as reverse and forward engineering. Power*Architect allows you to use any JDBC- or ODBC-accessible source database. For more information on supported databases, see the section called “Supported Database” .

Connecting to a database with Power*Architect involves the following steps:

Define general settings and drivers for the database platform you plan to connect to (such as SQL Server or Oracle). For more information, see the section called “Setting up Database Types” .
Create a connection to a specific database server. This connection uses the general settings and drivers you have configured for the database platform. For more information, see the section called “Setting up Database Connections” .

Supported Database

Power*Architect provides full or partial support for the following database platforms.

Database	Support Notes
Oracle	Fully supported.
SQL Server	Fully supported.
PostgreSQL	Fully supported.
MySQL	Fully supported.
IBM DB2	Partial support; needs more testing.
HSQLDB	Works; used in samples.
Derby	Preliminary support exists. Reverse engineering databases in Derby 10.3.2 or later is possible. Derby-specific forward engineering is not yet available; however, you can try using the forward engineering support for another platform such as MySQL or HSQLDB. Please post to our web support forum if you are interested in forward engineering your data models to Derby.