Oracle connection

Oracle is a relational database management system (RDBMS) that holds a significant presence in the data management landscape. Recognized for its robustness, scalability, and performance. You can seamlessly integrate and utilize Oracle within the Data Integration data integration platform.

Oracle compatibility versions

River modes	Versions supported	Support for managing schema drift
Standard Extraction	Versions 11g and Above	Yes
Change Data Capture	Versions 11g and Above	Yes

Prerequisite

To connect to Oracle, you must whitelist our IPs.

Singletenant vs. multitenant database architecture in Oracle

In Oracle, the architectural approach can significantly impact the efficiency, scalability, and resource utilization of the system. Choosing between a Singletenant and Multitenant architecture is crucial.

Singletenant architecture

A Singletenant architecture, also known as a traditional or non-CDB (Container Database) architecture, involves the creation of standalone Oracle databases for each application or business unit. Each database operates independently, with its dedicated set of memory, processes, and data files. In this topology, there is no shared infrastructure or resources between databases.

Multitenant architecture

A Multitenant architecture is built on the concept of a CDB (Container Database) that can host multiple Pluggable Databases (PDBs) within a shared infrastructure. The CDB contains common resources, while each PDB represents a distinct, isolated database within the shared container.

Establishing a connection

Procedure

1. Navigate to the Data Integration Account.

2. Click Connections and select + New Connection.

3. Choose Oracle.

4. Enter the Connection Name.

5. Choose your Database Architecture.

   • Single-Tenant
   • Multi-Tenant (CDB/PDB).

6. Enter your Host name.

7. Enter the Port (typically 1521).

8. Enter the name of your Database.

9. Select whether to connect using the System Identifier (SID) or Service Name.

• System Identifier (SID) - Ensure that you enter the distinct name that uniquely identifies your instance or database in the Database field.
• Service Name - Ensure that you input the TNS alias name used for remote connection to your database in the Database field.

10. Enter your Username and Password.
11. Click Test Connection to verify your connection is up to the task. If the connection succeeded, you can use this connection in Data Integration.

SSH (Optional)

Secure Shell Protocol (SSH) is used to provide secure and encrypted access to internal databases from Data Integration servers to retrieve data.

Configure your SSH Tunnel server in your network to use SSH Tunneling via Data Integration. This server connects to your database server via the internal IP or address, and accepts SSH connections from Data Integration IPs. Data Integration uses a key file to connect to the SSH server.