Oracle source integration documentation

Name: CloudQuery Oracle Integration
Author: CloudQuery

The CloudQuery Oracle plugin extracts Oracle Cloud Infrastructure data and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v7.6.8

Type

Source

Platforms

Date Published

Start Syncing

oracle_blockstorage_boot_volume_attachments
oracle_blockstorage_boot_volume_backups
oracle_blockstorage_boot_volume_replicas
oracle_blockstorage_boot_volumes
oracle_blockstorage_volume_backup_policies
oracle_blockstorage_volume_backups
oracle_blockstorage_volume_group_backups
oracle_blockstorage_volume_groups
oracle_blockstorage_volumes
oracle_compute_compute_capacity_reservations
oracle_compute_console_histories
oracle_compute_dedicated_vm_hosts
oracle_compute_images
oracle_compute_instance_console_connections
oracle_compute_instances
oracle_compute_vnic_attachments
oracle_compute_vnics
- oracle_compute_vnic_private_ips
oracle_compute_volume_attachments
oracle_containerengine_clusters
- oracle_containerengine_cluster_node_pools
- oracle_containerengine_cluster_virtual_node_pools
  - oracle_containerengine_cluster_virtual_nodes
- oracle_containerengine_cluster_work_requests
  - oracle_containerengine_cluster_work_request_logs
- oracle_containerengine_cluster_workload_mappings
- oracle_containerengine_cluster_addons
oracle_containerengine_pod_shapes
oracle_database_autonomous_container_databases
oracle_database_autonomous_databases
oracle_database_autonomous_exadata_infrastructures
oracle_database_autonomous_vm_clusters
oracle_database_backup_destination
oracle_database_cloud_autonomous_vm_clusters
oracle_database_cloud_exadata_infrastructures
oracle_database_cloud_vm_clusters
oracle_database_exadata_infrastructures
oracle_database_external_container_databases
oracle_database_external_non_container_databases
oracle_database_external_pluggable_databases
oracle_database_key_stores
oracle_database_vm_clusters
oracle_filestorage_exports
oracle_filestorage_export_sets
oracle_filestorage_file_systems
oracle_filestorage_mount_targets
oracle_filestorage_replications
oracle_filestorage_replication_targets
oracle_identity_compartments
oracle_identity_cost_tracking_tags
oracle_identity_domains
oracle_identity_dynamic_groups
oracle_identity_groups
oracle_identity_iam_work_requests
oracle_identity_network_sources
oracle_identity_policies
oracle_identity_tagging_work_requests
oracle_identity_tag_namespaces
oracle_identity_users
oracle_identity_work_requests
oracle_loadbalancer_load_balancers
oracle_networkfirewall_network_firewall_policies
oracle_networkfirewall_network_firewalls
oracle_networkfirewall_work_requests
oracle_networkloadbalancer_network_load_balancers
oracle_networkloadbalancer_work_requests
oracle_objectstorage_buckets
oracle_objectstorage_work_requests
oracle_virtualnetwork_assigned_public_ips
oracle_virtualnetwork_byoip_ranges
oracle_virtualnetwork_capture_filters
oracle_virtualnetwork_cpes
oracle_virtualnetwork_cross_connect_groups
oracle_virtualnetwork_cross_connects
oracle_virtualnetwork_dhcp_options
oracle_virtualnetwork_drg_attachments
oracle_virtualnetwork_drgs
oracle_virtualnetwork_ephemeral_public_ips
oracle_virtualnetwork_fast_connect_provider_services
oracle_virtualnetwork_internet_gateways
oracle_virtualnetwork_ip_sec_connections
oracle_virtualnetwork_local_peering_gateways
oracle_virtualnetwork_nat_gateways
oracle_virtualnetwork_public_ip_pools
oracle_virtualnetwork_remote_peering_connections
oracle_virtualnetwork_reserved_public_ips
oracle_virtualnetwork_route_tables
oracle_virtualnetwork_security_lists
oracle_virtualnetwork_service_gateways
oracle_virtualnetwork_subnets
- oracle_virtualnetwork_subnet_private_ips
oracle_virtualnetwork_vcns
oracle_virtualnetwork_virtual_circuits
oracle_virtualnetwork_vlans
oracle_virtualnetwork_vtaps

Oracle Database Autonomous Databases

The oracle_database_autonomous_databases table shows data for Oracle Database Autonomous Databases.

Primary Keys #

Name	Type
compartment_id	`utf8`
id	`utf8`
region	`utf8`

Columns #

