Rational ProjectConsole Maintenance
Tool Help
Provide the following information about the Oracle databases
that contain the data you want to migrate.
In the
Data warehouse information:
- Database type list: Select the database type.
- Database server field: Enter the machine name
of the server where the Oracle database is running.
In the
Schema repository:
- SID (Oracle System Identifier) field: Enter the
name of the database instance that will be used for the schema repository.
- Username field: Enter the user name required to
log in to your Oracle schema repository.
- Password field: Enter the password required to
log in to your Oracle schema repository.
In the
Data warehouse:
- SID (Oracle System Identifier) field: Enter the
name of the database instance that will be used for the data warehouse.
- Username field: Enter the user name required to
log in to your Oracle data warehouse.
- Password field: Enter the password required to
log in to your Oracle data warehouse.
Database connection options:
When you are creating either a new schema repository or user database with
Oracle, the Connect Options field displays LOB_TYPE=CLOB. CLOB stands
for Character Large Object and is the default value. An alternate selection
is LONG. However, CLOB is Oracle's preferred method for storing large objects.
It simplifies the way database administrators set up searching on multiline
text fields.
You can also use the Connect Options field to change
the port number. If the port number of the database is different from the
default for Oracle, which is 1521, then the port number should be entered
in this field, in the form PORT=port_number.