DataVizMark
AI Agents are proliferating across many tools and now Oracle APEX 26.1 introduces built in both AI Agents and AI Tools. To demonstrate this facility, I will use the EMP and DEPT tables from my Oracle 26ai database and build a small People Cost Review page within an application which invokes an AI agent supported […]
One of the “marquee” features of the new Oracle APEX 26.1 release is the ability to add natural language queries to Interactive Reports (IR). So, as well as having full IR ability, the user can ask a question like “show me all employees in Sales earning more than 1500” as an alternative to manually setting […]
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 […]
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 […]