Skip to content

Latest commit

 

History

History
205 lines (140 loc) · 8.8 KB

destination_oracle.md

File metadata and controls

205 lines (140 loc) · 8.8 KB
page_title subcategory description
airbyte_destination_oracle Resource - terraform-provider-airbyte
DestinationOracle Resource

airbyte_destination_oracle (Resource)

DestinationOracle Resource

Example Usage

resource "airbyte_destination_oracle" "my_destination_oracle" {
  configuration = {
    encryption = {
      tls_encrypted_verify_certificate = {
        ssl_certificate = "...my_ssl_certificate..."
      }
    }
    host            = "...my_host..."
    jdbc_url_params = "...my_jdbc_url_params..."
    password        = "...my_password..."
    port            = 1521
    raw_data_schema = "...my_raw_data_schema..."
    schema          = "airbyte"
    sid             = "...my_sid..."
    tunnel_method = {
      ssh_key_authentication = {
        ssh_key     = "...my_ssh_key..."
        tunnel_host = "...my_tunnel_host..."
        tunnel_port = 22
        tunnel_user = "...my_tunnel_user..."
      }
    }
    username = "...my_username..."
  }
  definition_id = "28ddc2bd-35a7-4a51-966c-b9e88351add3"
  name          = "...my_name..."
  workspace_id  = "6900342e-4f38-4480-a5e0-1dce84f57ee6"
}

Schema

Required

  • configuration (Attributes) (see below for nested schema)
  • name (String) Name of the destination e.g. dev-mysql-instance.
  • workspace_id (String)

Optional

  • definition_id (String) The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.

Read-Only

  • created_at (Number)
  • destination_id (String)
  • destination_type (String)
  • resource_allocation (Attributes) actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level. (see below for nested schema)

Nested Schema for configuration

Required:

  • host (String) The hostname of the database.
  • sid (String) The System Identifier uniquely distinguishes the instance from any other instance on the same computer.
  • username (String) The username to access the database. This user must have CREATE USER privileges in the database.

Optional:

  • encryption (Attributes) The encryption method which is used when communicating with the database. (see below for nested schema)
  • jdbc_url_params (String) Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
  • password (String, Sensitive) The password associated with the username.
  • port (Number) The port of the database. Default: 1521
  • raw_data_schema (String) The schema to write raw tables into (default: airbyte_internal)
  • schema (String) The default schema is used as the target schema for all statements issued from the connection that do not explicitly specify a schema name. The usual value for this field is "airbyte". In Oracle, schemas and users are the same thing, so the "user" parameter is used as the login credentials and this is used for the default Airbyte message schema. Default: "airbyte"
  • tunnel_method (Attributes) Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use. (see below for nested schema)

Nested Schema for configuration.encryption

Optional:

  • native_network_encryption_nne (Attributes) The native network encryption gives you the ability to encrypt database connections, without the configuration overhead of TCP/IP and SSL/TLS and without the need to open and listen on different ports. (see below for nested schema)
  • tls_encrypted_verify_certificate (Attributes) Verify and use the certificate provided by the server. (see below for nested schema)
  • unencrypted (Attributes) Data transfer will not be encrypted. (see below for nested schema)

Nested Schema for configuration.encryption.native_network_encryption_nne

Optional:

  • encryption_algorithm (String) This parameter defines the database encryption algorithm. Default: "AES256"; must be one of ["AES256", "RC4_56", "3DES168"]

Nested Schema for configuration.encryption.tls_encrypted_verify_certificate

Required:

  • ssl_certificate (String, Sensitive) Privacy Enhanced Mail (PEM) files are concatenated certificate containers frequently used in certificate installations.

Nested Schema for configuration.encryption.unencrypted

Nested Schema for configuration.tunnel_method

Optional:

Nested Schema for configuration.tunnel_method.no_tunnel

Nested Schema for configuration.tunnel_method.password_authentication

Required:

  • tunnel_host (String) Hostname of the jump server host that allows inbound ssh tunnel.
  • tunnel_user (String) OS-level username for logging into the jump server host
  • tunnel_user_password (String, Sensitive) OS-level password for logging into the jump server host

Optional:

  • tunnel_port (Number) Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

Nested Schema for configuration.tunnel_method.ssh_key_authentication

Required:

  • ssh_key (String, Sensitive) OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
  • tunnel_host (String) Hostname of the jump server host that allows inbound ssh tunnel.
  • tunnel_user (String) OS-level username for logging into the jump server host.

Optional:

  • tunnel_port (Number) Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

Nested Schema for resource_allocation

Read-Only:

Nested Schema for resource_allocation.default

Read-Only:

  • cpu_limit (String)
  • cpu_request (String)
  • ephemeral_storage_limit (String)
  • ephemeral_storage_request (String)
  • memory_limit (String)
  • memory_request (String)

Nested Schema for resource_allocation.job_specific

Read-Only:

  • job_type (String) enum that describes the different types of jobs that the platform runs. must be one of ["get_spec", "check_connection", "discover_schema", "sync", "reset_connection", "connection_updater", "replicate"]
  • resource_requirements (Attributes) optional resource requirements to run workers (blank for unbounded allocations) (see below for nested schema)

Nested Schema for resource_allocation.job_specific.resource_requirements

Read-Only:

  • cpu_limit (String)
  • cpu_request (String)
  • ephemeral_storage_limit (String)
  • ephemeral_storage_request (String)
  • memory_limit (String)
  • memory_request (String)

Import

Import is supported using the following syntax:

terraform import airbyte_destination_oracle.my_airbyte_destination_oracle ""