Rittman Mead (Page 5)

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

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

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.

Oracle Analytics

WEBINAR Oracle APEX: A Swiss Army Knife Story for Your Analytics

Date & Time: May 4, 2023 - 5pm (GMT) Presented by Rittman Mead's Lucas Hirschegger & Simon Collins this webinar will be hosted for the Analytics and Data Oracle User Community, focusing on Oracle APEX and its capabilities in data management. Data management is an essential component of

oas

Installing Oracle Analytics Server 2023 Update

Oracle Analytics Server 2023 Update has been released recently and in this article I'm going to illustrate how to install it step by step.

Modernising Your Oracle Infrastructure

Do you have on-premises Oracle data management, applications or 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"?

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.

Oracle Analytics

Oracle Model Administration Tool Available on Linux and macOS

The Model Administration Tool is a fundamental component of the Oracle Analytics suite that enables developers to create and manage the metadata used in analyses, reports and workbooks. So far the tool has been available only on Windows platforms, but today is a date to be remembered: Oracle finally released

oracle analytics server

Oracle Analytics Server (OAS) 2023 Update

The latest version of Oracle Analytics Server OAS 2023 has just been released, which supersedes OAS v6.4. This week in the Rittman Mead R&D lab we’ve found the missing download files, collated a list of associated patches and developed a blueprint for an in-place and out-of-place

OAC

Leveraging OCI Functions (Custom Scripts) in Oracle Analytics Cloud - Part 2

In a previous article I illustrated how to create OCI functions from scratch. Now it's time to show you how to register your functions in Oracle Analytics Cloud and invoke them from data flows to transform your data.

Data Governance

Is Your Data Worth Managing?

One thing that is certain about data governance and, dare I suggest, one major factor in why it is often overlooked or actively avoided…is that it is complex.

OCI Functions

Oracle Cloud Infrastructure – Everything Oracle All At Once

Oracle Cloud Infrastructure (OCI) feels like it gives you all the parts of Oracle, providing you the capability to create, manage and monitor many functions via this platform.

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.

OAC

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

The March 2023 Update for Oracle Analytics Cloud came out 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

Being Groovy without an ODI IDE

In this blog post, we will show you how to execute Groovy scripts outside of the ODI IDE, opening up the opportunity to include the scripts in workflows and pipelines.

Breaking the Assumptions of Linear Regression

Linear Regression must be handled with caution as it works on five core assumptions which, if broken, result in a model that is at best sub-optimal and at worst deceptive.

OAC

Leveraging OCI Functions (Custom Scripts) in Oracle Analytics Cloud - Part 1

Leveraging custom Python/R scripts in Oracle Analytics Server; unfortunately, the custom script feature is not available in Oracle Analytics Cloud, but you should not worry too much about it as there is an alternative: OCI functions!

Odi2Package tool - reverse-engineers and generates ODI Packages

Introducing new reverse-engineering capability In my previous blog post, I introduced our new Odi2Package tool that allows you to auto-generate ODI Packages. Our ODI development teams were quick to adopt the tool for their project needs. Soon, however, we noticed a significant weakness: the manual creation of templates for new