Rittman Mead (Page 7)

Oracle APEX - Basic Business Questions

It could be the case that you have heard of Oracle APEX lately. Maybe not just once, but a couple of times and maybe more often than ever before. We I will try to answer a couple of basic questions in this blog, that might help you understand why Oracle

Oracle Analytics Summit 2022

Last week I attended the second Oracle Analytics Summit at Skywalker Ranch [https://en.wikipedia.org/wiki/Skywalker_Ranch]. The last Summit was in 2019 and attended by Jon Mead and he summarised the experience here [https://www.rittmanmead.com/blog/2019/07/oracle-analytics-summit-2019/]. The purpose of the event is

Data Lineage

Tracing Data Lineage from Source Column to End User

A while ago I blogged about our Lineage Tool [https://www.rittmanmead.com/blog/2022/04/introducing-rittman-mead-lineage-tool/] , which back then was limited to diving into the ODI Work Repository and emerging from it with source-to-target data flow diagrams. The task at hand was simple and the design straightforward: show Source

OAS / DV & HR Reporting (A Learning Experience Part 2)

Until recently as a relative newbie to Oracle Analytics Server (OAS) and Oracle Data Visualisation (DV) myself, I was keen to share with you this learning experience. If you are a HR professional, or you work supporting HR with data and reports, this blog is aimed at you. My intention

A quick way of generating Informatica PowerCenter Mappings from a template

Generating Informatica PowerCenter Content - the Options In our blogs we have discussed the options for Oracle Data Integrator (ODI) content generation here [https://www.rittmanmead.com/blog/2021/03/sql2odi-part-one-convert-a-simple-select-statement-to-an-odi-mapping/] and here [https://www.rittmanmead.com/blog/2017/03/accelerating-your-odi-implementation-rittmanmead-style/] . Our go-to method is to use the ODI Java

oas

Analyzing Brand Reputation with Oracle Analytics

This post illustrates how to use Oracle Analytics to perform brand reputation analysis without machine learning or marketing experience.

Oracle HR Sample Schema Oracle Analytics Server Dataset

OAS / DV & HR Reporting (A Learning Experience)

I wanted to share a personal learning experience around HR reporting using Oracle Analytics Server (OAS) and Data Visualisation (DV). In my experience, more often than not, the old school Oracle BI development tool skillset (BI Apps / OBIEE / BI Publisher) usually reside in the IT department. Often IT cannot respond

ODI Lineage

Introducing Rittman Mead Lineage Toolkit

Introduction Rittman Mead Lineage Toolkit analyses ODI Mappings and produces neat visualisations of source-to-target mappings. The Lineage Toolkit is quick to set up and easy to run. Rittman Mead Lineage Tool: from ODI Mappings to Mapping Lineage VisualisationThe Lineage Toolkit can be used to reverse-engineer legacy ELT logic as the

oas

Oracle Analytics Server 2022 (6.4): The Best 15 New Features, Ranked

OAS 6.4 is finally live and provides a big set of enhancements that had been already available to OAC users. New features mostly affect the Data Visualization tool and involve the full process flow, from the data preparation to the data presentation, including visualizations, machine learning and administration improvements.

Unify 10.0.49

A new release of Unify is available, 10.0.49. This release includes support for Tableau 2021.4.

data lake

The role of Data Lakes or Staging Areas for Data Warehouse ETL

We were asked recently by a client, about the role of a staging area for ETL processes when loading a Data Warehouse, specifically they wanted to know if this was still required if using a Data Lake.

Exploring Mapbox integration in OAC 6.2

Mapbox has risen in aiding numerous businesses with its high-performance platform, delivering real time mapping by collecting and processing live anonymous sensor data from users globally. OAC 6.2 was released with some Mapbox integrated features, meaning it was time to test them. One of Mapbox’s many use cases,

Text mining in R

As data becomes increasingly available in the world today the need to organise and understand it also increases. Since 80% of data out there is in unstructured format, text mining becomes an extremely valuable practice for organisations to generate helpful insights and improve decision-making. So, I decided to experiment with

Rittman Mead Sponsor Fastnet Entry 2021 Part 2

It started well… we left the pontoon in strong winds and heavy rain. Before the start of Fastnet everybody has to sail past an entry gate with storm sails or equivalent flying. The winds were strong enough to sail with them and a bit of engine assist so we enjoyed

Rittman Mead Sponsor Fastnet Entry 2021

Part one. In 2002 my wife Val and I decided to buy our first yacht. We lived in the Brighton so it seemed to make sense. In 2005 we replaced our first boat with a Sigma 400 [https://sigma400.com/]. A Sigma is a well made boat so it seemed

Sql2Odi now supports the WITH statement

The Rittman Mead's Sql2Odi tool that converts SQL SELECT statements to ODI Mappings, now supports the SQL WITH statement as well. (For an overview of our tool's capabilities, please refer to our blog posts here [https://www.rittmanmead.com/blog/2021/03/sql2odi-part-one-convert-a-simple-select-statement-to-an-odi-mapping/] and here [https:

OAC

Joining Data in OAC

One of the new features in OAC 6.0 was Multi Table Datasets, which provides another way to join tables to create a Data Set. We can already define joins in the RPD, use joins in OAC’s Data Flows and join Data Sets using blending in DV Projects, so

Oracle Support Rewards

First of all, what is it? Essentially, it’s a cashback scheme. For every Dollar, Pound, Yen, Euro you spend moving to OCI (Oracle Cloud Infrastructure), Oracle will give you 25% off your annual support bill. It’s a great incentive for cloud adoption and has the potential to wipe

SQL Query to ODI Mapping Translation

Sql2Odi, Part Two: Translate a complex SELECT statement into an ODI Mapping

Discusses translation of complex SQL SELECT statements (queries) into ODI Mappings. Shows Sql2Odi in action.

ODI Content Generation with Groovy

Sql2Odi, Part One: Translate a simple SELECT statement into an ODI Mapping

Discuss Groovy scripting for Oracle Data Integrator (ODI) to generate ODI content. Discusses translation of simple SQL SELECT statements (queries) into ODI Mappings.

analytics

Rittman Mead sponsoring RMOUG

After enjoying a successful 2020 in the North American data and analytics market, we’re excited to announce that we’re sponsoring Rocky Mountain Oracle Users Group (RMOUG) this year! Running from 8th - 11th February, the agenda is jam packed with content including interactive workshops and technical sessions all

OAC 5.9 - A Tour of the UX Enhancements

Now that we are nicely settled into 2021 (Happy New Year, by the way!), it's time to roll our sleeves up and take a look at the latest release from the Oracle Analytics team: Oracle Analytics Cloud 5.9. Whenever a new release arrives, there is often a

oas

Using the Go-URL in OAS

An alternative method of using the Go URL under OAS without disabling data visualizer.

Oracle analytics cloud

Analysing Social Media Activity with ADW and OAC

Analysing Twitter Activity using the Oracle Text features within the Oracle Database, Oracle Analytics Cloud and SQL Developer Web!

OAC

OA Summit 2020: OA Roadmap Summary

Summary of Oracle Analytics Roadmap Announcements made at OA Summit 2020