There are several prerequisites to run the SDM GUI on a machine:
If using an Oracle database, the Oracle JDBC driver must be downloaded and placed in the $ESEC_HOME/lib (UNIX) or %ESEC_HOME%\lib (Windows) directory. As of the print date of this document, this file could be found at the following URL: http://otn.oracle.com/software/tech/java/sqlj_jdbc/index.html. This file, typically called ojdbc14.jar, will be installed by default on the machine that hosts the Sentinel DAS component.
The user must know the following information:
Name and password for the Sentinel Database User (esecdba by default)
Database host server
Database (instance) name
Port used for database communications (1521 by default for Oracle and 1433 by default for SQL Server)
To start SDM GUI on UNIX:
Login to the UNIX box as a member of the esec group (for example: esecadm).
Go to $ESEC_HOME/sdm
Enter the following command line:
./sdm
To start SDM GUI on Windows:
Click Start > Program Files > Sentinel > Sentinel Data Manager.
NOTE: To run the SDM from the command line, see the SDM Command Line section in this document.
To connect to the Database:
Log into the machine with SDM installed.
NOTE: If the Sentinel Database Administrator account uses Windows Authentication, you must log into the SDM machine using the Sentinel Database Administrator account.
Start the SDM GUI using the appropriate procedure (for Windows or UNIX).
Select the database type (Oracle or MSSQL).
Specify the Database instance name used during the Sentinel database installation. .
Specify the Database Host (hostname or IP address).
Specify the port used for database communications.
If using SQL Server authentication, specify the Sentinel Database Administrator username and password.
NOTE: If you choose Windows Authentication, you will be authenticated to the MS SQL database as the user you are currently logged into Windows as (i.e.- single sign-on).
For Oracle:
For Windows:
NOTE: If you select to save your connection settings, the settings are saved to the local sdm.connect file. By default the sdm.connect file is located in $ESEC_HOME/bin directory or %ESEC_HOME%\bin folder. Next time you start the GUI, the connection settings will be re-populated from the sdm.connect file. This file can be used when running SDM from the command line.
Click Connect. The SDM is now ready for use.