Autonomous Data Warehouse – Live Workshop Series

ADWH banner

Think self-driving is just for cars?  Think again.

Join us in this exclusive event and get hands-on with the self-driving Oracle Autonomous Data Warehouse cloud. See how Oracle is changing how businesses manage data and use analytics in the new era of automation. Discover the combined power of Oracle’s autonomous strategy as we show you how to unlock the value of data and reduce risk in your data management platform.

Start the day with a briefing on how autonomous data management helps to empower you to differentiate your business through smarter insights, faster analytics and discover new ways to capitalize on your most valuable asset — your data. Following the briefing is a chance to get roll up your sleeves and get hands on with Oracle Autonomous Data Warehouse Cloud.

The Hands-on Lab:
In this hands-on lab you will get first-hand experience with Oracle’s new Autonomous Data Warehouse Cloud.

  • You will provision a new ADWC database and see how you can connect your tools to your database.
  • You will work with Database Services and the sample data sets provided.
  • You will load a local file from your computer to your Autonomous Data Warehouse Cloud Database, see how you can connect a data visualisation tool and build dashboards with the too.
  • You will scale your database and experience the elasticity of Autonomous Data Warehouse Cloud.

Hands-on Lab Pre-requisites:
A laptop able to connect via wireless with a minimum of 8GB of memory and 3GB of Storage (Windows laptops preferred with administration rights required to install Oracle SQL Developer and Oracle Data Visualisation Desktop).

  • Oracle SQL Developer
  • Oracle Data Visualisation Desktop
  • (above software will be provided if needed)

Seating is limited.  Register to reserve your seat now!

Register for City Below:   9am to 12pm

SYDNEY – ORACLE OFFICE – Tuesday 21st August

MELBOURNE – ORACLE OFFICE – Wednesday 22nd August

BRISBANE – ORACLE OFFICE – Thursday 23rd August

CANBERRA – ORACLE OFFICE – Friday 24th August

PERTH – ORACLE OFFICE – Tuesday 28th August

ADELAIDE – ORACLE OFFICE – Wednesday 29th August

WELLINGTON – CLIFTONS – Thursday 30th August

AUCKLAND – ORACLE OFFICE – Friday 31st August


Teaching How to Provision Oracle Autonomous API Platform and API Gateway

Oracle is adding a secret recipe to all their Cloud Services with a nice touch of Machine Learning. This makes it possible to have the new series of “Autonomous” Cloud Services that are self-driving, self-healing and self-securing. Stay tuned, because we are going to keep listening a lot about them.

In this blog I am going to show you how to provision an Autonomous API Platform environment and then provision and register an API Gateway, running on a separate Oracle Linux VM on IaaS.

This is a graphical view of what I will be doing in this blog:

Continue reading “Teaching How to Provision Oracle Autonomous API Platform and API Gateway”

Live workshop – Need to understand how Containers, Kubernetes and the Modern App Dev Platforms fit together?

The importance of application development is going beyond IT, helping organisations build out their core value, and innovating their business models to stay competitive. With modern application development platforms, organisations can rapidly build solutions that help to innovate how they operate and serve their customers.

Modern application development platforms enablement organisations to develop and deploy applications in the cloud that support business agility which has the added advantage of significant cost savings.

In this workshop, you’ll see applications being built using a variety of modern application development technologies and principles.

In this session we will cover:

  • Data samples to available datasets with RESTAPIs
  • User experience via development tools (web,HTML5, mobile, bots)
  • Blockchain enabling critical elements
  • Integrating applications, supporting modern application development
  • Blending real-time external data with machine learning and autonomous datasets

Optional Hands-on Session

At the end of this workshop, we’ll be running a hands-on session and you will need to bring your Wi-Fi enabled laptop and mobile phone with you.

Register now to avoid disappointment as places are limited.

Continue reading “Live workshop – Need to understand how Containers, Kubernetes and the Modern App Dev Platforms fit together?”

Teaching How to Provision Oracle Integration Cloud (OIC) with Cloud Stack and Terraform

