WE LOVE TO SHARE
So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.
Oh Data!
It is not uncommon for data warehousing to get the data from any possible source the organisation has. ETL developers like myself are enabling data collection from different database types, files and APIs. Recently I had to deal with something I haven't came across...
Want to design a visually stunning Application using Apex?
I recently started using Oracle Application Express. One of my goals was to understand how to customise the UI to make it beautiful and informative. Every web developer wants their application to be different and unique. It’s no surprise that I wanted my application...
Celebrating the digital technology ecosystem
A couple of years ago over a few quiet drinks, Raj and Mike of Access Granted had a brilliant idea to start a Christmas event for everyone who, like them, is self employed, a contractor, a freelancer or who work in a very small business and don't have a conventional...
What’s cool in BI from re:Invent
AWS re:Invent has just happened, and with it a huge number of announcements across the whole AWS portfolio. As usual there were so many announcements that its a bit hard to keep track of them all, so I thought I would pull out most of the announcements related to BI...
Now Featuring!
Recently I was asked during an interview how I would approach adopting new features in Oracle as part of an upgrade. At the time I feel I gave a pretty cursory reply and I just explained how I’d performed an upgrade (migration) across platforms and had implemented new...
Scaling basics on AWS: Horizontal and Vertical
Scaling is a large part of why running applications in the cloud is a good idea, but the different approaches to scaling are often not talked about in much detail. So I thought I would quickly cover off some of the options when it comes to scaling on AWS (though these...
Starting the day with hugs
Our philosophy here at OptimalHQ has always been to amplify and support the great works of organisations who enable our vulnerable communities or who provide resources focused on building capability. To that end in 2018 we have raised money, donated time and goods to...
Store Your Data in a Cool and Dry Place
When it comes to the data storage in Business Intelligence, you have options of having an Operational Data Store (ODS), a Persistent Stage (PSA) and a Data Warehouse (DW); all of them are just databases though. I have noticed that sometimes these terms are used...
What is ELM?
Enterprise Integration Platforms, such as the Enterprise Data Warehouse, store integrated data in a common database. The features of this common target schema typically include: Enterprise-wide scope, Auditable data, Data sourced from several source systems, A...
What’s on in Wellington for data geeks
Kia ora and welcome to November! Once again, we're moving swiftly towards the end of the year wondering how that happened so quickly! Thank you for being part of the OptimalBI whānau in 2018. We hope you enjoy all the festivities over the coming weeks and have a...