Rittman Mead

CloudWorld 2023

Oracle shows products and features that use GenAI to close the gap between users formulating questions and then getting answers from the data; and purely using the data to drive action.

Data Engineering

Data Contracts - It Should Be A Thing

Data engineering is the backbone of any data-driven organisation. Data engineering involves collecting, transforming, and delivering data to facilitate informed decision-making. In this complex and dynamic process, a formal agreement between data producers, data transformers, and data consumers is required to ensure a seamless data flow and to maintain data

OCI Functions

OCI Functions | Part 2 - Creating a Function

Welcome back to Part 2 of OCI Functions. If you didn’t catch Part 1 you can read it here. In this part, we are going to take a look at creating our own OCI Function in Python. We know from working with the Pre-Built Function we have some things

APEX

Oracle APEX - Hosting and Licensing

As you might already know, Oracle APEX is a low-code development platform that can be used to build web-based applications. What you might not know is that APEX is a no-cost feature of the Oracle Database. Of course, if you want to use APEX to build and deploy applications there

OCI Functions

OCI Functions | Part 1 - Invoking Functions

Introduction to OCI Functions In this first blog post of the series, we will take our first step into OCI (Oracle Cloud Infrastructure) Functions. This is a service available on the Oracle Cloud, OCI Functions allow you to package your code so it can run autonomously within its own container.

APEX

Oracle APEX - APEX Component Designer

At Rittman Mead, the APEX consultancy team are always looking for ways to enhance and extend the product's core offering. Our latest project has seen us create a tool that makes it easy for you to customise JET and other 3rd party components and, after a few week's work, we're

APEX

Oracle APEX - Customising Oracle JET charts

XML

Parsing XML Files in SQL with Custom Aggregation Function

I was recently given a task to parse an XML file in SQL that contained the definition of an OBI RPD file, which had been exported using the biserverxmlgen command line utility. The purpose of this is for quick analysis of the RPD file and subsequent mapping of the data

APEX

Oracle APEX - Colouring JET Charts

In this article, we will explore the colour customisation possibilities that Oracle APEX offers for Oracle JET charts. The no-colour-set approach By default, APEX uses the colours defined in the Theme Roller colour palette. This is a great approach for simple applications and does, at least, ensure colour consistency across

training

Oracle Analytics Online Training

Oracle Analytics training, covering everything from the architecture and security to data modelling to building reports and dashboards to data discovery and basic machine learning.

OAC

Oracle Analytics Cloud July 2023 Update: What's New?

The July 2023 Update for Oracle Analytics Cloud came out a few days ago and in this article, I'm going to have a look at the features it includes. If you are also interested in a comprehensive list of the defects fixed by the update, please refer to Doc ID

Data Governance

The Importance of Data Strategy

Gartners 2022 research omnibus survey revealed that 58% of Data and Analytics (D&A) leaders see D&A alignment with business strategy as a top three driver of success. Data Strategy is integral to all organisations to manage and use data more effectively. Having the right data strategy in place

data science

Introduction to Oracle Data Science Service Part 4

This post is the fourth part of my blog series on the Oracle Data Science Service. In the previous post here we looked at some of the capabilities of the Oracle ADS SK, as well as creating, saving, and deploying models to OCI. In this blog we will look at

OAC

Extending OAC with Map Backgrounds

One of the really powerful things in Oracle Analytics Cloud (OAC) is the simplicity with which you can create geographical insights using the Map visualisation. I say this as someone who has implemented maps in OBIEE several times and so know the challenges of MapBuilder and MapViewer all too well.

Oracle Analytics

A Good Week For Oracle Analytics

The Forrester Wave BI Q2 2023 report ranked Oracle Analytics first in its current capabilities, surpassing competitors like Power BI and Tableau. I think it's time to give Oracle Analytics a bit more kudos.

events

EVENT: Modernising Your Oracle Data & Analytics Platform

Date and time: Thursday 13/7/2023 - 1:00pm GMT Location: Blackfriars House, Parsonage, Manchester, England. Do you have on-premises Oracle data and analytics software? What is the roadmap for these systems? Should I consider on-premises upgrade paths or migrate to the cloud? What is “cloud at customer”? Join

Oracle Database

Oracle Database Performance Testing the Easy Way

We have developed a tool for testing Oracle database performance. The tool connects to a database, executes a set of SELECT statements, and records their execution times. It can also execute queries in parallel by using a connection pool of multiple connections, thus simulating a real-life workload on a database.

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

webinar

Webinars 2023

We are proud to offer a series of free topical webinars which cover a variety of Data Engineering, Data Analytics and Data Science skills. Our team of consultants have prepared a series of interesting and engaging webinars to share their wisdom and experience for all data enthusiasts, business analysts and

oas

Python, XML and the OAS RPD

The Oracle Analytics Server (OAS) repository data file (RPD) is a powerful tool for creating and presenting highly functional and structured data models. However, sometimes we are asked to do something that isn't straightforward using the out-of-the-box functionality. In this blog post, we will walk you through a request to

Data Engineering

Data Engineering at Rittman Mead

The art of data engineering has been long practiced here at Rittman Mead. With the growing need for data pipelines that transform and deliver data in fast and correct format we decided at the beginning of 2023 to unite a team to work full time on projects or support specific

OAC

Oracle Analytics Cloud May 2023 Update: What's New?

The May 2023 Update for Oracle Analytics Cloud came out a few days ago and in this article I'm going to have a look at the features it includes. If you are also interested in a comprehensive list of the defects fixed by the update, please refer to Doc ID

Oracle Analytics

Web Scraping with Oracle Analytics

OCI Functions integration with data flows is one of my favourite Oracle Analytics features as it provides to business analysts and end-users full control and flexibility over specific data processing needs. In this context, Python and Beautiful Soup can join the party to extend Oracle Analytics capabilities by allowing us

EVENT: ODTUG Kscope June 25-29 Aurora, CO.

We are delighted to announce our principal consultant, Federico Venturin will be speaking at ODTUG Kscope, a global conference of the Oracle Development Tools User Group. Kscope is the premier worldwide educational conference for Oracle technology users, attracting Oracle experts from around the globe from June 25-29 to Gaylord Rockies

oracle data science

Introduction to Oracle Data Science Service Part 3

In this blog post we will look at other capabilities in the Oracle ADS SDK which can help with data exploration, as well as creating, saving, and deploying models from within Oracle Data Science Notebook Sessions.