Trying out the Oracle Cloud Platform

One of the great things of working with Oracle is the possibility to try things out………., for free. Yes, some things at Oracle are indeed free ūüėÉ!! There are various places where you can download Oracle (related) software / scripts / examples / etc., so you can try things out.

You should create an account on OTN (Oracle Technology Network) and download the software you want to try out. Also on OTN, you can find pre-built Virtual Box Appliances, so you can start trying out software without the hassle of installing it yourself. Check out various examples and scripts for Oracle in general here or for Oracle Analytics in specific in the Oracle Analytics Store. This is just a brief example of all Oracle related info you could find online.

There is a large Oracle Community (both online on e.g. Twitter, the Oracle Forums or good old IRC as well as offline e.g. at the various User Conferences) where you can exchange your knowledge on all different topics in the Oracle Red Stack.

The last few years Oracle is making the move to the Cloud. Although the platform in the Cloud is the same as On-Premise, people still want to try things out. Fortunately Oracle offers the opportunity to try things out in the Cloud. Navigate to the Oracle Cloud Trial Page.

Experience Oracle Cloud with $300 in free credit

Oracle sends various announcements out into the public to try out their Oracle Cloud Platform.

“Try our Platform. You can get $300 in free credit to make the most of all the features. See how:

This is great or at least it sounds great. As part of my Gathering new Knowledge experience, I tried out the Data Lake Self Guided Tutorial. Therefor I signed up for an Oracle Cloud Trial, where I created an Object Storage Instance, and a Big Data Cloud Service РCompute Edition (BDCS-CE) Instance. It was nice to see some of the possibilities and tried things out.

Unfortunately after 30 days my trial (not my credits!) was over. I received several mails that my trial period was extended and therefor my services have been terminated. The only option was to convert my Free Oracle Cloud subscription.

I also tried to setup a new environment. With no succes unfortunately. It looks like I need a new account and probably a new credit card to make this work.

I hope Oracle will come up with another solution to keep the Oracle (Cloud) Community as active and alive as the Oracle On-Premise Community.

Thanks for reading.

Data Architecture in a digital world; empowering the Data Driven Enterprise

Data is playing an increasing important role in organisations today. If you want to stay ahead of the competition you need to do things differently and preferably better than they do. This means you have to start initiatives. Initiatives which most likely involve an IT component. IT initiatives which are fed by reliable information / insights. These reliable information / insights com from various kinds of data.

Being Data Driven as an organisation is not something you can just turn on. There is more to data than just IT. To be able to be a really Data Driven, an organisation performs a Data Management discussion throughout the whole organisation.

Daan Rijsenbrij, assited by Ronald Damhof and Martijn Evers, is researching data architecture as it manifests itself in organisations. The purpose of this research is to investigate the maturity in the thinking about & working with data in modern enterprises. Check more details here.

Thanks for filling in the survey.

Gathering new knowledge

Last June I was present at the nl_OUG Tech Experience 2017. These kind of events are not only interesting because of the networking possibilities. One of the most valuable aspects  is the fact that people are sharing their knowledge. The Oracle community is a very active community so there were two days of intensive knowledge sharing. I wrote two blogpost to give a short impression of the 15th and the 16th of June.

I am active in Oracle related environments since the late ’90s. The world back then compared to the world today is completely different. We entered the “The Fourth Industrial Revolution”.¬†New technologies and different ways of working, collaborating and communicating force us to change the way we act. This means learning new things. Tim Hall is writing a serie of blogposts¬†about learning new things.

Following several presentations and keynotes at the “nl_OUG Tech Experience 2017” proved to me that there is a lot to learn. Even when I was preparing for my own presentation.

When searching for information and talking to several people it turned out that I learned new things along the way.¬†After two days I had enough subjects to start investigating. It is so much that I had not got a clue of where to start. Lot’s of things are interesting. I decided to just have a go and see where it leads to.

Blogging gives me the opportunity to store my findings and share it with the rest of the world. I know that at least I will benefit from this.

There are three subjects in general were I want to share my findings. I will share these findings from one central blogpost where I will link to various other posts.

When these posts are ready, I will update these links. I hope you will find my findings interesting. Please share your comments.

Thanks for reading.

The Quistor Business Analytics & Big Data Practice is expanding

Working at Quistor

 

We are expanding our Quistor Business Analytics & Big Data Practice. Therefore we are looking for new colleagues. Please find the vacancies for a Senior Oracle Business Analytics Consultant and a Senior Oracle Data Integrator Consultant below.

Please get into contact with me or send a mail to jobs@quistor.com. If you are not interested yourself, but know someone who might be, I would really appreciate it if you would let me know.

