Installing and
getting started with Sui
Sui
is a Java application and as such it requires a Java Virtual machine (JVM)
installed to be able to execute. Sui requires at least Java 2 Version 1.5. A
JVM can be freely downloaded from www.javasoft.com
.There are two different versions of the JVM, the JDK (Java Development kit)
and the JRE (Java Runtime environment). For Sui the JRE, that have a smaller
footprint, is sufficient. To install the JRE go to the Java soft homepage and
select the appropriate JRE for your operating system, download it and follow
the instructions to install it.
If
you intend to use Sui on a windows platform (Win 95/98/NT/2000/XP). Follow these
instruction:
· Dowload
the file Setup.exe. from www.sui.nu/setup.exe
Launch the the file and follow the instructions.
·
After the installation launch Sui from the program menu (start->Program)
If
you intend to run Sui on a “non windows” platform you have to download the jar
file directly:
o Dowload
the file Sui.jar. from www.sui.nu/Sui.jar
to a directory of your choice
o Add the
file Sui.jar to the java classpath
o
Start Sui by issuing the command java -jar Sui.jar
For
Some DBMS you have to add the JDBC driver to the classpath. This can be done
either by adding the driver to the system classpath (or by adding it from
within Sui thru the dynamic classpath feature (File->Preferneces and the
select the classpath tab)).
This
section contains a brief description on how to get started with Sui. For
Further details please refer to the user-guide available on http://www.sui.nu . To minimize the size of this
document it doesn't contain any pictures or screen-shots.
When you suucessfully have installed and started Sui the next step is to
establish a connection to your database:
Select
File->Available JDBC resources, If you, for example want to access a
database that is defined as a ODBC data source on your machine and the name of
the data source in ODBC is SAMPLE:
· Select
JDBC/ODBC from the sample Driver list
· Click
the left button
· Select
JDBC/ODBC from the URL sample List
· Click
the left button,
· Change
the text in the URL text field from jdbc:odbc:<dbname> to
jdbc:odbc:SAMPLE
·
Click the apply button followed by CANCEL to return to the Query window
The
Driver and the URL are now selectable from the driver and the URL list in the
query window
To
connect to a database select the driver and the URL in the driver and the URL
lists in the query window, if necessary also enter userid and the password that
will be used for the connection (If this is necessary or not depends on the
underlying database and the security setting defined for it). Click
Options->Connect or select the connect Icon on the toolbar, or enter ctrl-d
to connect to the database.
For
more details check the User guide http:\\www.sui.nu\SuiUg061b.pdf
or the Q and A section http:\\www.sui.nu\SuiQuAn.html
or the database specific sectionds http:\\www.sui.nu\DB2.html
http:\\www.sui.nu\ORACLE.html