Wrapping up Oracle AI World Connor McDonald writes that there was lots of buzz around AI but it was great to still see the high level of interest in the core database tech. Read his wrap up here. Implementing the Model Context Protocol (MCP) in Oracle Database 26ai Bruno Reis writes:…
Author: Adrian Ward
30 Years working on Oracle systems, specialising in Oracle analytics. Previously known as OBIEE, and before that Seibel Analytics
Oracle ACE
Analytics
Read more
July News
1. Using Spatial Studio to Extend / Enhance Dimensions for OAC Wayne D Van Sluys writes, “Oracle Spatial Studio is a great tool that can be leveraged to extend or enhance location based data you may already be working with in your analytic projects.” He walks us through an example…
Weekly News
Read more
May News
1.SQL Server Vulnerability: Audit Failure for SERVER_PERMISSION_CHANGE_GROUP in SQL Server 2022 This blog begins by saying, “Important Disclaimer: This vulnerability was reported to Microsoft. After assessment from Microsoft side they concluded that this is a low impact vulnerability and will fix it in a future “cumulative update” patch.” It concludes with “security…
Installing Windows Server 2025
Just a quick note to cover the install of a new Windows server on my blade. The first part of the process is to get the software. I use Microsoft Partner Centre, which seams to change the way it works, every YEAR! Annoying, but after an hour of setting things…
Install Apache Tomcat on Windows
One of the recommended webserver/app server systems to use in you ORDS/Apex stack is Weblogic, the other is Tomcat. I prefer tomcat because it is soo much quicker and easier to install, and more importantly, to configure. Pre-Requisites For this install I am using the JDK we already install (GraalVM…
Installing JDK 21 on Windows
Continuing our series on using apex to manage Oracle Analytics security. The APEX ‘Stack’ consists of five components The good news is that all of the above can be installed for free, even on windows, for you to learn from. Lets look at how we ‘install’ JDK Firstly we download…
Installing Apex on Windows
Oracle Analytics security can (and should in my view) use database tables managed using Oracle Apex. These tables can enable The reason we would do this is because user administration does not exist in OAS, the nearest you can get to it would be to use Console to manage the…
Cloud
Read more
February News
Stew Ashton writes, “Finding the difference between two dates or timestamps is hard! I am not fully satisfied with any of the solutions I have already proposed (or read), but I think this time I may have a decent answer.” 2. Step-by-Step Guide to Creating a New Forms Server in…
Automating the OAS System
Oracle Analytics Server Estate If you have chosen the Analytics Server route, either installed on your kit, or on Cloud virtual machines then you will be running the install yourself, and the patching, and the upgrading, and bug fixing. One of the key benefits of this approach is that it…
Analytics
Read more
January Reading
This blog opens with: “A couple of my students wanted me to write a switch and parameter handler for Python scripts. I wrote it just to show them it’s possible but I also show them how to do it correctly with the Python getopt library, which was soft-deprecated in Python 3.13 and replaced…