We have covered multiple blogs on how to use Terraform to help automate the provisioning of environments and treat your Infrastructure as Code. Until now, for PaaS stacks, we have used Terraform together with Oracle PaaS Service Manager (PSM) CLI. This gives us great flexibility to script our own tailored PaaS stacks the way we want them. However, with flexibility comes responsibility, and in this case, if we choose to use PSM CLI, it’s up to us to script the whole provisioning/decommission of components that make up the stack. As well as what to do if we encounter an error half-way through, so that we leave things consistently.

A simpler way to provision PaaS stacks is by making use of Oracle Cloud Stack, that treats all components of the stack as a single unit, where all sub-components are provisioned/decommissioned transparently for us. For example, Oracle Integration Cloud (OIC) stack, is made of Oracle DB Cloud Service (DBCS), Integration Cloud Service (ICS), Process Cloud Service (PCS), Visual Builder Cloud Service (VBCS), IaaS, storage, network, etc. If we use Oracle Cloud Stack to provision an environment, we only have to pass a YAML template with the configuration of the whole stack and then, Cloud Stack handles the rest. Pretty awesome huh?

Similarly, as we have done in the past, we are going to use a “Build Server”. This will be used as a platform to help us provision our PaaS stacks. When provisioning this “Build Server”, I will add all the tooling it requires as part of its bootstrap process. For this, I am using Vagrant + Terraform, so that I can also treat my “Build Server” as “infrastructure as code” and I can easily get rid of it, after I built my target PaaS stack.

This is a graphical view of what I will be doing in this blog to provision an OIC stack via Cloud Stack:

Continue reading “Teaching How to Provision Oracle Integration Cloud (OIC) with Cloud Stack and Terraform”

Simple Polling: a basic Polling Web App built using Oracle Visual Builder CS Visual Applications

Polls. Surveys. Live Voting. It’s all about gathering live responses in any venue: conferences, concerts, classrooms etc.. There’s a proliferation of tools (including online tools) to create and conduct polls: “Download the mobile app today and be ready for your next interactive class or event tomorrow“.

For those who don’t know the difference between a poll and a survey a poll is used to ask one simple question while a survey is generally used to ask a wide range of multiple questions. …  How tedious are those questions?

If the point is obtain information do we want to bother our attendees with 10 questions (that they are not likely to answer) or do we want to ask 1 small, simple and quick question?  Well, being an attendee myself I think polls are way more powerful and effective than surveys so I thought a simple responsive Polling Web App was a good excuse to put my hands on Visual Builder and get familiar with the Visual Applications. This post assumes you’re familiar with Visual Builder Cloud Service – if you’re not reading Carlos’ latest post Teaching How to Get Started with Oracle Visual Builder 2.0 is certainly a good idea. Continue reading “Simple Polling: a basic Polling Web App built using Oracle Visual Builder CS Visual Applications”

Teaching How to Get Started with Oracle Visual Builder 2.0

In this blog, I am going to show you how quickly you can use data in an existing Excel spreadsheet with multiple tabs and use it to auto-generate API-based microservices using Oracle Visual Builder. Then, we are going to consume our own generated APIs via a rich set of HTML5 components.

For demonstration purposes, I am going to upload an Excel spreadsheet that contains 3 tabs (Order, Buyers and Products). This is a simple way to play with master/detail records. Feel free to use the same spreadsheet as an initial demo vehicle to auto-generate REST APIs and build Web Applications.

Continue reading “Teaching How to Get Started with Oracle Visual Builder 2.0”

Teaching How to Get Started with Oracle Autonomous Data Warehouse Cloud Service

Data Warehouses have been around for a long time and they bring multiple benefits, but these also come at a cost. Some of the associated challenges that are easily identified when talking about traditional Data Warehouses include:

  • Complexity and Expensive
  • Inability to manage data and user growth
  • Hard to deploy and maintain

Oracle Autonomous Data Warehouse aims at easing these challenges with the ability to:

  • Provision a data warehouse in as little as 15 seconds.
  • Full automation of management of the Data Warehouse
  • Instant scaling with zero-downtime
  • Automated Tuning
  • Migration tools, e.g. Redshift

In this blog, let’s show can easily we can provision a new Oracle Autonomous Data Warehouse, load data into it and run some data visualization on top.

Continue reading “Teaching How to Get Started with Oracle Autonomous Data Warehouse Cloud Service”