 | Level: Intermediate Robi Sen (rsen@department13.com), Freelance Writer, Department13
29 Nov 2005 Learn how to use Eclipse and the SQLExplorer plug-in to connect to any database that supports a JDBC driver. These tools allow you to view database schemas, view table data, add and edit table data, and write, edit, and execute SQL. You will also learn how to use Azzurri Clay to create Entity Relationship Diagrams (ERDs), reverse-engineer databases, add tables, edit tables, delete tables, edit relationships, add indexes, and change your underlying data model into different SQL dialects.
Prerequisites
You should be familiar with basic concepts in Eclipse, as well as SQL and database administration.
System requirements
You will need the following tools:
-
Eclipse V3.1
- Download the latest version of Eclipse. It's possible to use V3.0 with some changes, but this article will not cover V3.0.
-
SQLExplorer V2.2.4
- Download SQLExplorer, the Eclipse IDE plug-in for database query/schema viewer for nearly any kind of JDBC database.
-
Azzurri Clay V1.2.0 (freely available Core edition)
- Download Azzurri Clay, a database design tool that runs as a plug-in in Eclipse. It offers a user interface for designing database models graphically.
-
Graphical Editor Framework V3.1.1
- Download the Graphical Editor Framework V3.1.1 Runtime.
-
Apache Derby 10.1
- Download Apache Derby V10.1. Alternatively, download Cloudscape V10.1 from IBM. Cloudscape is an IBM-supported version of Derby.
This tutorial will be done using Windows XP, but with minor changes, everything should work on Linux, Mac OS X, or Solaris. And you will need to set up Eclipse V3.1, SQLExplorer, Azzurri Clay, and Apache Derby V10.1 before we begin. Detailed instructions are in the tutorial.
Duration
Under two hours
Formats html, pdf
| | | |
