This solution describes how to use Rclone to migrate/copy data from Amazon S3, Microsoft Azure Blob storage and more to an OCI Object Storage bucket. …

The Oracle database DBMS_CLOUD package was introduced with Oracle Autonomous databases, it provides lots of very cool procedures for interacting with Object Storage store from the Oracle database. It provides much more and can be used in on-premise installations for versions 19c and 21c (How To Setup And Use DBMS_CLOUD…

There’s a few concepts within OCI Data Integration that help with reusing logic. Here we will look at two; parameters and rules. Parameters are familiar to us from all programming languages. Rules are a little different but are useful for generically shaping data or generically performing transformations on attributes. Parameters Parameters…

Bash scripts contain a set of instructions written in Bash command language and those scripts can be executed in Unix shell interpreters, similarly, batch scripts in Windows provide similar capabilities. We may have used these scripts to automate tasks that are time consuming and need to be performed over and…

Here we will see how you can export from Google BigQuery into OCI Object Storage. We will leverage Google BigQuery python APIs and OCI Functions to execute a SQL query on Big Query, securely getting the API Key and saving the resultant data into Apache Parquet files. There are other…

Are you looking to export large tables fast? An approach to export data out in multiple chunks in parallel? Using a robust, open source mechanism? These are typical questions when customers are looking to move data from hot to cold storage or into a Data Lake like OCI Object Storage…

As consumers we take for granted a lot of things at our fingertips everyday don’t we? We flip through our phones with ease and snap away at images all day long. Documents, images, sound and movies all have valuable insights over and above structured data. …

Today I am going to explain how to call an external API from OCI Functions and save the response in an Object Storage bucket. …

Many times there is the need to create archive files from many other files (using zip for the archiving), this is true from laptops, to on premise compute nodes to the cloud. Here we will see how to use an OCI Function to create a zip archive from a list…