Oracle Business Intelligence Publisher API Configuration
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": "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
},
"proxy_agent_id": "proxy_agent_id",
"private_link_id": "private_link_id",
"networking_method": "Directly",
"hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
"config": {
"password": "test_password",
"data_model_path_alias_list": [
{
"path": "/Custom/data_models",
"alias": "sample_schema"
}
],
"server_url": "https://<oracle_fusion_cloud>:<port>",
"folder_path": "/Custom/test_folder",
"username": "test_username",
"schema_prefix": "prefix"
}
}Config parameters
| Name | Description |
|---|---|
password | The Oracle Business Intelligence user password. |
data_model_path_alias_list | Data Model Paths (Optional) |
data_model_path_alias_list[0].path | Path |
data_model_path_alias_list[0].alias | Schema name |
server_url | The Oracle Business Intelligence Instance URL. |
folder_path | The folder path to save data models and reports. |
username | The Oracle Business Intelligence username. |
schema_prefix | 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_urlandfolder_pathparameters 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://<oracle_fusion_cloud>:<port>", "folder_path": "/Custom/test_folder" } }By using the Connect Card or the Fivetran dashboard.