Name	Type
actual_used_data_storage_size_in_t_bs	`float64`
additional_attributes	`json`
allocated_storage_size_in_t_bs	`float64`
apex_details	`json`
are_primary_whitelisted_ips_used	`bool`
autonomous_container_database_id	`utf8`
autonomous_database_maintenance_window	`json`
autonomous_maintenance_schedule_type	`utf8`
auto_refresh_frequency_in_seconds	`int64`
auto_refresh_point_lag_in_seconds	`int64`
availability_domain	`utf8`
available_upgrade_versions	`list<item: utf8, nullable>`
backup_config	`json`
backup_retention_period_in_days	`int64`
byol_compute_count_limit	`float64`
character_set	`utf8`
clone_table_space_list	`list<item: int64, nullable>`
clone_type	`utf8`
cluster_placement_group_id	`utf8`
compartment_id	`utf8`
compute_count	`float64`
compute_model	`utf8`
connection_strings	`json`
connection_urls	`json`
cpu_core_count	`int64`
_cq_id	`uuid`
_cq_parent_id	`uuid`
customer_contacts	`json`
database_edition	`utf8`
database_management_status	`utf8`
dataguard_region_type	`utf8`
data_safe_status	`utf8`
data_storage_size_in_g_bs	`int64`
data_storage_size_in_t_bs	`int64`
db_name	`utf8`
db_tools_details	`json`
db_version	`utf8`
db_workload	`utf8`
defined_tags	`json`
disaster_recovery_region_type	`utf8`
display_name	`utf8`
encryption_key_history_entry	`json`
failed_data_recovery_in_seconds	`int64`
freeform_tags	`json`
id	`utf8`
infrastructure_type	`utf8`
in_memory_area_in_g_bs	`int64`
in_memory_percentage	`int64`
is_access_control_enabled	`bool`
is_auto_scaling_enabled	`bool`
is_auto_scaling_for_storage_enabled	`bool`
is_backup_retention_locked	`bool`
is_data_guard_enabled	`bool`
is_dedicated	`bool`
is_dev_tier	`bool`
is_free_tier	`bool`
is_local_data_guard_enabled	`bool`
is_mtls_connection_required	`bool`
is_preview	`bool`
is_reconnect_clone_enabled	`bool`
is_refreshable_clone	`bool`
is_remote_data_guard_enabled	`bool`
key_history_entry	`json`
key_store_id	`utf8`
key_store_wallet_name	`utf8`
kms_key_id	`utf8`
kms_key_lifecycle_details	`utf8`
kms_key_version_id	`utf8`
license_model	`utf8`
lifecycle_details	`utf8`
lifecycle_state	`utf8`
local_adg_auto_failover_max_data_loss_limit	`int64`
local_adg_resource_pool_leader_id	`utf8`
local_disaster_recovery_type	`utf8`
local_standby_db	`json`
long_term_backup_schedule	`json`
maintenance_target_component	`utf8`
memory_per_compute_unit_in_g_bs	`float64`
memory_per_oracle_compute_unit_in_g_bs	`int64`
ncharacter_set	`utf8`
net_services_architecture	`utf8`
next_long_term_backup_time_stamp	`timestamp[us, tz=UTC]`
nsg_ids	`list<item: utf8, nullable>`
ocpu_count	`float64`
open_mode	`utf8`
operations_insights_status	`utf8`
peer_db_ids	`list<item: utf8, nullable>`
permission_level	`utf8`
private_endpoint	`utf8`
private_endpoint_ip	`utf8`
private_endpoint_label	`utf8`
provisionable_cpus	`list<item: float64, nullable>`
public_connection_urls	`json`
public_endpoint	`utf8`
refreshable_mode	`utf8`
refreshable_status	`utf8`
region	`utf8`
remote_disaster_recovery_configuration	`json`
resource_pool_leader_id	`utf8`
resource_pool_summary	`json`
role	`utf8`
scheduled_operations	`json`
security_attributes	`json`
service_console_url	`utf8`
source_id	`utf8`
standby_db	`json`
standby_whitelisted_ips	`list<item: utf8, nullable>`
subnet_id	`utf8`
subscription_id	`utf8`
supported_regions_to_clone_to	`list<item: utf8, nullable>`
system_tags	`json`
time_created	`timestamp[us, tz=UTC]`
time_data_guard_role_changed	`timestamp[us, tz=UTC]`
time_deletion_of_free_autonomous_database	`timestamp[us, tz=UTC]`
time_disaster_recovery_role_changed	`timestamp[us, tz=UTC]`
time_earliest_available_db_version_upgrade	`timestamp[us, tz=UTC]`
time_latest_available_db_version_upgrade	`timestamp[us, tz=UTC]`
time_local_data_guard_enabled	`timestamp[us, tz=UTC]`
time_maintenance_begin	`timestamp[us, tz=UTC]`
time_maintenance_end	`timestamp[us, tz=UTC]`
time_maintenance_pause_until	`timestamp[us, tz=UTC]`
time_of_auto_refresh_start	`timestamp[us, tz=UTC]`
time_of_joining_resource_pool	`timestamp[us, tz=UTC]`
time_of_last_failover	`timestamp[us, tz=UTC]`
time_of_last_refresh	`timestamp[us, tz=UTC]`
time_of_last_refresh_point	`timestamp[us, tz=UTC]`
time_of_last_switchover	`timestamp[us, tz=UTC]`
time_of_next_refresh	`timestamp[us, tz=UTC]`
time_reclamation_of_free_autonomous_database	`timestamp[us, tz=UTC]`
time_scheduled_db_version_upgrade	`timestamp[us, tz=UTC]`
time_undeleted	`timestamp[us, tz=UTC]`
time_until_reconnect_clone_enabled	`timestamp[us, tz=UTC]`
total_backup_storage_size_in_g_bs	`float64`
used_data_storage_size_in_g_bs	`int64`
used_data_storage_size_in_t_bs	`int64`
vanity_connection_urls	`json`
vanity_url_details	`json`
vault_id	`utf8`
whitelisted_ips	`list<item: utf8, nullable>`

Loading plugin tables

CloudOps

Oracle source integration documentation

Oracle Database Autonomous Databases

Primary Keys #

Columns #

Oracle Database Autonomous Databases

Primary Keys #

Columns #