Thanks in advance.

Daan Bakboord

Managing Consultant Quistor Business Analytics & Big Data. Managing and developing the Oracle Business Analytics Practice in the Netherlands. Because of the DNA of Quistor I have a strong focus on Oracle Business Analytics (OBIEE, BICS &OBIA) and Oracle JDEdwards. Next to that I have strong interest in (the Architecture of) Business Analytics and Data Warehousing in general (TOGAF, ArchiMate and CBIP) and Oracle Business Analytics Architectures in specific.

OTN Appreciation Day : Dual Table

otn-appreciation-dayI have been working with Oracle products for about 20 years now. One of the great things about Oracle is the Oracle Community. Central platform within this community is the Oracle Technology Network (OTN). I have been frequenting OTN loads of times (downloading software, exchanging knowledge on the forums, etc. ). A lot of people I know in the Oracle Community, I have met via OTN.

Today I read the OTN Appreciation Day announcement on Tim Hall’s blog.

“considering OTN is all about community, I figured it would be fun if we got as many people as possible to write a small blog post about their favourite Oracle feature and we all post them on the same day”

I immediately thought about the Dual Table in the Oracle database.

Dual Table

What I like about the Dual Table, is that something which looks so simple can be so powerful. You can select the date, the length of a string, the result of calculation and so on. One simple table, with just one varchar dummy column is able to tell you almost everything you want.

I can illustrate how powerful the Dual Table is by a short anekdote. The story could be a little bit different but it’s all about the scope. One of my former colleagues (I won’t tell his name) wanted to test part of his code. Therefore he decided to insert a record in the Dual Table. I think it was in the Oracle database version 7 / 8 timeframe. It might have been a smart move in his mind, but it was disastrous for the application running. Very slowly the application collapsed. The application code expected one row when selecting from the Dual Table. It took some time to realise that the Dual Table contained an extra record. As far as I know the functionality of the Dual Table has changed since then, but I guess there is no need at all to mess with the Dual Table.

Curious what other people have to share on OTN Appreciation Day, check here.

Cheers,

Daan

BIWA SIG Bijeenkomst op donderdag 26 mei 2016

Donderdag 26 mei 2016 was er een BIWA SIG Bijeenkomst van de OGh. De onderstaande onderwerpen zijn behandeld:

Metadata Management met Oracle Enterprise Metadata Management (OEMM). Eric van Ettekoven van Oracle gaf ons een introductie van deze tool waarmee zowel Data Lineage als Impact Analyse van Informatie systemen een stuk eenvoudiger wordt.

De presentatie van Eric is hier; http://bit.ly/OGh26052016oemm te downloaden.

Robbert Naastepad van MN gaf ons een inkijk in de Informatie Architectuur op basis van Oracle Data Integrator in combinatie met de Exa-hardware (Exadata & Exalogic) van Oracle. Robbert liet zien tegen welke uitdagingen je in deze betreffende architectuur kunt aanlopen en behandelde mogelijke oplossingen.

Ook de presentatie van Robbert is te downloaden en wel hier; http://bit.ly/OGh26052016ODI_Exa.

Over een volgende BIWA SIG Bijeenkomst wordt ook al nagedacht. Deze zal waarschijnlijk ergens na de zomer gehouden worden.

Mogelijke onderwerpen:

Oracle R (klantcase)
Oracle BI Cloud Service (klantcase)
Data Virtualistie
Oracle BI and Spatial

Mochten er andere interessante onderwerpen zijn laat dan even een berichtje achter of neem contact met mij op.

Hopelijk tot een volgende keer!

Daan Bakboord

BI & Analytics – Agile BI and / or Enterprise Reporting?

As I wrote in my last blogpost, Gartner’s latest version of the¬†Magic Quadrant for Business Intelligence and Analytics Platforms () caused a lot of noise in the Analytics Market. Gartner and Oracle have different views of this market. Gartner sees a difference; “between a modern BI and Analytics Platform and a traditional, IT-centric Reporting and Analysis Platform”. I think this; ‘Behind the Scenes‘ gives some more background about how Gartner has put this Magic Quadrant for Business Intelligence and Analytics Platforms together. Find Part 2 of the story in the Market Guide for Enterprise-Reporting-Based Platforms.

It’s clear that Oracle and Gartner have a different view on the Analytics Market. It seems that also the different Analysts see things differently. To get a more complete view of the Analytics Market, it is good to evaluate the Value Index from Ventana and the Forrester Wave‚ĄĘ as well.

If you are on Twitter, you should check the following hashtags; #BalancedBI, , There are some interesting discussions going on.

Daan Bakboord