We've added Search! Well, to be precise, our blog is hosted on Ghost, and we have just upgraded to version 5.0 which includes search, see here. 0:00/1× What does this mean? Well, now you don't have to use external search engines to find pages on the Rittman Mead
APEX Oracle APEX - Social Login I looked into Social Sign-in as an option for Oracle APEX a few years ago. This was pre APEX 18.1 and, at this time, it was not simple to configure (in fact it would have taken a considerable amount of code to implement) Fortunately, since 18.1 APEX offers
OAC Oracle Analytics Cloud November 2022 Update: the New Features, Ranked The November 2022 Update for Oracle Analytics Cloud came out few days ago and in this blog post I'm going to have a look at all the new features it includes.
oas Leveraging Custom Python Scripts in Oracle Analytics Server This post illustrates how to leverage custom Python scripts in Oracle Analytics Server to give you greater control and flexibility over specific data processing needs.
Rittman Mead - de Novo Partnership 26th October 2022 On behalf of Rittman Mead I am delighted to announce the market disrupting partnership of de Novo - Rittman Mead. Oracle is a large investment for any organisation and as such it needs to be done correctly. By combining forces this new partnership gives clients access to
Commute Vs Energy App 23% of UK workers are considering ditching WFH to save on heating bills!!! Was the title of a news article that appeared on my phone at the end of August. Back then, and I say back then because the rate at which things are changing in the UK make a
How to Sense-Check Your Data Science Findings Introduction One of the most common pitfalls in data science is investing too much time investigating a dead-end. It happens to the best of us; you're convinced that you've found something amazing and profound that will revolutionise the client's business intelligence...And then, in
OAC Semantic Modeler and Version Control with Git OAC Semantic Modeler features native version control with Git
OAC Semantic Modeler and the SMML Language There are a few reasons to like the Oracle Analytics Cloud (OAC) paired with the new Semantic Modeler: * It works in the cloud. I mean, it actually works. (Check my blog post [https://www.rittmanmead.com/blog/2022/07/giving-oac-semantic-modeller-a-try/] for an overview of Semantic Modeler.) * It has a native,
OAC Giving OAC Semantic Modeler a Try Kids just love it when old folk go on about good old days. The particular good old days I have in mind is when Oracle CRM On Demand was released. Competition in the Cloud CRM space was tough but the Oracle product had one trick up its sleeve: its data
APEX 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.
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