Configuring the ODS Database Connection
Use the ODS Database Connection screen to configure the Oracle connection settings for the ODS database instance:
- In the Oracle Database Connection section:
- In the Host Name field, enter the server machine name or IP address where you installed the database.
- In the Port Number field, enter or verify the port number for your database.
The default for Oracle is 1521.
- Choose the Service Name or SID option. Enter the Service Name or SID.
- In the Database Credentials section, enter the Oracle system username and password:
- In the Username field, enter or verify your DBA user name that has DBA privileges for the ODS database. The default name is SYSTEM.
- In the Password field, enter the password for the DBA user.
- In the New User section, enter the connection information for the table owner:
- In the Username field, enter or verify the ODS user name. This user will own the ODS tables.
- In the Password and Confirm Password fields, enter a password for the ODS user.
- Click Next.