Database Setup




The Database set-up can be varied each time a test run is configured. However once a Test Run has been configured it may be run many times.


Since this is carried out within the TETware professional program. It is a User function, rather than an Admin function, and is common for all platforms.

(For details of the Database Admin Setup please click here)



Database Setup Tab

To setup the database connection the user must be have TETware professional open and an active Test Run. Open that Test Run by double clicking on it, and then click on the Reporting icon. Select the Database Setup tab.

For details of the Database tab please click here.


Database Connection:

This refers to the database connection in use. Consideration is given to the way in which TETware professional communicates with the user's database.

For example odbc:odbc:TETbase can be used to connect to a Microsoft Access database. Other examples that could be used depending on the database chosen are:


Database Connection
MySQL jdbc:mysql://localhost/TETbase
Oracle jdbc:oracle:thin@localhost:1521:TETbase
Informix jdbc:Informix:api-direct:system=tetsystem=TETbase

Database ODBC / JDBC Driver:

This field refers to the database links that are to be used.  In this case we have used the Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC) Drivers. sun.jdbc.odbc.jdbcOdbcDriver (see Figure). Others that may be used include:


Database Connection
MySQL org.gjt.mm.mysql.Driver
Oracle oracle.jdbc.driver.OracleDriver
Informix Informix.api.jdbc.JDBCDriver

Extract to Database Directly

If you want to write journal directly after execution, you can check the checkbox: Auto-write. After execution, the journal will be write to the database.



Remote Databases

If you wish to connect to a database on a different system, you may be required by that database system's security to supply a User's Name and a Password. This can be entered here so that it is not required every time the TETware professional Database Extract Tool is run.


User Name

You must have been set up as a user to access the database. Enter your user name into this field. If you do not have a database user name please see your database administrator.


Password

If access to your database requires a password, enter it into this field.





© The Open Group 1995-2002