DataVizMark
Spatial capability is a powerful feature of the Oracle AI Database 26ai allowing us to create analytics to determine things like Spatial studio has been available as a separate downloadable application for some years and is a great help to visually answering these sorts of questions and creating SQL for us to use in other […]
The March 2026 update to Oracle Analytics Cloud has a lot of great new features introducing new capabilities across visualisations, AI, and data preparation. In this article we are going to look at the metric-based colouring for heatmaps. Let’s show it in action using a fictional UK coffee chain called Daynes Coffee House UK, with […]
Many organizations desire to have as real-time as possible analytic systems that give them the capability to analyse their data sourced from various core business systems, at quite a granular level with all the built in governance and security to keep that data secure. I am being asked with increasing frequency about how users can […]
In the previous article we looked at MCP with Oracle SQLcl and analysed data from an Oracle 26ai autonomous database. Now in the Oracle Analytics Cloud November 2025 update, an MCP server is also available, and we will look at this in action. Mike Durran and Ravi Bhuma wrote a great article on setting up […]
In this article I am going to use an Oracle 26ai database, an MCP server, an agent and a LLM to ask a bunch of questions of my data and even create a chart in python – all without me having to write any code. This is not a fully detailed process for installation as […]
Oracle Fusion Data Intelligence (FDI) allows us to enhance the out of the box offering by bringing in additional data from the source Fusion Cloud Applications system. From the available data stores, called PVOs, we can select additional columns and create an augmentated dataset which can be used in extraction pipelines. With this technique, additional […]
The September 2024 release of OAC introduced the new AI Assistant. The on-line help gives a great introduction to the process of the rollout of the AI Assistant and also some caveats, most importantly “Always verify the results and consult your primary data sources before making critical decisions based on results generated by the Assistant.” […]
Oracle APEX 24.1 introduced the ability to use an AI Assistant. This can help with tasks from generating applications to providing an AI “Digital Assistant” for user interaction. In this article I show how to set up the AI Assistant and a couple of examples of it in use. Note that I chose to use […]
GenAI is clearly a hugely transformative technology. In this example I show how I used a GenAI model (in this case OpenAI) to process questions from the user of the OAC workbook and return both numeric and text responses which can then be visualised. There is a really useful guide here which explains the steps […]
I was architecting an APEX extension for an Oracle EBS customer where there was a need to call some standard APIs. These took a little while to run, and as the customer was using an APEX version prior to 23.1 we decided to submit these processes as concurrent programs. They could therefore execute asynchronously and […]