| page_title | subcategory | description |
|---|---|---|
airbyte_source_oracle_enterprise Resource - terraform-provider-airbyte |
SourceOracleEnterprise Resource |
SourceOracleEnterprise Resource
resource "airbyte_source_oracle_enterprise" "my_source_oracleenterprise" {
configuration = {
check_privileges = false
checkpoint_target_interval_seconds = 3
concurrency = 1
connection_data = {
service_name = {
additional_properties = "{ \"see\": \"documentation\" }"
connection_type = "service_name"
service_name = "...my_service_name..."
}
}
cursor = {
read_changes_using_change_data_capture_cdc = {
additional_properties = "{ \"see\": \"documentation\" }"
cursor_method = "cdc"
debezium_shutdown_timeout_seconds = 4
initial_load_timeout_hours = 6
invalid_cdc_cursor_position_behavior = "Re-sync data"
}
}
encryption = {
unencrypted = {
additional_properties = "{ \"see\": \"documentation\" }"
encryption_method = "unencrypted"
}
}
host = "...my_host..."
jdbc_url_params = "...my_jdbc_url_params..."
password = "...my_password..."
port = 59972
schemas = [
"..."
]
tunnel_method = {
password_authentication = {
additional_properties = "{ \"see\": \"documentation\" }"
tunnel_host = "...my_tunnel_host..."
tunnel_method = "SSH_PASSWORD_AUTH"
tunnel_port = 8636
tunnel_user = "...my_tunnel_user..."
tunnel_user_password = "...my_tunnel_user_password..."
}
}
username = "...my_username..."
}
definition_id = "f5de1b25-34d6-4890-aabc-b81b1dcc0212"
name = "...my_name..."
secret_id = "...my_secret_id..."
workspace_id = "a58273eb-3c83-4b89-b731-736acd84bdaa"
}configuration(Attributes) (see below for nested schema)name(String) Name of the source e.g. dev-mysql-instance.workspace_id(String)
definition_id(String) The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.secret_id(String) Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
created_at(Number)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)source_id(String)source_type(String)
Required:
connection_data(Attributes) The scheme by which to establish a database connection. (see below for nested schema)cursor(Attributes) Configures how data is extracted from the database. (see below for nested schema)encryption(Attributes) The encryption method with is used when communicating with the database. (see below for nested schema)host(String) Hostname of the database.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)username(String) The username which is used to access the database.
Optional:
check_privileges(Boolean) When this feature is enabled, during schema discovery the connector will query each table or view individually to check access privileges and inaccessible tables, views, or columns therein will be removed. In large schemas, this might cause schema discovery to take too long, in which case it might be advisable to disable this feature. Default: truecheckpoint_target_interval_seconds(Number) How often (in seconds) a stream should checkpoint, when possible. Default: 300concurrency(Number) Maximum number of concurrent queries to the database. Default: 1jdbc_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) Port of the database. Oracle Corporations recommends the following port numbers: 1521 - Default listening port for client connections to the listener. 2484 - Recommended and officially registered listening port for client connections to the listener using TCP/IP with SSL. Default: 1521schemas(List of String) The list of schemas to sync from. Defaults to user. Case sensitive.
Optional:
service_name(Attributes) Use service name. (see below for nested schema)system_idsid(Attributes) Use Oracle System Identifier. (see below for nested schema)
Required:
service_name(String)
Optional:
additional_properties(String) Parsed as JSON.connection_type(String) Default: "service_name"; must be "service_name"
Required:
sid(String)
Optional:
additional_properties(String) Parsed as JSON.connection_type(String) Default: "sid"; must be "sid"
Optional:
read_changes_using_change_data_capture_cdc(Attributes) Recommended - Incrementally reads new inserts, updates, and deletes using Oracle's change data capture feature. This must be enabled on your database. (see below for nested schema)scan_changes_with_user_defined_cursor(Attributes) Incrementally detects new inserts and updates using the cursor column chosen when configuring a connection (e.g. created_at, updated_at). (see below for nested schema)
Optional:
additional_properties(String) Parsed as JSON.cursor_method(String) Default: "cdc"; must be "cdc"debezium_shutdown_timeout_seconds(Number) The amount of time to allow the Debezium Engine to shut down, in seconds. Default: 60initial_load_timeout_hours(Number) The amount of time an initial load is allowed to continue for before catching up on CDC events. Default: 8invalid_cdc_cursor_position_behavior(String) Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value in the mined logs. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]
Optional:
additional_properties(String) Parsed as JSON.cursor_method(String) Default: "user_defined"; must be "user_defined"
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)
Optional:
additional_properties(String) Parsed as JSON.encryption_algorithm(String) This parameter defines what encryption algorithm is used. Default: "AES256"; must be one of ["AES256", "AES192", "AES128", "3DES168", "3DES112", "DES"]encryption_method(String) Default: "client_nne"; must be "client_nne"
Required:
ssl_certificate(String, Sensitive) Privacy Enhanced Mail (PEM) files are concatenated certificate containers frequently used in certificate installations.
Optional:
additional_properties(String) Parsed as JSON.encryption_method(String) Default: "encrypted_verify_certificate"; must be "encrypted_verify_certificate"
Optional:
additional_properties(String) Parsed as JSON.encryption_method(String) Default: "unencrypted"; must be "unencrypted"
Optional:
no_tunnel(Attributes) No ssh tunnel needed to connect to database (see below for nested schema)password_authentication(Attributes) Connect through a jump server tunnel host using username and password authentication (see below for nested schema)ssh_key_authentication(Attributes) Connect through a jump server tunnel host using username and ssh key (see below for nested schema)
Optional:
additional_properties(String) Parsed as JSON.tunnel_method(String) Default: "NO_TUNNEL"; must be "NO_TUNNEL"
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 hosttunnel_user_password(String, Sensitive) OS-level password for logging into the jump server host
Optional:
additional_properties(String) Parsed as JSON.tunnel_method(String) Default: "SSH_PASSWORD_AUTH"; must be "SSH_PASSWORD_AUTH"tunnel_port(Number) Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
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:
additional_properties(String) Parsed as JSON.tunnel_method(String) Default: "SSH_KEY_AUTH"; must be "SSH_KEY_AUTH"tunnel_port(Number) Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
Read-Only:
default(Attributes) optional resource requirements to run workers (blank for unbounded allocations) (see below for nested schema)job_specific(Attributes List) (see below for nested schema)
Read-Only:
cpu_limit(String)cpu_request(String)ephemeral_storage_limit(String)ephemeral_storage_request(String)memory_limit(String)memory_request(String)
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)
Read-Only:
cpu_limit(String)cpu_request(String)ephemeral_storage_limit(String)ephemeral_storage_request(String)memory_limit(String)memory_request(String)
Import is supported using the following syntax:
terraform import airbyte_source_oracle_enterprise.my_airbyte_source_oracle_enterprise ""