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…
Category: Technical
Posts of a technical nature
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…
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…
Installing ODI 12c
This is a quick guide to manually installing ODI on a Windows machine. This will take a blank machine and set up a fully functioning ODI system. For this you must have a database in place already and have an account at oracle.com so you can download the software. You…
Setup Linux User
I am creating an ODI server, and the first task is to setup the linux user. This post will show how to create a user and connect to it in MobaXterm using Keys. The Tasks involved are: Create the User Set the Password Login Here I have created a session…
Oracle Analytics
Read more
Multi-File Datasets vs Multi Datasets
Managing data in Oracle Analytics can be done in a variety of ways – So how do you know which is the best way? Lets looks at the options Here’s a great video showing the muti table approach So lets recap the simple file upload methods we can use to…
Deep Dive AC36 Datasets using Data Flows
Credit: 37th America’s Cup (americascup.com) The individual races for each team are available in separate files, and we saw in the previous post that the file can be imported (into Datasets) and analysed. We are also able to create calculations on the datasets: But those calculations only exist in the…