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…
Author: Adrian Ward
30 Years working on Oracle systems, specialising in Oracle analytics. Previously known as OBIEE, and before that Seibel Analytics
Oracle ACE
Oracle Analytics
Read more
October Reading
Nikhil Kotak shares abuot: 2. Should you use the Override and/or Replace Features? Jim Marion asks this question! He ends the blog by saying, “The Override/Replace features are fantastic for REPLACING Oracle’s delivered code. In other words, if you don’t want Oracle’s code to run at all, then override or…
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…
Analytics
Read more
End of Summer Reading
1. Staging Tables in Oracle 23ai Dani Schnider begins this blog saying, “Browsing through the Oracle 23ai New Features Guide, I once again discovered a small, inconspicuous feature that I had previously overlooked: There is a new option to create stage tables. What is the advantage of this enhancement?” 2. Separating…
Analytics
Read more
Some Summer Reading
1. Installing Xfce on Oracle Linux 9 Martin Bach shares, “This post explains how to install Xfce on Oracle Linux 9.4 x86-64 using the EPEL (Extra Packages for Enterprise Linux) repository. I’m fairly sure the same applies to ARM64 as well, but I didn’t have time to test. The article is based on…
Analytics
Read more
The Best of May
1. Compatibility Issues David Fitzjarrell begins with: “Oracle can be set to use a broad range of version settings, controlled by the compatible setting. Normally upon install this is set to the current version of the database that’s been installed. There may be times, however, when a lower compatibility setting…
Analytics
Read more
April’s Best Blogs
1.Configuring Shared Global Area (SGA) in a Multitenant Database David Kurtz shared, “I have been working on a PeopleSoft Financials application that we have converted from a stand-alone database to be the only pluggable database (PDB) in an Oracle 19c container database (CDB). We have been getting ORA-4031 (unable to…
Analytics
Read more
April News
1.Connection to Oracle Autonomous Database In this blog, Selvakumar Nagulan explains how to connect to an Oracle Autonomous database using SQL developer, SQL plus or other tools. He refers to this document in his blog. 2. Reading a LOB in another session Martin Berger begins by saying, “Reading a LOB in…
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…