Rittman Mead Blog - Oracle Call Interface (OCI)

Automating Code Reviews with Git Hooks and Oracle Generative AI

A few years ago, I wrote a Groovy script for a client to automate peer reviews of their Oracle Data Integrator (ODI) development. It was a complex script, embodying the collective knowledge of the development team: standards, expectations, and best practices. Reflecting on that project now, I can’t help

oci

Detecting & Masking Personal Identifiable Information: Using OCI Language Model & Oracle Analytics

Why is personal information identification a big deal? Personal Information Identification (PII) is crucial for maintaining privacy, complying with regulations, mitigating risks, ensuring data quality, and enabling trust between organisations and their customers. In recent years, numerous organisations worldwide have encountered legal issues due to breaches of PII. Notable incidents

oci

Updating the Docker Image on the RStudio Terraform Template

In my previous blog post I wrote about deploying R Studio in a container on OCI. If you remember, I mentioned that the terraform template in OCI creates a compute instance with a docker container running R version 4.1.1, released on 2021/08/10. The terraform template can

oci

OCI Data Flow: ETL with Apache Spark in the Cloud

About OCI Data Flow Oracle Cloud Infrastructure (OCI) Data Flow is a managed service for running Apache Spark applications, promising simplified infrastructure management, development, and deployment. Initial impressions suggest it delivers on this promise, showcasing an elegant approach to certain tasks. To assess OCI Data Flow's capabilities, a

oci

Modern Data Platforms, A Beast of Tech that you can feed after midnight!

You look like someone who needs a Data Solution, one that fulfils your data needs you haven't even thought up yet to ensure that your Mogwai - I mean stakeholders remain fun and happy and don't turn into angry data deprived Gremlins. There are many choices

oci

The Oracle of the Cloud, the Fellowship of the Data Integrator

Oracle Cloud Infrastructure has a suite of integration tools comprising of Data Quality, Oracle Streams, GoldenGate, Data Integrator classic and Data Integrator Web Edition (which is also named Data Tranforms) all of which have capabilities that make ETL and ELT work far simpler and quicker, as it is designed to

oci

A Quick Script To Connect To An OCI Bastion Service

Here is a little script I knocked together to make it easier and quicker to connect to an Oracle OCI SSH Bastion service. Why use GUI when you can script it? First, the script checks if you already have an active bastion session, titled after your OS user. If not,

oci

An Initial Introduction to OCI Queue with OCI Python SDK

In the world of distributed systems and microservices, message queues play a vital role in enabling reliable communication between components. Oracle Cloud Infrastructure (OCI) offers a robust and scalable message queuing service that simplifies the process of building event-driven architectures. The OCI Queue Service introduces a simple concept: publish messages

data science

Introduction to Oracle Data Science Service Part 2

Using oracle-ads Python library to create a secret within an OCI vault. Use this secret to connect to an ADW and read and write data to the AWD.

data science

Introduction to Oracle Data Science Service Part 1

Creating Data Science Projects and Notebook Sessions, installing and creating kernel environments, and sharing these environments via the OCI Storage Bucket.

Technical

OBIEE Administration Tool - Import Metadata shows no schemas

Importing Metadata with the Administration Tool The client-only install of the OBIEE 11g Administration Tool is installed with a set of OCI libraries. This means that it can support basic Oracle Database interaction, without the need for a full Oracle Client installation on the machine. For example, you can update