OK
{- "items": [
- {
- "id": "dsource-123",
- "database_type": "Oracle",
- "name": "prod01-main",
- "database_version": "10.2.0.5.0",
- "data_uuid": "1734315df891991101eb96963535afa0",
- "storage_size": 339292672,
- "plugin_version": "1.0",
- "creation_date": "2021-05-01T08:51:34.148Z",
- "group_name": "DSources",
- "enabled": true,
- "is_detached": false,
- "engine_id": "engine-123",
- "source_id": "source-123",
- "status": "RUNNING",
- "engine_name": "engine-123-name",
- "cdb_id": "cdb-123",
- "is_appdata": true,
- "tags": [
- {
- "key": "key1",
- "value": "value1"
}, - {
- "key": "key2",
- "value": "value2"
}
], - "primary_object_id": "1-CONTAINER-1",
- "primary_engine_id": "1",
- "primary_engine_name": "source-engine",
- "replicas": [
- {
- "replica_id": "replica-1",
- "replica_engine_id": "1",
- "replica_engine_name": "replica-e1"
}, - {
- "replica_id": "replica-2",
- "replica_engine_id": "2",
- "replica_engine_name": "replica-e2"
}
], - "hooks": {
- "pre_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0"
}
]
}, - "sync_policy_id": "1-POLICY_SNAPSHOT-1",
- "retention_policy_id": "1-POLICY_RETENTION-1",
- "replica_retention_policy_id": "1-POLICY_REPLICA_RETENTION-1",
- "quota_policy_id": "1-POLICY_QUOTA-1",
- "logsync_enabled": true,
- "exported_data_directory": "domain0/oracle_db_container-30/oracle_timeflow-32/datafile",
- "template_id": "DATABASE_TEMPLATE-1"
}
], - "errors": [
- {
- "message": "string",
- "object_name": "string"
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
The parameters to link an Oracle dSource.
OK
The above request example is intended for Oracle Database without including optional properties
{- "source_id": "1-SOURCE_CONFIG-1"
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}, - "dsource_id": "string"
}
{- "source_id": "string"
}
{- "name": "string",
- "source_id": "string",
- "group_id": "string",
- "description": "string",
- "log_sync_enabled": false,
- "sync_policy_id": "snapshot-123",
- "retention_policy_id": "retention-policy-123",
- "make_current_account_owner": true,
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "ops_pre_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "ops_post_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "external_file_path": "string",
- "environment_user_id": "string",
- "backup_level_enabled": true,
- "rman_channels": 2,
- "files_per_set": 5,
- "check_logical": false,
- "encrypted_linking_enabled": false,
- "compressed_linking_enabled": true,
- "bandwidth_limit": 0,
- "number_of_connections": 1,
- "diagnose_no_logging_faults": true,
- "pre_provisioning_enabled": false,
- "link_now": false,
- "force_full_backup": false,
- "double_sync": false,
- "skip_space_check": false,
- "do_not_resume": false,
- "files_for_full_backup": [
- 0
], - "log_sync_mode": "ARCHIVE_ONLY_MODE",
- "log_sync_interval": 5,
- "non_sys_username": "oracle",
- "non_sys_password": "oracle",
- "non_sys_vault_username": "my-vault",
- "non_sys_vault": "my-vault",
- "non_sys_hashicorp_vault_engine": "kv",
- "non_sys_hashicorp_vault_secret_path": "oracle-env",
- "non_sys_hashicorp_vault_username_key": "username",
- "non_sys_hashicorp_vault_secret_key": "secret",
- "non_sys_azure_vault_name": "azure_vault",
- "non_sys_azure_vault_username_key": "username",
- "non_sys_azure_vault_secret_key": "secret",
- "non_sys_cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test",
- "fallback_username": "oracle",
- "fallback_password": "oracle",
- "fallback_vault_username": "my-vault",
- "fallback_vault": "my-vault",
- "fallback_hashicorp_vault_engine": "kv",
- "fallback_hashicorp_vault_secret_path": "oracle-env",
- "fallback_hashicorp_vault_username_key": "username",
- "fallback_hashicorp_vault_secret_key": "secret",
- "fallback_azure_vault_name": "azure_vault",
- "fallback_azure_vault_username_key": "username",
- "fallback_azure_vault_secret_key": "secret",
- "fallback_cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test",
- "ops_pre_log_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
]
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
The parameters to attach an Oracle dSource.
OK
{- "source_id": "string",
- "backup_level_enabled": true,
- "bandwidth_limit": 0,
- "check_logical": false,
- "compressed_linking_enabled": true,
- "double_sync": false,
- "encrypted_linking_enabled": false,
- "environment_user": "string",
- "external_file_path": "string",
- "files_per_set": 5,
- "force": false,
- "link_now": false,
- "number_of_connections": 1,
- "operations": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "oracle_fallback_user": "oracle",
- "oracle_fallback_credentials": "oracle",
- "rman_channels": 2
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
The parameters to link an Oracle dSource.
OK
The above request example is intended for an Oracle staging push non PDB Database linking without including optional properties
{- "name": "DSOURCE-1",
- "engine_id": 1,
- "container_type": "NON_CDB",
- "environment_user_id": "HOST_USER-1",
- "repository": "ORACLE_REPO-1",
- "database_name": "DB_NAME-1",
- "database_unique_name": "DB_UN_NAME-1",
- "sid": "SID-1",
- "mount_base": "/mount1"
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}, - "dsource_id": "string"
}
{- "environment_id": "string",
- "container_type": "ROOT_CDB"
}
{- "name": "string",
- "source_id": "string",
- "group_id": "string",
- "description": "string",
- "log_sync_enabled": false,
- "sync_policy_id": "snapshot-123",
- "retention_policy_id": "retention-policy-123",
- "make_current_account_owner": true,
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "ops_pre_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "ops_post_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "engine_id": "string",
- "container_type": "ROOT_CDB",
- "environment_user_id": "string",
- "repository": "string",
- "database_name": "string",
- "database_unique_name": "string",
- "sid": "string",
- "mount_base": "string",
- "custom_env_variables_pairs": [
- {
- "var_name": "env-var-name-1",
- "var_value": "env-var-value-1"
}
], - "custom_env_variables_paths": [
- "string"
], - "auto_staging_restart": false,
- "allow_auto_staging_restart_on_host_reboot": true,
- "physical_standby": false,
- "validate_snapshot_in_readonly": false,
- "validate_by_opening_db_in_read_only_mode": true,
- "staging_database_templates": [
- {
- "var_name": "env-var-name-1",
- "var_value": "env-var-value-1"
}
], - "staging_database_config_params": {
- "processes": "150"
}, - "staging_container_database_reference": "string",
- "ops_pre_log_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "tde_keystore_config_type": "FILE",
- "template_id": "70096a7-6655-4973-8464-682c41c932da"
}
The new data to update an Oracle dSource.
OK
{- "name": "my-dsource",
- "db_username": "db-username",
- "db_password": "db-password",
- "validate_db_credentials": true,
- "environment_user_id": "environment-user-123",
- "backup_level_enabled": true,
- "rman_channels": 1,
- "files_per_set": 1,
- "check_logical": true,
- "encrypted_linking_enabled": true,
- "compressed_linking_enabled": true,
- "bandwidth_limit": 0,
- "number_of_connections": 0,
- "validate_by_opening_db_in_read_only_mode": true,
- "pre_provisioning_enabled": true,
- "diagnose_no_logging_faults": true,
- "rac_max_instance_lag": 0,
- "allow_auto_staging_restart_on_host_reboot": true,
- "physical_standby": true,
- "external_file_path": "string",
- "hooks": {
- "ops_pre_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0",
- "has_credentials": false
}
], - "ops_pre_log_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0",
- "has_credentials": false
}
], - "ops_post_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0",
- "has_credentials": false
}
], - "pre_validated_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0",
- "has_credentials": false
}
], - "post_validated_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0",
- "has_credentials": false
}
]
}, - "custom_env_variables_pairs": [
- {
- "var_name": "env-var-name-1",
- "var_value": "env-var-value-1"
}
], - "custom_env_variables_paths": [
- "string"
], - "staging_database_config_params": { },
- "template_id": "70096a7-6655-4973-8464-682c41c932da",
- "logsync_enabled": true,
- "logsync_mode": "ARCHIVE_ONLY_MODE",
- "logsync_interval": 5
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
The new data to upgrade an Oracle dSource.
OK
{- "repository_id": "1-ORACLE_INSTALL-4",
- "environment_user_id": "HOST_USER-4"
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
The parameters to link an ASE dSource.
OK
The above request example is intended for an ASE Database without including optional properties
{- "source_id": "ASE_CONFIG-1",
- "db_user": "db-user",
- "db_password": "secret-password",
- "load_backup_path": "/backup/path"
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}, - "dsource_id": "string"
}
{- "source_id": "string"
}
{- "name": "string",
- "source_id": "string",
- "group_id": "string",
- "description": "string",
- "log_sync_enabled": false,
- "sync_policy_id": "snapshot-123",
- "retention_policy_id": "retention-policy-123",
- "make_current_account_owner": true,
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "ops_pre_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "ops_post_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "external_file_path": "string",
- "mount_base": "string",
- "load_backup_path": "string",
- "backup_server_name": "string",
- "backup_host_user": "string",
- "backup_host": "string",
- "dump_credentials": "string",
- "source_host_user": "string",
- "db_user": "string",
- "db_password": "string",
- "db_vault_username": "my-vault",
- "db_vault": "string",
- "db_hashicorp_vault_engine": "string",
- "db_hashicorp_vault_secret_path": "string",
- "db_hashicorp_vault_username_key": "string",
- "db_hashicorp_vault_secret_key": "string",
- "db_azure_vault_name": "string",
- "db_azure_vault_username_key": "string",
- "db_azure_vault_secret_key": "string",
- "db_cyberark_vault_query_string": "string",
- "staging_repository": "string",
- "staging_host_user": "string",
- "validated_sync_mode": "ENABLED",
- "dump_history_file_enabled": false,
- "drop_and_recreate_devices": false,
- "sync_strategy": "latest_backup",
- "ase_backup_files": [
- "string"
], - "pre_validated_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "post_validated_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
]
}
The parameters to link an AppData dSource.
OK
The above request example is intended for a Postgres AppData linking
{- "source_id": "1-APPDATA_STAGED_SOURCE_CONFIG-1",
- "group_id": "1-GROUP-1",
- "link_type": "AppDataStaged",
- "staging_environment": "1-ENVIRONMENT-1",
- "staging_mount_base": "/mnt/staging",
- "environment_user": "1-ENVIRONMENT_USER-1",
- "parameters": {
- "postgresPort": "5432,"
}, - "sync_parameters": {
- "resync": true
}
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}, - "dsource_id": "string"
}
{- "source_id": "string"
}
{- "name": "string",
- "source_id": "string",
- "group_id": "string",
- "description": "string",
- "log_sync_enabled": false,
- "sync_policy_id": "snapshot-123",
- "retention_policy_id": "retention-policy-123",
- "make_current_account_owner": true,
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "ops_pre_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "ops_post_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "link_type": "AppDataDirect",
- "staging_mount_base": "string",
- "staging_environment": "string",
- "staging_environment_user": "string",
- "environment_user": "string",
- "excludes": [
- "string"
], - "follow_symlinks": [
- "string"
], - "parameters": { },
- "sync_parameters": { }
}
The parameters to link an MSSql dSource.
OK
The above request example is intended for an MSSql Database linking without including optional properties
{- "source_id": "1-SOURCE_CONFIG-1",
- "ppt_repository": "MSSQL_INSTANCE-1",
- "ppt_host_user": "HOST_USER-1",
- "mssql_user_environment_reference": "HOST_USER-1"
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}, - "dsource_id": "string"
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
The parameters to attach a MSSql dSource.
OK
The above request example is intended for an MSSql Database attach operation without including optional properties
{- "source_id": "SOURCE_CONFIG-1",
- "ppt_repository": "MSSQL_INSTANCE-1",
- "mssql_user_environment_reference": "HOST_USER-1"
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
The parameters to attach an MSSql dSource.
OK
The above request example is intended for an MSSql staging push Database attach operation without including optional properties
{- "ppt_repository": "PPT_REPOSITORY-1",
- "staging_database_name": "staging_database-1"
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
{- "source_id": "string"
}
{- "name": "string",
- "source_id": "string",
- "group_id": "string",
- "description": "string",
- "log_sync_enabled": false,
- "sync_policy_id": "snapshot-123",
- "retention_policy_id": "retention-policy-123",
- "make_current_account_owner": true,
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "ops_pre_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "ops_post_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "encryption_key": "string",
- "sync_strategy": "latest_backup",
- "mssql_backup_uuid": "string",
- "compression_enabled": false,
- "availability_group_backup_policy": "primary",
- "source_host_user": "string",
- "ppt_repository": "string",
- "ppt_host_user": "string",
- "staging_pre_script": "string",
- "staging_post_script": "string",
- "sync_strategy_managed_type": "external",
- "mssql_user_environment_reference": "string",
- "mssql_user_domain_username": "string",
- "mssql_user_domain_password": "string",
- "mssql_user_domain_vault_username": "my-vault",
- "mssql_user_domain_vault": "string",
- "mssql_user_domain_hashicorp_vault_engine": "string",
- "mssql_user_domain_hashicorp_vault_secret_path": "string",
- "mssql_user_domain_hashicorp_vault_username_key": "string",
- "mssql_user_domain_hashicorp_vault_secret_key": "string",
- "mssql_user_domain_azure_vault_name": "string",
- "mssql_user_domain_azure_vault_username_key": "string",
- "mssql_user_domain_azure_vault_secret_key": "string",
- "mssql_user_domain_cyberark_vault_query_string": "string",
- "mssql_database_username": "string",
- "mssql_database_password": "string",
- "delphix_managed_backup_compression_enabled": false,
- "delphix_managed_backup_policy": "primary",
- "external_managed_validate_sync_mode": "TRANSACTION_LOG",
- "external_managed_shared_backup_locations": [
- "string"
], - "external_netbackup_config_master_name": "string",
- "external_netbackup_config_source_client_name": "string",
- "external_netbackup_config_params": { },
- "external_netbackup_config_templates": "string",
- "external_commserve_host_name": "string",
- "external_commvault_config_source_client_name": "string",
- "external_commvault_config_staging_client_name": "string",
- "external_commvault_config_params": { },
- "external_commvault_config_templates": "string"
}
The parameters to link an MSSql dSource.
OK
The above request example is intended for an MSSql staging push Database linking without including optional properties
{- "name": "DSOURCE-1",
- "engine_id": 1,
- "ppt_repository": "PPT_REPOSITORY-1",
- "ppt_host_user": "PPT_HOST_USER-1",
- "staging_database_name": "staging_database-1"
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}, - "dsource_id": "string"
}
{- "environment_id": "string"
}
{- "name": "string",
- "source_id": "string",
- "group_id": "string",
- "description": "string",
- "log_sync_enabled": false,
- "sync_policy_id": "snapshot-123",
- "retention_policy_id": "retention-policy-123",
- "make_current_account_owner": true,
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "ops_pre_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "ops_post_sync": [
- {
- "name": "string",
- "command": "string",
- "shell": "bash",
- "credentials_env_vars": [
- {
- "base_var_name": "string",
- "password": "password",
- "vault_username": "my-vault",
- "vault": "my-vault",
- "hashicorp_vault_engine": "kv",
- "hashicorp_vault_secret_path": "oracle-env",
- "hashicorp_vault_username_key": "username",
- "hashicorp_vault_secret_key": "secret",
- "azure_vault_name": "azure_vault",
- "azure_vault_username_key": "username",
- "azure_vault_secret_key": "secret",
- "cyberark_vault_query_string": "Safe=Test;Folder=Test;Object=Test"
}
]
}
], - "engine_id": "string",
- "encryption_key": "string",
- "ppt_repository": "string",
- "ppt_host_user": "string",
- "staging_pre_script": "string",
- "staging_post_script": "string",
- "staging_database_name": "string",
- "db_state": "RESTORING"
}
OK
{- "dsource_id": "string",
- "force": false,
- "oracle_username": "oracle-username",
- "oracle_password": "oracle-password"
}
{- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string",
- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
A request body containing a filter expression. This enables searching for items matching arbitrarily complex conditions. The list of attributes which can be used in filter expressions is available in the x-filterable vendor extension.
Note: All keywords are case-insensitive
Operator | Description | Example |
---|---|---|
CONTAINS | Substring or membership testing for string and list attributes respectively. | field3 CONTAINS 'foobar', field4 CONTAINS TRUE |
IN | Tests if field is a member of a list literal. List can contain a maximum of 100 values | field2 IN ['Goku', 'Vegeta'] |
GE | Tests if a field is greater than or equal to a literal value | field1 GE 1.2e-2 |
GT | Tests if a field is greater than a literal value | field1 GT 1.2e-2 |
LE | Tests if a field is less than or equal to a literal value | field1 LE 9000 |
LT | Tests if a field is less than a literal value | field1 LT 9.02 |
NE | Tests if a field is not equal to a literal value | field1 NE 42 |
EQ | Tests if a field is equal to a literal value | field1 EQ 42 |
The SEARCH operator filters for items which have any filterable
attribute that contains the input string as a substring, comparison
is done case-insensitively. This is not restricted to attributes with
string values. Specifically SEARCH '12'
would match an item with an
attribute with an integer value of 123
.
Ordered by precedence.
Operator | Description | Example |
---|---|---|
NOT | Logical NOT (Right associative) | NOT field1 LE 9000 |
AND | Logical AND (Left Associative) | field1 GT 9000 AND field2 EQ 'Goku' |
OR | Logical OR (Left Associative) | field1 GT 9000 OR field2 EQ 'Goku' |
Parenthesis ()
can be used to override operator precedence.
For example: NOT (field1 LT 1234 AND field2 CONTAINS 'foo')
Literal | Description | Examples |
---|---|---|
Nil | Represents the absence of a value | nil, Nil, nIl, NIL |
Boolean | true/false boolean | true, false, True, False, TRUE, FALSE |
Number | Signed integer and floating point numbers. Also supports scientific notation. | 0, 1, -1, 1.2, 0.35, 1.2e-2, -1.2e+2 |
String | Single or double quoted | "foo", "bar", "foo bar", 'foo', 'bar', 'foo bar' |
Datetime | Formatted according to RFC3339 | 2018-04-27T18:39:26.397237+00:00 |
List | Comma-separated literals wrapped in square brackets | [0], [0, 1], ['foo', "bar"] |
OK
An example of a nested Object comparison testing that at least one repository has a version which is equal to 19.0.0.
{- "filter_expression": "repositories CONTAINS {version eq '19.0.0'}"
}
{- "items": [
- {
- "id": "dsource-123",
- "database_type": "Oracle",
- "name": "prod01-main",
- "database_version": "10.2.0.5.0",
- "data_uuid": "1734315df891991101eb96963535afa0",
- "storage_size": 339292672,
- "plugin_version": "1.0",
- "creation_date": "2021-05-01T08:51:34.148Z",
- "group_name": "DSources",
- "enabled": true,
- "is_detached": false,
- "engine_id": "engine-123",
- "source_id": "source-123",
- "status": "RUNNING",
- "engine_name": "engine-123-name",
- "cdb_id": "cdb-123",
- "is_appdata": true,
- "tags": [
- {
- "key": "key1",
- "value": "value1"
}, - {
- "key": "key2",
- "value": "value2"
}
], - "primary_object_id": "1-CONTAINER-1",
- "primary_engine_id": "1",
- "primary_engine_name": "source-engine",
- "replicas": [
- {
- "replica_id": "replica-1",
- "replica_engine_id": "1",
- "replica_engine_name": "replica-e1"
}, - {
- "replica_id": "replica-2",
- "replica_engine_id": "2",
- "replica_engine_name": "replica-e2"
}
], - "hooks": {
- "pre_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0"
}
]
}, - "sync_policy_id": "1-POLICY_SNAPSHOT-1",
- "retention_policy_id": "1-POLICY_RETENTION-1",
- "replica_retention_policy_id": "1-POLICY_REPLICA_RETENTION-1",
- "quota_policy_id": "1-POLICY_QUOTA-1",
- "logsync_enabled": true,
- "exported_data_directory": "domain0/oracle_db_container-30/oracle_timeflow-32/datafile",
- "template_id": "DATABASE_TEMPLATE-1"
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
{- "id": "dsource-123",
- "database_type": "Oracle",
- "name": "prod01-main",
- "database_version": "10.2.0.5.0",
- "data_uuid": "1734315df891991101eb96963535afa0",
- "storage_size": 339292672,
- "plugin_version": "1.0",
- "creation_date": "2021-05-01T08:51:34.148Z",
- "group_name": "DSources",
- "enabled": true,
- "is_detached": false,
- "engine_id": "engine-123",
- "source_id": "source-123",
- "status": "RUNNING",
- "engine_name": "engine-123-name",
- "cdb_id": "cdb-123",
- "is_appdata": true,
- "tags": [
- {
- "key": "key1",
- "value": "value1"
}, - {
- "key": "key2",
- "value": "value2"
}
], - "primary_object_id": "1-CONTAINER-1",
- "primary_engine_id": "1",
- "primary_engine_name": "source-engine",
- "replicas": [
- {
- "replica_id": "replica-1",
- "replica_engine_id": "1",
- "replica_engine_name": "replica-e1"
}, - {
- "replica_id": "replica-2",
- "replica_engine_id": "2",
- "replica_engine_name": "replica-e2"
}
], - "hooks": {
- "pre_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0"
}
]
}, - "sync_policy_id": "1-POLICY_SNAPSHOT-1",
- "retention_policy_id": "1-POLICY_RETENTION-1",
- "replica_retention_policy_id": "1-POLICY_REPLICA_RETENTION-1",
- "quota_policy_id": "1-POLICY_QUOTA-1",
- "logsync_enabled": true,
- "exported_data_directory": "domain0/oracle_db_container-30/oracle_timeflow-32/datafile",
- "template_id": "DATABASE_TEMPLATE-1"
}
{- "attempt_start": true
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
{- "attempt_cleanup": true
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
The new data to update an MSSql dSource.
OK
{- "logsync_enabled": true,
- "encryption_key": "string",
- "ppt_repository": "string",
- "ppt_host_user": "string",
- "sync_strategy_managed_type": "external",
- "source_host_user": "string",
- "mssql_user_environment_reference": "string",
- "mssql_user_domain_username": "string",
- "mssql_user_domain_password": "string",
- "mssql_user_domain_vault_username": "my-vault",
- "mssql_user_domain_vault": "string",
- "mssql_user_domain_hashicorp_vault_engine": "string",
- "mssql_user_domain_hashicorp_vault_secret_path": "string",
- "mssql_user_domain_hashicorp_vault_username_key": "string",
- "mssql_user_domain_hashicorp_vault_secret_key": "string",
- "mssql_user_domain_azure_vault_name": "string",
- "mssql_user_domain_azure_vault_username_key": "string",
- "mssql_user_domain_azure_vault_secret_key": "string",
- "mssql_user_domain_cyberark_vault_query_string": "string",
- "mssql_database_username": "string",
- "mssql_database_password": "string",
- "delphix_managed_backup_compression_enabled": true,
- "delphix_managed_backup_policy": "primary",
- "external_managed_validate_sync_mode": "TRANSACTION_LOG",
- "external_managed_shared_backup_locations": [
- "string"
], - "disable_netbackup_config": true,
- "external_netbackup_config_master_name": "string",
- "external_netbackup_config_source_client_name": "string",
- "external_netbackup_config_params": { },
- "external_netbackup_config_templates": "string",
- "disable_commvault_config": true,
- "external_commserve_host_name": "string",
- "external_commvault_config_source_client_name": "string",
- "external_commvault_config_staging_client_name": "string",
- "external_commvault_config_params": { },
- "external_commvault_config_templates": "string",
- "hooks": {
- "ops_pre_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0",
- "has_credentials": false
}
], - "ops_pre_log_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0",
- "has_credentials": false
}
], - "ops_post_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0",
- "has_credentials": false
}
], - "pre_validated_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0",
- "has_credentials": false
}
], - "post_validated_sync": [
- {
- "name": "Print the current user",
- "command": "whoami",
- "shell": "bash",
- "element_id": "0",
- "has_credentials": false
}
]
}, - "sync_policy_id": "snapshot-123",
- "retention_policy_id": "retention-policy-123"
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
OK
{- "items": [
- {
- "id": "snapshot-123",
- "engine_id": "1",
- "namespace": "NAMESPACE-1",
- "name": "@2023-02-02T14:30:00.589",
- "namespace_id": "1-NAMESPACE-1",
- "namespace_name": "test-engine-1",
- "is_replica": true,
- "consistency": "CONSISTENT",
- "missing_non_logged_data": false,
- "dataset_id": "dataset-123",
- "creation_time": "2023-02-02T19:30:00.589Z",
- "start_timestamp": "2021-05-01T08:51:34.148Z",
- "start_location": "1178883",
- "timestamp": "2021-05-01T08:51:34.148Z",
- "location": "1178883",
- "retention": -1,
- "expiration": "2021-07-04T00:00:00.000Z",
- "retain_forever": false,
- "effective_expiration": "2021-07-04T00:00:00.000Z",
- "effective_retain_forever": false,
- "timeflow_id": "1-ORACLE_TIMEFLOW-1",
- "timezone": "America/New_York,EST-0500",
- "version": "11.2.0.4.0",
- "temporary": false,
- "appdata_toolkit": "APPDATA_TOOLKIT-1",
- "appdata_metadata": "{}",
- "ase_db_encryption_key": "keyname",
- "mssql_internal_version": 706,
- "mssql_backup_set_uuid": "54290b71-58cd-463d-bd62-7219d4c4d2d5",
- "mssql_backup_software_type": "NATIVE",
- "mssql_backup_location_type": "BACKUP_SERVER",
- "mssql_empty_snapshot": true,
- "oracle_from_physical_standby_vdb": false,
- "oracle_redo_log_size_in_bytes": 314572800,
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
]
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
Optional parameters to snapshot a DSource.
dSource snapshot initiated.
This request example does not set any property and will thus use the default behavior.
{ }
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}