How to Configure QuantumDB Eclipse plug-in

This process is more of a note for me to refer to, but feel free to use it if you want to, also. QuantumDB requires JDBC Drivers because they load from .jar files. So you will have to spend some time finding the .jars if you want to use this plug in.

There are JDBC drivers for MS SQL Server, MySQL, AS400/DB2(JTOpen), Oracle, Siebel(uses Oracle), and Teradata, that I know of.

Once found, you should copy them all to a folder on the C: Drive to make configuring quicker. You can name the folder anything you want; I call it "JDBC Drivers."

Configuring QuantumDB is a two-step process. First you map to the JDBC driver for type of database you want to use, then you configure QuantumDB to use the driver and select the database schemas you want to use; if not all of them.

Loading the JDBC Driver

1. Click into the QuantumDB perspective
2. Right-click in the Database Bookmarks tab and select New Bookmark.
3. A new Bookmark dialog box pops up. Click the Add driver... button
4. A new JDBC Driver dialog box pops up. Click the Add External Jar... button
5. An Open dialog box pops up. Find the JDBC Driver folder you created on your C: drive and select the jar file you need. (For Oracle I have used ojdbc14.jar, and for AS400/DB2 I have used the jt400.jar file from JTOpen.)
6. Back in the New JDBC Driver dialog box, select the path in the Driver Jars and click the Browse... button.
7. A Select a Driver dialog box pops-up, I always have selected the first option and clicked ok. The goal is to do what works and that has always worked for me. Do what you like here.
8. When you clicked Ok the Class name and Type fields filled in automatically, in the New JDBC Driver dialog box. Click Finish.
9. Back in the New Bookmark dialog box, select the new Oracle driver and click Next.

It is at this point where the process differs for each type of driver you configure. The driver is now loaded/mapped, but now you must configure it. Each driver has various requirements for configuration. I will comment on a few of them, and add to this entry as I configure more databases. Once you configure one, you should get the hang of it though.

Oracle and Siebel(uses Oracle Driver)

1. Inside the New Bookmark dialog box, you should have already selected a JDBC driver to use. Enter the following
   • UserId
   • Password
   • Hostname: typically the servername
   • Port: 1521 is default
   • Database name
   Click Next
2. Name: typcially the datasource name you're using
3. Click Finish

AS400 (JTOpen Driver(jt400.jar))

1. Inside the New Bookmark dialog box, you should have already selected a JDBC driver to use. Enter the following
   • UserId
   • Password
   • JDBC URL: jdbc:as400://SERVERNAME.YOURDOMAIN.COM
   Click Next
2. Name: typcially the datasource name you're using
3. Click Finish

In order to connect to a database you have configured, simply right-click a Database Bookmark and select Connect.

An Optional additional configuration is that you can have QuantumDB only disply the schemas you want to use, instead of seeing all of them.

1. Right-click on the a bookmark you have already configured and select Properties.
2. In the list on the left, select Schemas
3. Click the Show selected schemas radio button
4. You will see the Add button becomes enabled. Click it and select the schemas. You can use the SHIFT or CTRL key to select multiple schemas.
5. Click Apply if you want, then click Ok or just click Ok

You can repeat that procedure so only the schemas you need will be displayed for any database you connect to.