ORACLE PUBLIC CLOUD

Offloading Oracle Data to Object Storage and Loading as External Table in an Autonomous Database | Part 3: Oracle OCI Object Storage


Following up the posts here and here, we are explaining today how to make same thing using Oracle OCI Object Storage. The procedure and steps are quite similar so, let’s go and try! Steps Create a bucket Upload file to bucket Create an Auth Token for your user as follows: In a sql editor, execute […]

More

Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part One: Azure Object Storage


Oracle autonomous database (ADW/ATP) offers several approaches for storing the data: data online stored in the database internal storage data nearline as external tables in object storage data offline in object storage The autonomous database supports object storage provided by Oracle OCI, Amazon S3 and Azure, with them you can create external tables, external partitioned […]

More

Extracting Data from Oracle SaaS to Onprem or Other Clouds through Private High Speed Connection via Service Gateway | Part Two: Hands On


In previous post we explained the mechanisms to extract data from ERP and put in an Object Storage repository that can be accessed privately from other places in a secure manner. To demonstrate the use case we are creating a VPN tunnel between Google Cloud and OCI as explained here. Google Side Once we have […]

More

Extracting Data from Oracle SaaS to Onprem or Other Clouds through Private High Speed Connection via Service Gateway | Part One


BI Cloud Extract is a standard tool for extracting data from SaaS (ERP, …) either incremental or fully approaches. Data is exported to Object Storage as zipped files. Files stored in object storage are encrypted by a key provided by OCI Object Storage administrator role o keys managed by Oracle. Additionally Oracle encrypts data at […]

More