To create, copy, or connect to a repository based on Oracle databases,
provide the following information:
- In the ProjectConsole repository information:
- Copy from repository list: Select the source repository
to copy.
- New repository name field: Enter a name for the new repository.
- In the Data warehouse information:
- Database type list: Select the Oracle 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.
- In the 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.