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.

Oracle Mobile Analytics

Imagine yourself without a mobile device. There was a time we used our mobile phone to make calls only. Ok, we did some text sending via sms. But that was it. Nowadays (if I look at myself) I do not use my phone to make phone calls. Yes, when I am in the car the phone comes in handy to speak to others and to kill time. The main reason I use my phone is to lookup information or to interact with other people. This is not by speech but by sending messages.

In lot’s of situations the smartphone or the tablet have taken over the role of the desktop computer. The same goes for Analytical Applications. People use their mobile devices to run analytics where the used to do that via their pc connected to the local network.

Also Oracle has a strategy for mobile analytics. Oracle currently offers three different mobile apps for analytics:

  • Oracle BI HD
  • Synopsis
  • Day By Day


Although it looks a little bit confusing, there just is a separate app for a different purpose.

Oracle BI HD is Oracle’s first mobile application for analytics. It’s basically another platform to run your desktop reports. Oracle BI HD can be licensed on top of on-premise OBIEE and is integrated with the Cloud license.

If you download the application from the app-store (Apple in my case) you can just connect to any Oracle BI Server you have available. I chose to connect to our Quistor BI Cloud environment. Of course you can add any other Oracle BI Server URL you want to connect to.





You have to enter a host. In the case of the Quistor BI Cloud environment you will enter the Service Instance URL which you can find in the BICS Service Details.

After the server is added and you connect to it, you have to enter the login details. This is similar to logging into the BICS environment.





Now you enter into the Analytics Environment where you have access to the same dashboards as you have available in the Cloud. Check here the General Ledger Dashboard of our Quistor BINGO environment.

The same dashboard on the left as it shows on my smartphone. Of course you do not have the same experience as on the desktop or even the tablet. But it is nice that you can bring your dashboards with you and analyse data while being on the road.




Synopsis allows a user to analyse files (received on) a mobile device without the need to access a Oracle BI Server.

Imagine you have an Excel spreadsheet available in a Box Cloud environment. In this case it is the Pipeline.xlsx.

After you download the application from the app-store (Apple in my case) you can import this spreadsheet directly into the Oracle Synopsis mobile application.



After the data is imported into the application, you have a project with the imported spreadsheet.



You can immediately analyse the Pipeline data. The application already prepared some analysis for you based on the data it finds.

Check out Youtube to see Oracle Synopsis in Action.





Day By Day is Oracle’s latest addition to the Oracle Mobile Application offering. This application is different from the Oracle BI HD application. You will use search technology, either by voice or by typing, to create your analysis.

You can download the application from the app-store (Apple in my case).

Starting up the application allows you to enter. One of the prerequisites of this application is an Oracle Analytics Cloud¬†(OAC) environment with BI Author and DV Consumer roles. At this moment I do not have an OAC environment at my disposal. There is a demo included in the app. Select ‘Try a Demo’ and after you are welcomed to the application you can start analysing data.



Via a typed or spoken search string (in this case; ‘revenue per customer segment’ you can create an analysis.








This search leads to the graph on the right. Of course this is only an easy example. For more details and examples, please have a look here.





Interesting applications to check out. They might not all be evenly useful, but it’s good to have a choice of functionality to satisfy your mobile analytical needs. What I don’t get is that all the applications start with a blue screen. Not the bsod, but why Oracle did not choose an Oracle Red startup screen is a mystery for me.

This post is written as part of my Exploring Oracle Business Analytics series.

Thanks for reading.

Exploring Oracle Business Analytics

In the blogpost about “Gathering new Knowledge”¬†I decided to investigate a few different areas of the Oracle atmosphere. Oracle Business Analytics was one of them. In a series of different blogposts I will cover different parts of the¬†Oracle Business Analytics ¬†product suite. At the end of this post there will be a list of different links to the blogposts I will be sharing.

I will begin with a post I created earlier. This is because of the importance of the subject. One crucial element in Oracle Analytics is the Oracle BI Server. Thanks to Christian Berg, we were able to go to the Core of Oracle Analytics.

Last month Oracle released a new version of Oracle Data Visualization V3.0. In this upgraded version you can expect some new functionality regarding:

  • connections to data sources & data preparation,
  • enhanced data flow
  • intuitive data visualization process setup & formatting
  • comprehensive system management toolset

When the posts are ready, I will post the links below. I hope you will find my findings interesting. Please share your comments.

This post is written as part of my Gathering new Knowledge series.

Thanks for reading.

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.

Oracle Data Visualization V3.0

Last month Oracle released a new version of Oracle Data Visualization V3.0. In this upgraded version you can expect some new functionality regarding:

  • Connections to data sources & data preparation,
  • Enhanced data flow
  • Intuitive data visualization process setup & formatting
  • Comprehensive system management toolset

Check out the presentation of Philippe Lions below where he gives a tour of the Oracle Data Visualization V3.0 new features.

 did an excellent job outlining the new features. Also Francesco Tisiot has put his thoughts about V3 into a blog.

You can also directly have a look at this Youtube video below.

If you want to have a more detailed look (also mentioned in  blogpost), please check out these Oracle PM video playlist.

The opportunities within Oracle Data Visualization are expanding and improving. Sometimes it is just too much to catch up with. Fortunately there is the Oracle Analytics Store. Here you can find different examples of the capabilities of Oracle Data Visualization. Some are create by Oracle PM and some by Oracle Partners. These examples can be downloaded and imported into your own environment. You should really check this out.

Also nice to see is the Oracle Data Visualization Interactive Demo.

This post is written as part of my Exploring Oracle Business Analytics series.

Thanks for reading.