This tutorial uses the open source Derby database. In this chapter, you connect to a Derby database and create the table to be accessed. Alternatively, you can connect to a database of one of the following kinds: Cloudscape, DB2® UDB, Informix®, Oracle, or SQL Server. If you prefer to use one of those databases, review the following help topic: Creating an SQL database connection. In any case, create the table described in this lesson.
To set up the Derby database for your application, use the Data perspective, which is a workbench perspective and different from the EGL Data view.
To connect to the database:
While in the Data perspective, you can write an SQL script to create a table in the database.
In the next lesson, you start writing application code.