InterBase database Modeling/Prototyping within the ControlCenter Environment

By: Shaunak Mistry

Abstract: Connect to an InterBase database with ControlCenter in just a few, easy steps.

Borland® InterBase® is a developer-friendly RDBMS that supports the rapid development and deployment of complex business applications. InterBase represents the strong deployment component of the Borland strategy to deliver best-of-breed products to support every milestone of the application life.

Borland® ControlCenter® simplifies and integrates the analysis, design, implementation, deployment, and debugging of complex applications. Developers using it for the first time often experience the kind of dramatic increase in productivity that they experienced when they first used a good, integrated development environment like Delphi® or JBuilder®. Developers building applications that rely on databases with complex schema and tables will love the way ControlCenter lets them visualize database layout and alter that layout from within a robust, design time environment.

The setup routine outlined below helps you connect to an InterBase database with ControlCenter in just a few, easy steps.

What is needed

  1. InterBase (7.0 or higher preferred)
  2. InterClient (3.0 or higher preferred)
  3. ControlCenter 6.

Steps to setup InterBase

  1. Copy the interclient.jar to the ControlCenter install's lib directory, i.e. if the install directory is "E:TogetherSoftTogether6.0.1" then the interclient.jar should be copied to "E:TogetherSoftTogether6.0.1lib" directory.
  2. Start ControlCenter
  3. Select new project and create it or use a pre-existing project
  4. Select Tools | setup, Set up DBMS Server, this will bring up a profile information dialog box.

  5. Fill in the Profile information for the InterBase server and InterClient driver, for "JDBC driver" fill in "interbase.interclient.Driver". Fill in the location of the interclient.jar file for the "Driver location" if you followed the instruction from above this should be the install lib directory. Change the "URL Pattern" to "%prefix%//%host%/%database%" (we do not need the @ or the port). Point the "Database" to the correct InterBase database path e.g. "e:testbeddatabaseemployee.gdb".
  6. Add the "User name" and "Password" to be used to access the InterBase database. The filled in default profile will look as below:

  7. Note that the profile name is still grayed out you will get a chance to fill this out later. Just hit Ok.
  8. This will now bring up the Set up DBMS servers first menu. Fill in the "Server Name"
  9. Hit the Add next to the Connection Profile, this will bring up our default profile, now we can name this profile whatever we want I have set the "Profile name" to "employee_ib" and change any information we want like the name and location of the database, User name etc.
  10. Hit test connection once all the information has been filled in correctly, if all the information is correct you should get a success dialog.
  11. Hit Ok for the profile menu.
  12. A filled in Set up DBMS server (step 1) is shown here; Hit Next, for the purpose of this basic setup.

  13. Hit Finish and you are now ready to interact with InterBase from within the ControlCenter environment.

  14. A screen shot of ControlCenter working with "Employee.gdb"

Control Center will let you create an Entity-Relationship Diagram from scratch, but you can get a jump-start by importing one based on the JDBC connection to a database.

Now you can modify, add, remove tables, and attributes. Add relationships and contrains.

Finally you can either generate a new database based on the modified diagram or generate a SQL DDL script to run.

Server Response from: ETNASC03