User guide

Repository Server Setup
2-19
Conditions for connection and an example of the settings that should be made are shown below.
Database to be connected to: Oracle9i
JDK/JRE to be used to: 1.4
JDBC driver storage directory /tmp/ojdbc14.jar and /tmp/nls_charset12.zip
# CLASSPATH=/tmp/ojdbc14.jar:/tmp/nls_charset12.zip:$CLASSPATH
# export CLASSPATH
(2) Create the operation information file
Create an operation information file in which the settings that are required for extracting the user
information are described.
Refer to 'ssoimportum' in 'Single Sign-on Operation Commands' of the Reference Manual (Command
Edition) for details of creating the operation information file.
(3) Execute the ssoimportum command
Specify the operation information file created in (2). Execute the ssoimportum command to extract the
user information and import it to the SSO repository.
Refer to 'Single Sign-on Operation Commands' in the Reference Manual (Command Edition) for details
of the ssoimportum command.
Using a CSV Data File
A large quantity of user information managed by the personnel database, may be added to the SSO
repository at system installation, or at another time. To facilitate this, a CSV data file extracted from the
personnel database can be used to add entries to the SSO repository in batch. Periodic updates of user
information may be required when personnel transfer or new employees join. In this case, a CSV data
file containing only updated information can be used to add user information to the SSO repository.
This section explains how to register user information and role configuration using a CSV data file based
on the sample CSV data file provided by Interstage Single Sign-on.
The following paragraphs explain the procedure for registering entries using the CSV data file. Refer to
the Smart Repository Operator's Guide for details of the CSV format.
Execute the irepaddrole command to register a role and irepmodifyent command to register user
information from the CSV data file. Refer to 'Smart Repository Operation Commands' in the Reference
Manual (Command Edition) for details of the command.
The CSV data file can also be used to delete or update information. Refer to the Smart Repository
Operator's Guide for details of how to delete or update information.
Note
The CSV file contains a password. Ensure that you take sufficient action to protect the CSV file.
For details about securing your data, Refer to 'Security Measures' of 'Interstage Single Sign-on' of
'Security Risks' in the Security System Guide.
Perform the following procedure to add entries using the CSV data file:
1. Extract data in CSV format from the personnel database.
2. Create a rule file.
3. Execute the role configuration import command.