Oracle RAC API Configuration

Request

POST https://api.fivetran.com/v1/connections

{
  "group_id": "group_id",
  "service": "oracle_rac",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "paused": false,
  "pause_after_trial": false,
  "sync_frequency": 1440,
  "data_delay_sensitivity": "NORMAL",
  "data_delay_threshold": 0,
  "daily_sync_time": "14:00",
  "schedule_type": "auto",
  "connect_card_config": {
    "redirect_uri": "https://your.site/path",
    "hide_setup_guide": true,
    "all_fields": true
  },
  "proxy_agent_id": "proxy_agent_id",
  "private_link_id": "private_link_id",
  "networking_method": "Directly",
  "hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
  "destination_configuration": {
    "virtual_warehouse": "virtual_warehouse"
  },
  "destination_schema_names": "FIVETRAN_NAMING",
  "external_secrets_manager_id": "esm_id",
  "config": {
    "always_encrypted": true,
    "asm_staging_directory": "string",
    "cdb_database": "string",
    "cdb_password": "string",
    "cdb_user": "string",
    "connection_type": "Directly | PrivateLink | SshTunnel | ProxyAgent",
    "database": "oracledb",
    "enable_asm": true,
    "enable_symbolic_links": true,
    "enable_tde_encryption": true,
    "host": "oracleinstance.mycompany.com",
    "local_wallet_host": "string",
    "local_wallet_user": "string",
    "password": "test_password",
    "pdb_name": "string",
    "port": 1521,
    "symbolic_links_mapping": [
      {}
    ],
    "tde_wallet_password": "tde_wallet_password",
    "tunnel_host": "XXX.XXX.XXX.XXX",
    "tunnel_port": 22,
    "tunnel_user": "fivetran",
    "update_method": "BINARY_LOG_READER | LOGMINER | TELEPORT",
    "user": "test_user",
    "schema_prefix": "prefix"
  },
  "external_secrets_keys_config": {
    "password": "PASSWORD_KEY",
    "user": "USER_KEY"
  }
}

Config parameters

Name	Description
`always_encrypted`	Require TLS through Tunnel
`asm_staging_directory`	ASM staging directory path. Required when the ASM option is enabled.
`cdb_database`	Optional: CDB database name for TDE-encrypted containerized databases.
`cdb_password`	Optional: Password for the CDB user.
`cdb_user`	Optional: CDB user for TDE-encrypted containerized databases.
`connection_type`	Possible values:`Directly`, `PrivateLink`, `SshTunnel`. `SshTunnel` is used as a value if this parameter is omitted in the request and any of the following parameter's values is specified: `tunnel_host`, `tunnel_port`, `tunnel_user`. Otherwise, `Directly` is used as a value if the parameter is omitted.
`database`	The database name.
`enable_asm`	Default value: `false`. Set to `true` if you're using ASM.
`enable_symbolic_links`	Default value: `false`. Set to `true` if you're using symbolic links.
`enable_tde_encryption`	Default value: `false`. Set to `true` if you're using TDE encryption.
`host`	DB instance host or IP address.
`local_wallet_host`	Optional: The host for the local Oracle Wallet.
`local_wallet_user`	Optional: The user for the local Oracle Wallet.
`password`	The user's password.
`pdb_name`	Optional: Required only for containerized database.
`port`	The port number.
`symbolic_links_mapping`	Mapping of symbolic links to actual file paths. Required when symbolic links are enabled.
`tde_wallet_password`	TDE wallet password. Required for password based wallet.
`tunnel_host`	SSH host, specify only to connect via an SSH tunnel (do not use a load balancer).
`tunnel_port`	SSH port, specify only to connect via an SSH tunnel.
`tunnel_user`	SSH user, specify only to connect via an SSH tunnel.
`update_method`	The method used to detect new or changed rows. Supported values: - `BINARY_LOG_READER` - Fivetran reads Oracle redo logs to detect modified rows in the source tables. - `TELEPORT` - Fivetran's proprietary replication method that uses compressed snapshots to detect and apply changes.
`user`	The user name.
`schema_prefix` (required)	Destination schema prefix. Prefix for each replicated schema. For example with prefix 'x', source schemas 'foo' and 'bar' get replicated as 'x_foo' and 'x_bar'. The prefix is permanent and cannot be changed after connection creation

Authorization

This type of connector can only be authorized through the Connect Card or through the Fivetran dashboard.