Capturing a Database Schema

1. From the Explorer, select or mount a new directory.
2. Right click on the newly mounted directory and select New Package.
3. In the Name field of the Create New Package dialog, enter a package name.
4. If you encounter a question dialog prompting you to add the current package into the current project, select Yes.
5. From the Tools menu, select the Capture Database Schema submenu item.

   The Database Schema wizard launches.

6. In the first panel of the wizard, enter a name in the name field and select the directory Package you just created.
7. Select Next.
8. In the second panel of the wizard, select New Connection if you wish to connect to a new database. Select Existing Connection if you already have an existing database connection.
9. Enter the following data:

   Name: select the database type from the selection list
   Driver: identify the type of driver you are using
   Database URL: identify the full URL for the database connection. For example, if you are connecting to an Oracle driver the URL would be: jdbc:oracle:thin:@<hostname>:<portnumber>:<servicename>
   User Name: <yourusername>
   Password: <yourpassword>

10. Select Finish. A database schema status dialog appears.

    The schema and database tables are created under the package name you selected.