Oracle Business Intelligence Publisher API Configuration

For more information about authentication, accessing the Fivetran REST API, and request and response formats, see Getting Started with the Fivetran REST API.

Request

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

{
  "group_id": "group_id",
  "service": "oracle_business_intelligence_publisher",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "paused": false,
  "pause_after_trial": false,
  "sync_frequency": 1440,
  "data_delay_sensitivity": "LOW",
  "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": {
    "data_model_path_alias_list": [
      {
        "alias": "sample_schema",
        "path": "/Custom/data_models"
      }
    ],
    "folder_path": "/Custom/test_folder",
    "password": "test_password",
    "server_url": "https://:",
    "username": "test_username",
    "schema_prefix": "prefix"
  }
}

Config parameters

Name	Description
`data_model_path_alias_list`	Data Model Paths (Optional)
`data_model_path_alias_list[0].alias`	Schema name
`data_model_path_alias_list[0].path`	Path
`folder_path`	The folder path to save data models and reports.
`password`	The Oracle Business Intelligence user password.
`server_url`	The Oracle Business Intelligence Instance URL.
`username`	The Oracle Business Intelligence username.
`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

There are two ways to authorize this connector type:

By specifying the values for the username, password, server_url and folder_path parameters in the request.

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

{
  "service": "oracle_business_intelligence_publisher",
  "group_id": "group_id",
  "config": {
    "username": "test_username",
    "password": "test_password",
    "server_url": "https://:",
    "folder_path": "/Custom/test_folder"
  }
}

By using the Connect Card or the Fivetran dashboard.