Other Databases

You will need a suitable JDBC driver (Java Database Connectivity Driver) to connect to your database.  This driver sends your SQL
 calls to the database and returns the results to you.

JDBC Driver Basics: Type 3 or Type 4
Type 3 drivers require a jdbc server to be setup and started, generally on the system where the database resides.  The jdbc driver is setup on a client machine and connects to this jdbc server.  This server will then transmit SQL
 calls to the database. Some servers can be started using simple batch files or scripts. However, some servers may need to be started using Java.
Type 4 drivers allows for direct connection between Automize and the database.  This is easier to setup than a type 3 driver.  Hence, it is preferable to use a type 4 driver if available.  These drivers are generally provided by the database vendors themselves.

Step 1. Download Driver to the jre/lib/ext folder
Go to your database website. Many database vendors will also have free Java JDBC drivers to access their databases.  Try and find a page for Java JDBC driver downloads.  Download the driver from there.

If the database vendor does not provide a JDBC driver, you can search for JDBC drivers for your database at the Java website:
http://industry.java.sun.com/products/jdbc/drivers
http://www.javasoft.com/products/jdbc/index.html

The JDBC driver file will be either a .zip or .jar file.  This driver file may be packaged along with documentation, examples etc.. in an enclosing zip or jar file.  Do not confuse the actual JDBC driver file with the enclosing package provided by the vendor.

You need to place the JDBC driver in the following 'ext' folder below depending on your installation method.  If the ext folder does not exist, create it.
For installs including JVM : ...Automize/jre/lib/ext
For installs without JVM : ...jre/1.3/lib/ext or JDK1.3/jre/lib/ext etc.. depending on your system.  

Step 2. Shutdown and Restart Automize

Step 3. Driver Class Name
This will be provided in the driver documentation.

Step 4. Database Url
The Url has to be constructed using the syntax as defined by the driver documentation.

Step 5. Test the Connection
Hit the Test the Connection button.  If everything was setup correctly, you will see some database information.