Our Blogs

WE LOVE TO SHARE

So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.
SAML Proof of concept – Part 2

SAML Proof of concept – Part 2

Following on from my previous blog this is where things get harder, well more typing and less clicking anyway. The next piece of the puzzle is, if I deploy something bespoke on Apache can I secure it? I found two guides for installing Shibboleth, there is one on the...

SAML Proof of concept – Part 1

SAML Proof of concept – Part 1

The minimal proof of concept for any SAML solution is to secure two different websites with SAML. For this I decided to secure an off the shelf SAML ready product we had already installed (Qlik Sense) and a simple bespoke application running on Apache. This blog cover...

SAML for this dummy

Many years ago I had the unforgettable experience of being exposed to Oracle Single Sign On (SSO) on a number of occasions. The basic idea is that you log in once to a web page and you can use different web applications without re-authenticating. I never saw it work...

Oracle Apex Dynamic Page Item Help

Oracle Apex Dynamic Page Item Help

I'm Ben Lee I'm into report development, data integration and data modelling. In this blog I explain how I helped a customer manage their own help text. Recently I had the scenario where a customer wanted to be able to manage their own help text for a page in an...

Hans Hultgren – Data Vault Course 2015

I recently attended a course run by Hans Hultgren on Data Vault Modelling. I have a small confession to make at this point; Sorry Hans, I've never read your book. The good news for me was that the course doesn't require you to have read the book first. It does assume...

Impression of BEAM✲

It’s been over a month since I went on the Lawrence Corr Business Events and Analysis Modelling (BEAM*) course. I wish I could say that straight after the course I applied everything I had learned but my current project was not data warehouse related. It does however...

AWS Toolkit for Eclipse

I've been tasked with doing some integration development with some AWS components using Java. Luckily Amazon provide a Java SDK and eclipse plugin to make your life easier. Installing it is quite simple. Make sure you have the Eclipse IDE for Java EE Developers then...

Redshift COPY vs Mac newline

I recently had an issue with an CSV upload into Redshift that I had previously performed dozens of times using the COPY command. It was strange issue, the command completed successfully and there were no errors in the stl_load_errors table however there were no rows...