Repository Database in Oracle
Fivetran HVR 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 username; grant create table to username; grant create procedure to username;
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 HVR to the Oracle database. | Database_User |
| PASSWORD | Password of the USER. | Database_Password |