Solution Pattern for Delivering big Messages/Documents/Payloads not Overloading the Api Gateway


Either you are a Telco or utilities company providing download of invoices through the mobile or desktop app, or maybe a travel broker delivering big json/xml payloads to partners, the following pattern is intended to alleviate the traffic of big amount of data through the api gateway. The idea is quite simple, following  end user … Continue reading Solution Pattern for Delivering big Messages/Documents/Payloads not Overloading the Api Gateway

Automating Audit Trails Archive to Object Storage with Oracle Developer Cloud Service


Oracle Cloud provides out the box audit records that can be obtained by tools such the dashboard portal, the APIs like rest/go/java/phy and the CLI. In this post we are explaining how to automate the archiving of the trails to an object storage bucket using the CLI inside DevCS, the CI/CD and DevOps tool provided … Continue reading Automating Audit Trails Archive to Object Storage with Oracle Developer Cloud Service

Copying Object Storage (Big) Files to Final Destination via PreAuthenticatedRequests


Photo by panumas nikhomkhai on Pexels.com Once someone puts files in an object storage as an intermediary repository to interchange data, afterthat you have to move or copy those files to the final destination. There are several mechanisms to copy those files such as API's or the Command Line Interface (CLI), but one very easy … Continue reading Copying Object Storage (Big) Files to Final Destination via PreAuthenticatedRequests

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 … Continue reading Offloading Oracle Data to Object Storage and Loading as External Table in an Autonomous Database | Part 3: Oracle OCI Object Storage

Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part Two: AWS S3


Following up the previous post, we are explaining today how to make same thing using Amazon S3. The procedure and steps are quite similar, let's go and try! Amazon side setup Create a S3 bucket with no public access: Upload datafile: Grab the object URL for later: Bucket located in Frankfurt Create a user in … Continue reading Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part Two: AWS S3

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 storagedata nearline as external tables in object storagedata 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 tables and … Continue reading Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part One: Azure Object Storage