Oracle Source PluginLatest: v3.0.0
The CloudQuery Oracle plugin extracts Oracle Cloud Infrastructure data (
oci) and loads it into any supported CloudQuery destination (e.g. PostgreSQL, BigQuery, Snowflake, and more). It is based on the OCI Go SDK (opens in a new tab) and the Oracle Cloud REST API (opens in a new tab).
In order for CloudQuery to sync resources from your Oracle Cloud setup, you will need to authenticate with your Oracle Cloud account. CloudQuery supports the same authentication methods as the OCI Go SDK, and uses the "default" configuration provider. You can read about how to create an Oracle Cloud configuration file in https://docs.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm (opens in a new tab).
An example configuration file (e.g. in
~/.oci/config) looks like this:
[DEFAULT] user=ocid1.user.oc1..<unique_ID> fingerprint=<your_fingerprint> key_file=~/.oci/oci_api_key.pem tenancy=ocid1.tenancy.oc1..<unique_ID> region=us-ashburn-1
Note that CloudQuery will
sync information from all regions - not only the region specified in the
In order to get started with the Oracle plugin, you need to create a YAML file in your CloudQuery configuration directory (e.g. named
The following example sets up the Oracle plugin, and connects it to a postgresql destination:
kind: source spec: name: "oracle" path: cloudquery/oracle version: "v3.0.0" destinations: ["postgresql"] tables: ["*"] spec: