Repository Database in Oracle - DSS 6 | Data Source Solutions Documentation
Documentation: Repository Database in Oracle - DSS 6 | Data Source Solutions Documentation
Repository Database in Oracle
Data Source Solutions DSS allows you to create a repository database (schema) in Oracle. The repository database (schema) can be located inside an Oracle instance on the hub machine, or it can be located on another machine and connected using a TNS connection. The Repository Database section in Capabilities (6.1.0, 6.1.5) lists the supported Oracle versions that can be used as a repository database.
Grants for Repository Database
The following grants are required for the repository database in Oracle:
grant create session to <em>username</em>;
grant create table to <em>username</em>;
grant create procedure to <em>username</em>;
Repository Database Connection
This section describes the details required for connecting to the repository database in Oracle:
| Field | Description | Equivalent Location Property |
|---|---|---|
| ORACLE_HOME |
Directory path where Oracle is installed. Example: D:\oracle or distr/oracle |
Oracle_Home |
| Local connect to database | Connect to Oracle database using local connection. | |
| SID | Unique name identifier of the Oracle instance/database. Example: ORA1900 |
Oracle_SID |
| Oracle TNS | Connect to Oracle database using TNS (Transparent Network Substrate). | |
| ORACLE TNS | Connection string for connecting to the Oracle database using TNS. The format for the connection string is host:port/service_name. Alternatively, you can add the connection details into the clients tnsnames.ora file and use that net service name in this field. This method requires easy connect enabled |
Oracle_TNS |
| USER | Username for connecting DSS to the Oracle database. | Database_User |
| PASSWORD | Password of the USER. | Database_Password |