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

Establishing a Software VPN Tunnel between OCI and AWS


In this post we are setting up a tunnel between OCI and AWS following the steps explained here and similar to what we did here. Step 1 Follow this post to set up a VPN headend in OCI. Step 2 Create a VPC in AWS with one public and one private subnet. Step 3 Create … Continue reading Establishing a Software VPN Tunnel between OCI and AWS

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 it 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 … Continue reading Extracting Data from Oracle SaaS to Onprem or Other Clouds through Private High Speed Connection via Service Gateway | Part Two: Hands On

Establishing a Software VPN Tunnel between OCI and Google Cloud


In this episode we are crating a tunnel between OCI and Google Cloud using the solution posted here Step 1 Follow this post for the OCI side and grab the value of the public IP endpoint and network encryption domain configured. Step 2 Create a vpn tunnel in google cloud, put the values of public … Continue reading Establishing a Software VPN Tunnel between OCI and Google Cloud

Creating a Software VPN Headend in OCI with Terraform


Shall you need to tune the bits of a VPN connection because the complexities of the left, right or both sides of the tunnel, one cheap option is to build a software solution. In this particular case we are utilising Libreswan. Terraform The current construct has been done with terraform, which provides automation and reduces … Continue reading Creating a Software VPN Headend in OCI with Terraform

oke-cluster-start-stop, a kubectl Plugin for starting/stopping all the Compute Nodes of an OKE Cluster


If you want to start or stop all of your OKE data plane cluster nodes you must go to all the nodes and execute the action one by one. The current post depicts a kubectl plugin extension created for helping you to start/stop your oke clusters. NOTES: The tool has been developed and tested in … Continue reading oke-cluster-start-stop, a kubectl Plugin for starting/stopping all the Compute Nodes of an OKE Cluster

Near Real Time Data Driven SaaS Integration with Streaming | Part 2: Extracting/Publishing Data Changes to Streaming Topics


As we mentioned in a previous post, the idea here is to develop a construct that seeks for changes in the SaaS data system and publishes those changes to a stream for later consumption from other systems over there. Indeed, as we see in the diagram, there is a block in which we are executing a program … Continue reading Near Real Time Data Driven SaaS Integration with Streaming | Part 2: Extracting/Publishing Data Changes to Streaming Topics

Near Real Time Data Driven SaaS Integration with Streaming | Part 1: Overview


File based approaches File-based data exchange comfort a large percentage of the integrations between SaaS and other ERP solutions in the past and today. The approach is robust and allows a large number of transactions to be executed in batch without affecting the online systems, but it has an inconvenience: the information is not updated … Continue reading Near Real Time Data Driven SaaS Integration with Streaming | Part 1: Overview