2015 to today
Explore the complete Elffar Analytics archive, from OBIEE and Oracle Analytics Cloud to AI Data Platform and agentic analytics.
66 articles
AIDP · 15 Sept 2026
Developing across Spark and Autonomous AI Lakehouse in VS Code, with the AIDP and SQL Developer extensions, gated notebook features and a practical SQL rendering workaround.
10 min readOAC · 22 Aug 2026
OAC Resource Groups allow multiple semantic models with dedicated capacity, but they do not replace separate development, pre-production and production environments.
9 min readAI · 13 Jul 2026
Enterprise AI cannot deliver trusted outcomes without strong data quality, governance, semantics and integrated platforms. The most important part of an AI strategy may not be AI at all.
3 min readAI · 20 Jun 2026
When Oracle announced that it had been named the overall leader in ISG Research’s 2026 AI and Data Platforms Buyers Guide, my initial reaction was probably the same as many people working in the data and AI…
6 min readAI · 2 Jun 2026
IntroductionOracle Analytics Cloud now includes a preview capability that allows MCP-compatible AI clients to interact with Oracle Analytics content through the Oracle Analytics Cloud MCP Server.This is interesting…
10 min readAI · 6 May 2026
In Part 1 of this blog series, I looked at why AI agents change the analytics conversation. The important shift is not simply that AI can answer questions, but that agents can keep working towards a goal, call tools,…
4 min readAI · 3 May 2026
I recently watched Hannah Fry’s YouTube video exploring what happens when AI agents are given the ability to act in the real world. The video followed an experiment with an AI agent that could operate a computer, send…
5 min readAI · 26 Apr 2026
IntroductionIn my previous post, I looked at how agentic analytics is the natural progression of augmented analytics.If augmented analytics introduced AI assistance into the analytics experience, agentic analytics…
6 min readAI · 19 Apr 2026
IntroductionAnalytics has never stood still.Over time, different modes of analytics have emerged to meet different business needs and different levels of user maturity. First came governed analytics, where trusted…
7 min readAIDP · 10 Apr 2026
IntroductionWhen I recently wrote about how to connect Oracle Analytics Cloud to the Oracle AI Data Platform catalogue, the focus was on getting the integration working end to end. That matters, because it helps bring…
9 min readAI · 1 Apr 2026
IntroductionOracle Analytics Cloud is often discussed in the context of semantic models, dashboards and AI assistants, while Oracle AI Data Platform is increasingly discussed in the context of data platform, governance…
5 min readAI · 29 Mar 2026
IntroductionEnterprise AI is one of the most widely used terms in technology today, but it is also one of the most loosely defined.In many discussions, enterprise AI is reduced to a model, a chatbot or an assistant…
5 min readAI · 25 Mar 2026
IntroductionI attended the Oracle AI Data Platform Summit in London the day after attending the Oracle AI World London 2026. While AI World provided the broader direction for Oracle’s agentic AI push across…
6 min readAI · 24 Mar 2026
Today I attended Oracle AI World London, and this year’s message was clear from the outset:This was the year of Agentic AI. Across every layer of the Oracle stack, from database to applications, the focus was on systems…
6 min readOracle Analytics · 18 Mar 2026
IntroductionOracle Analytics updates often include small usability improvements that can significantly enhance how users interact with dashboards. While major capabilities such as AI agents tend to attract the most…
4 min readAI · 11 Mar 2026
IntroductionIn a recent article, I explored why semantic models remain foundational in the age of AI-driven analytics. As conversational interfaces and AI agents become more common in analytics platforms, the need for…
4 min readAI · 9 Mar 2026
The rapid evolution of AI driven analytics is changing how users interact with data. Instead of navigating dashboards or writing queries, users can now ask natural language questions and receive analytical insights…
4 min readAI · 5 Mar 2026
When I first wrote about Oracle Analytics AI Agents a couple of months ago, one of the key capabilities I highlighted was the ability to upload documents that provide contextual knowledge to the Oracle Analytics AI…
3 min readAI · 29 Jan 2026
A common misconception about the Oracle AI Data Platform is that it represents a net new set of technologies. In reality, it is built deliberately on familiar OCI services such as Object Storage, Spark based processing,…
4 min readOAC · 28 Oct 2025
For as long as I can remember, Oracle Analytics users have been asking for one simple but powerful capability: a native Gantt chart.Something to track timelines, visualise dependencies, and monitor progress - all within…
4 min readAI · 14 Oct 2025
At a recent Oracle Analytics Partner Meeting, one demo stood out to me (the others were great as well!) - the new AI Agent for Oracle Analytics Cloud (OAC). I’ve since spoken further with the product manager and been…
8 min readAI · 3 Oct 2025
Artificial intelligence is no longer a side project. For enterprises, AI has become a strategic priority—transforming how organisations innovate, compete, and operate. Yet most businesses still struggle with fragmented…
8 min readFDI · 20 Jul 2025
In the previous post, we traced how Fusion Data Intelligence (FDI) evolved from OBIA. In this second instalment of our FDI‑introductory series, you’ll explore the underlying technology and architecture that power FDI’s…
14 min readFDI · 24 Jun 2025
Over the years, many of us working in the Oracle analytics space have helped customers implement Oracle Business Intelligence Applications (OBIA) - a powerful solution in its time, offering prebuilt analytics across…
6 min readAI · 8 Jun 2025
When we think about business data, we usually picture tidy tables and dashboards neatly populated with structured relational data. But in reality, much of an organisation’s most valuable information lives in…
7 min readOAC · 10 May 2025
The May 2025 update to Oracle Analytics Cloud (OAC) introduces a significant new feature designed to boost performance and reduce dependency on source systems: the Extracted data access mode. This new capability is…
5 min readADW · 10 Mar 2025
The Growing Challenge of Data Duplication in AI and AnalyticsAs enterprises increasingly adopt AI-driven analytics, the demand for efficient data access continues to rise. Oracle Autonomous Data Warehouse (ADW) is a…
10 min readAI · 28 Feb 2025
The rise of Agentic AI is transforming the analytics landscape, but it comes with an often-overlooked challenge: database strain. Traditionally, operational databases are ringfenced to prevent unstructured, inefficient…
6 min readAI · 14 Feb 2025
IntroductionStructured Query Language (SQL) has been the backbone of analytics for decades, enabling users to extract, transform, and analyse data efficiently. However, with the rise of AI-driven analytics, features…
6 min readAI · 25 Jan 2025
As artificial intelligence redefines enterprise technology, this blog explores the cutting-edge potential of AI Agents within Oracle Analytics Cloud - presenting a visionary look at how intelligent, autonomous systems…
6 min readAI · 23 Dec 2024
As organisations strive to make faster, smarter decisions, analytics tools must evolve to offer more than static dashboards and manual data exploration. Enter Contextual Insights, a game-changing feature set to debut in…
6 min readOracle Analytics · 16 Nov 2024
In today’s data-driven world, the ability to transform unstructured data into actionable insights is critical for organisations. With the November 2024 release of Oracle Analytics Cloud (OAC), the integration of OCI…
5 min readAI · 16 Sept 2024
Oracle Analytics have just announced the general availability of the AI Assistant. It is a new feature that allows users to interact with their data using natural language. This means you can ask questions in plain…
4 min readOracle Analytics · 16 Jul 2024
July 2024 Update - Feature Deep Dive Dataset Caching Improvements Generated with AI ∙ 16 July 2024 at 11:02 PM The Oracle Analytics Cloud July 2024 update is on its way out to the general public as this blog is being…
4 min readOAC · 3 May 2024
Oracle recently made the latest version of their database: Oracle Database 23ai generally available, the next generation of its database incorporates a number of AI capabilities. There are over 300 new features in this…
8 min readOracle Analytics · 23 Apr 2024
When you create a dataset in Oracle Analytics, the system performs column-level profiling to generate semantic recommendations for data enrichment. Additionally, when creating workbooks, you can enhance visualisations…
3 min readOAC · 30 Mar 2024
In data visualisation, it's often desirable to present both high-level summaries and detailed breakdowns within the same view. This enables users to have a view of the bigger picture while still having access to the…
2 min readAI · 26 Mar 2024
In the data-driven world we live in today, the ability to extract insights from vast and complex datasets is paramount for organisations to make informed decisions, drive innovation, and gain a competitive edge. With…
6 min readOracle Analytics · 8 Jan 2024
REST (REpresentational State Transfer) APIs (Application Programming Interface) are a way for software systems to communicate and share data over the internet using HTTP requests. REST APIs enable different systems to…
4 min readOracle Analytics · 14 Dec 2023
Photo by Tyler Nix on Unsplash Parameter binding in Oracle Analytics Cloud refers to the ability to bind prompt values to filter components (for example) in data visualisation workbooks. The November 2023 update…
3 min readOracle Analytics · 12 Nov 2023
Oracle Analytics Cloud (OAC) and Microsoft Power BI are two of the most popular platforms organisations use for data visualisation, reporting, and business analytics.It is common for companies today to have a "hybrid…
4 min readOracle Analytics · 22 Sept 2023
Unless you’ve been living under a rock, you won’t be surprised to know that the main theme of CloudWorld this year at Las Vegas was generative AI.Almost every Oracle product from databases, to Fusion applications, to…
6 min readOracle Analytics · 20 Aug 2023
In the dynamic landscape of data analytics, businesses are in search of a comprehensive solution that seamlessly integrates data governance, self-service analytics, augmented insights, and robust reporting. Oracle…
5 min readAI · 23 Jul 2023
In the July 2023 update, Oracle Analytics Cloud has introduced a new feature called AutoML. Oracle AutoML, or Oracle Automated Machine Learning, is a feature within the Oracle Cloud Infrastructure (OCI) platform that…
4 min readOracle Analytics · 24 Sept 2022
The Oracle Analytics REST API Connector is now available in the September 2022 Oracle Analytics update in preview mode.The connector now allows access to data directly from REST API endpoints.To access the REST API…
3 min readOAC · 29 Dec 2020
Photo by Isaac Smith on Unsplash The Oracle Analytics team have been busy working on the latest version of Oracle Analytics Cloud - 5.9 which is packed with a number of interesting features and enhancements that we'll…
6 min readOAS · 15 Nov 2020
A very quick blog post to provide some information about an issue that may arise with Data Visualisation projects based on manual SQL queries in Oracle Analytics Server 5.5 and above. These queries would have worked in…
1 min readOAC · 16 Jul 2020
Photo by Tomas Anton Escobar on Unsplash Version 5.7.2 of Oracle Analytics Cloud recently started rolling out to Cloud Customers. It comes with a couple of cool features which we'll go through in some detail. A full…
3 min readOAC · 12 May 2020
Photo by Mitchell Hollander on Unsplash The Oracle Analytics product teams have been working round the clock to put the finishing touches to the latest version of Oracle Analytics Cloud which has just been released.…
3 min readOAS · 3 Mar 2020
Daniele Levis Pelusi Oracle Analytics Server 5.5.0 was recently released and I've been testing out the OAS installation process. This short blog post just goes through some issues that I encountered during this process…
2 min readOracle Analytics · 13 Feb 2020
Elena Koycheva The Oracle Analytics Product Management team descended on London ahead of the Oracle OpenWorld Europe event for the Oracle Analytics Summit London event held at The Soho Hotel in London on the 11th of…
3 min readOAS · 2 Feb 2020
After a very long wait, the successor of OBIEE is here. Oracle Analytics Server was made generally available on Friday the 31st of January. Oracle Analytic Server (OAS) 5.5 is Available https://t.co/FCDAwW0ItF— Oracle…
3 min readOBIEE · 20 Dec 2019
To the uninitiated, OBIEE 12c installations on Windows are very challenging to say the least. An #obihackers colleague who had the pleasure of working on an 11g - 12c OBIEE Windows OS upgrade, stumbled across these…
2 min readOAC · 28 Aug 2019
Oracle recently released Data Gateway as the successor to Remote Data Connectorin the Oracle Analytics Cloud 105.3 release earlier this year.Remote Data Connector was originally part of the Oracle Analytics Cloud, OAC…
2 min readOracle Analytics · 27 Jun 2019
Oracle Analytics - A Fresh Start Unless you’ve been hiding under a rock this week as well as steering clear from all forms of social media, then you would have heard about the Oracle Analytics Summit which took place at…
3 min readOracle Analytics · 17 Feb 2019
The purpose of this blog post is to highlight the results of a number of Research Analysts reports that have been recently published on Analytics platforms and how Oracle Analytics Cloud measured up with other…
2 min readOracle Analytics · 17 Jan 2019
The 1st edition of Oracle Openworld Europe took place earlier on the 16th and 17th of January 2019 here in London and the turnout was very good with estimates of 10000 people in attendance. There were hour long queues…
2 min readOracle Analytics · 21 Dec 2018
Recently a fellow obihackers group member (HT - @BecWagner) asked me how I gain quick access to the wide array of information that Oracle provides. Over a vast period of time, I have built up a number of techniques…
2 min readOBIEE · 10 Aug 2018
I'd start this blog by issuing a warning that Direct Database requests should be used sparingly. A Direct Database Request (DDR) bypasses the OBIEE metadata defined in the repository and this can have security…
1 min readOBIEE · 16 May 2018
Whilst running the exportServiceInstance WLST API command on an OBIEE 12.2.1.3 instance to generate an OBIEE 12c BAR file, I got this warning message: In 12.2.1.4, however, the warning is now an error message: There…
2 min readOAC · 23 Dec 2017
Oracle have just released a major update to Oracle Analytics Cloud (OAC).A major change that will be immediately evident is the change to the User Interface. It is now in line with the Interface that exists in Data…
1 min readOracle Analytics · 8 Dec 2017
Earlier this week, Elffar attended the U.K. Oracle User Group in Birmingham. There were a large number of Analytics focused sessions which we attended and it was a great experience. This blog post highlights the key…
2 min readOBIEE · 11 Nov 2016
Part of the OBIEE upgrade includes a migration of the OBIEE 11g artefacts. The migration script provided by Oracle upgrades and migrates the Web Catalog and the Repository. This script doesn't migrate WebLogic users. In…
1 min readOBIEE · 19 Dec 2015
Oracle recently released the much anticipated SampleApp virtual box (version 511) which comes packed with OBIEE 12c and all of its great new features. You can download it here. SampleApp usage has always been a great…
1 min readOBIEE · 5 Nov 2015
On a project I recently worked on, We were required to change the Managed Server port number. This could be required for a variety of reasons but most oftenly, its to change the OBIEE URL to exclude a port number.In the…
1 min readOBIEE · 27 Oct 2015
OBIEE 12c is now available for download on Oracle's website. OBIEE 12.2.1.0.0 was made available on Friday evening (23rd October).The highlights of this new version are Oracle's tool which looks set to squeeze Tableau's…
1 min read
