Oracle

About

Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is commonly used for running online transaction processing (OLTP), data warehousing (DW), and mixed (OLTP & DW) database workloads.

Available Tools

• oracle-sql Execute pre-defined prepared SQL queries in Oracle.

• oracle-execute-sql Run parameterized SQL queries in Oracle.

Requirements

Database User

This source uses standard authentication. You will need to create an Oracle user to log in to the database with the necessary permissions.

Oracle Instant Client (OIC)

The underlying database driver requires the Oracle Instant Client libraries to connect to the database. These libraries must be installed on the machine where the application is running.

After installing the client, ensure the library path is correctly configured for your operating system (e.g., by setting the LD_LIBRARY_PATH environment variable on Linux or adding the directory to the PATH on Windows) so the application can find the necessary files at runtime.

Connection Methods

You can configure the connection to your Oracle database using one of the following three methods. You should only use one method in your source configuration.

Basic Connection (Host/Port/Service Name)

This is the most straightforward method, where you provide the connection details as separate fields:

• host: The IP address or hostname of the database server.
• port: The port number the Oracle listener is running on (typically 1521).
• serviceName: The service name for the database instance you wish to connect to.

Connection String

As an alternative, you can provide all the connection details in a single connectionString. This is a convenient way to consolidate the connection information. The typical format is hostname:port/servicename.

TNS Alias

For environments that use a tnsnames.ora configuration file, you can connect using a TNS (Transparent Network Substrate) alias.

• tnsAlias: Specify the alias name defined in your tnsnames.ora file.
• tnsAdmin (Optional): If your configuration file is not in a standard location, you can use this field to provide the path to the directory containing it. This setting will override the TNS_ADMIN environment variable.

Example

sources:
    my-oracle-source:
        kind: oracle
        # --- Choose one connection method ---
        # 1. Host, Port, and Service Name
        host: 127.0.0.1
        port: 1521
        serviceName: XEPDB1

        # 2. Direct Connection String
        connectionString: "127.0.0.1:1521/XEPDB1"

        # 3. TNS Alias (requires tnsnames.ora)
        tnsAlias: "MY_DB_ALIAS"
        tnsAdmin: "/opt/oracle/network/admin" # Optional: overrides TNS_ADMIN env var

        user: ${USER_NAME}
        password: ${PASSWORD}

Reference