August 2018 – RedThunder.Blog

Building a Multi-Lingual Bot on the Oracle Chatbot Platform

First things first, if you are new to building Chatbot using the Oracle Cloud Platform, here are some quick videos to get you started on the platform and its capabilities. There is also an online MOOC (Massive Open Online Course) available on how to build your first BOT using the Oracle Platform and access the Bot through Facebook Channel.
Now that we understand how to build a bot let’s turn the Bot that can recognise the input from the end user conversing in his/her own language and respond accordingly.

The Bot platform allows you to bring your own translation keys (Google / Bing) and the Bot can be configured to detect the language. The bot further converts the user input to English, intent recognition by the NLP engine kicks off, based on the dialogue flow the bot structures the response in English which is again translated back into the language in which the question was asked by the user.

Let’s see that this in action :

Continue reading “Building a Multi-Lingual Bot on the Oracle Chatbot Platform”

PeopleSoft Integration using Oracle Integration Cloud – Part 1

Luckily, I’ve got a chance to look at PeopleSoft integration with other SaaS app using OIC (Oracle Integration Cloud) and decided to share what I learned.

Continue reading “PeopleSoft Integration using Oracle Integration Cloud – Part 1”

Autonomous Chatbot & Mobile in Action Workshop

AutonMobileChatbot

You’re invited to a unique workshop to experience Oracle’s world-class Autonomous Chatbot & Mobile Cloud Platform in action. Bring the team, as this applies to Business Managers, User Experience Managers, Developers and Architects alike.

This exciting session will include a business presentation, demonstration, and a hands-on workshop so you will leave knowing:

How autonomous software can free up time for your employees to focus on high value tasks, by executing autonomously mundane tasks across your business.
How your business can easily take advantage of AI to reduce inefficiencies and save time and money, whether it is about self-service for customers, employees or suppliers.
How this unique Oracle autonomous strategy is transforming app development quickly.

Optional Hands-On Session – Autonomous Mobile Cloud Platform
Following the presentation we will run a mini hands-on workshop where you will experience how Oracle is approaching this innovative and transformative technology to help build the next generation mobile channel. You’ll experience the power of Chatbot, one of the most revolutionary technologies that leverages AI and delivers a 40-50% improvement in communication productivity in just a few weeks.

Please bring your Wi-Fi enabled laptop and mobile phone with you to take advantage of this session.

Agenda:

09:00am Registration

09:30am Workshop starts

10:30am Morning tea

12:00pm Workshop concludes with lunch

12:30pm – 3:00pm Optional hands-on session

Presenter: Vijay Kumar Yenne or Michael Scheelhardt

Event Locations & Registration:

BRISBANE – ORACLE OFFICE – Tuesday, 23 October
SYDNEY – ORACLE OFFICE – Thursday, 25 October
MELBOURNE – ORACLE OFFICE – Tuesday, 30 October
ADELAIDE – ORACLE OFFICE – Thursday, 22 November
AUCKLAND – ORACLE OFFICE – Thursday, 29 November

For more workshops: Oracle ANZ Live S2V Workshop Series

Autonomous AppDev Workshops

As organisations focus on delivering innovation fast, they want a secure set of comprehensive, integrated cloud services to build new applications and run their most demanding enterprise workloads.

Built with advanced artificial intelligence (AI) and groundbreaking machine-learning (ML) algorithms, Oracle Cloud Platform autonomous services offer self-driving, self-securing, and self-repairing capabilities, enabling organisations to lower cost, reduce risk and accelerate innovation.

In this short workshop, you’ll see applications being built using a variety of modern App Dev technologies and principles, using the following agenda:

From Data to Available Datasets with REST APIs, 3 ways
User Experience via Development Tools (Web/HTML5, Mobile, Bots)
Blockchain Enabling Critical Elements
Integrating Applications, supporting Modern App Dev

Audience: IT Managers, Architects, Developers

Presenters: JT Thomas, Franco Ucci, David Reid, Carlos Rodriguez Iturria

Optional Hands-on Session:
At the end of this workshop, there will be a hands-on element specifically with the Autonomous Visual Builder Cloud Service, therefore will need to bring your Wi-Fi enabled laptop and mobile phone with you to participate.

Event Locations & Registration:

SYDNEY ORACLE OFFICE – Wednesday 5th September

BRISBANE ORACLE OFFICE – Tuesday 11th September

CANBERRA ORACLE OFFICE – Wednesday 12th September

MELBOURNE ORACLE OFFICE – Thursday 13th September

PERTH ORACLE OFFICE – Tuesday 18th September

ADELAIDE ORACLE OFFICE – Thursday 20th September

WELLINGTON CLIFTONS- Tuesday 25th September

AUCKLAND ORACLE OFFICE – Thursday 27th September

For more workshops: Oracle ANZ Live S2V Workshop Series

Building iOS Mobile App on Oracle Autonomous Visual Builder Cloud Service (VBCS)

The latest VBCS 2.0 release makes developing Mobile Applications faster using a declarative drag and drop approach while giving the flexibility to the developer to inspect the code and inject any additional code that the tool doesn’t provide out of the box. You can build your app from the browser itself without the need for any code editor.

Here is a quick tutorial on how to build a Mobile app using VBCS.
https://youtu.be/6n6p6D4ReLE

Once you develop your mobile app, you can create an Android or iOS build profile that will allow the tool generate the QR code so that you can test your mobile app on the device of your choice.

Continue reading “Building iOS Mobile App on Oracle Autonomous Visual Builder Cloud Service (VBCS)”

Teaching How to get Microservices to Consume Oracle Autonomous Transaction Processing Database (ATP)

A few days ago, we published an article that shows how to provision and connect to Oracle Autonomous Transaction Processing Database (ATP). Based on this, we got multiple requests to also demonstrate how to extend the connection to the Autonomous DB, not only from SQL Developer, but also from polyglot microservices.

In this blog, we are going to take a step forward and create a simple “Hello World” NodeJS application that exposes some REST APIs that push and pull data using an Oracle Autonomous DB. The idea is to give you all knowledge required, to be start building your own microservices, consuming data from Autonomous DB.

Continue reading “Teaching How to get Microservices to Consume Oracle Autonomous Transaction Processing Database (ATP)”

Building a Smart Contract with Oracle Blockchain Cloud Service @ #WinterHack2018

Last weekend, I was at the Code Network Winter Hackathon event in Brisbane – https://codenetwork.co/winter-hackathon-2018/. I was there as a sponsor, workshop presenter, mentor and just a general supporter. As such there was some down-time between different activities. So, what a great time to sit down and work on something that I have no idea about (technically) – #Blockchain and Hyperledger. So, as a normal person does – I went searching for relevant content to help. Here’s a couple of the searches that I did.

Unfortunately, through many different searches and reading lots of things it became apparent that I didn’t know much and there was lots to learn. There seemed to a massive amount information that looked great. There was content that talked about what a Blockchain is. There was content that talked about the business use cases and examples of why you use a Blockchain technology. There was code that built a Blockchain. I found plenty smart contract examples on github. I learnt more about what I needed to know but it didn’t get me to the place that I wanted to be.

So – how do I develop and play with a Smart Contract?

Continue reading “Building a Smart Contract with Oracle Blockchain Cloud Service @ #WinterHack2018”

Connect Dockerised Instant Client to Autonomous Data Warehouse

With all the recent exciting releases of Oracle Autonomous PaaS Services, I wanted to explore some of the client connectivity options to work against the Oracle Autonomous Data Warehouse (ADW).
In my cloud subscription I provisioned an instance of ADW which took less than two minutes from start to finish – terrific, now I am ready to leverage the functionality. If you want to know the steps to provision an ADW instance check out this blog post – https://redthunder.blog/2018/07/02/teaching-how-to-get-started-with-oracle-autonomous-data-warehouse-cloud-service/

Obviously an empty data warehouse isn’t particularly useful so one of the first things I wanted to do was to connect a SQL client to the ADW instance so that I can load some data. Initially I used Oracle SQLDeveloper to load data into my ADW instance. I had staged my Excel data files into an Oracle Cloud Object Storage container and then referenced them in my SQL code as External Tables. Carlos has already blogged the steps required for this in https://redthunder.blog/2018/07/02/teaching-how-to-get-started-with-oracle-autonomous-data-warehouse-cloud-service/ . If you follow the steps you will quickly get your ADW instance populated with your data. In fact for the demo scenario my ADW instance was now populated with some data (approx. 1 Million rows of Sales data and associated related dimensions (Product, Customers etc).

My next step (and the subject of this blog post) was to use the Oracle Instant Client in order to query the loaded data. Of course I could easily have viewed the data inside SQLDeveloper but I wanted to try some other approaches. Often in Proof of Concepts there is a need to quickly spin up a tool to create, retrieve, update and delete data. Anyone who has used the Oracle Database would be familiar with the SQL*Plus client which is included as part of the Oracle Instant Client. For those who are not familiar with Oracle Instant client, the Oracle website describes it as follows,

“Free, light-weight, and easily installed Oracle Database tools, libraries and SDKs for building and connecting applications to an Oracle Database instance. Oracle Instant Client enables applications to connect to a local or remote Oracle Database for development and production deployment. The Instant Client libraries provide the necessary network connectivity, as well as basic and high end data features, to make full use of Oracle Database. It underlies the Oracle APIs of popular languages and environments including Node.js, Python and PHP, as well as providing access for OCI, OCCI, JDBC, ODBC and Pro*C applications. Tools included in Instant Client, such as SQL*Plus and Oracle Data Pump, provide quick and convenient data access.”

I used a Vagrant-Box / VirtualBox to avoid having to install development tools such as the Oracle Instant Client directly on my laptop operating system. I found an existing vagrant box that provided me with an Oracle Linux base that also included Docker. This vagrant-box image allowed me to quickly spin up a base environment which in turn allowed me to focus on steps to run the Oracle Instant Client inside a Docker container inside the Virtual Box environment (sounds like a cheesecake recipe – lots of layers). The Dockerfile I used was based on the Oracle Instant Client forked from the official Oracle DockerImages project with some modifications for specifics around connecting to an Oracle Data Warehouse Instance. Continue reading “Connect Dockerised Instant Client to Autonomous Data Warehouse”

Teaching How to get started with Autonomous Database for OLTP

We all know that data is massively valuable to businesses, whether it is to support daily business transactional activities (Online Transaction Processing – OLTP), or to help business with planning, problem solving and decision making (Online Analytical Processing – OLAP). Either way, businesses heavily rely on both ways to support their most important strategies and activities.

Until recently, companies had to heavily invest in provisioning, securing, patching and driving either way of Online Data processing mechanisms. In most cases, even with Cloud adoption, companies still had to rely on their own skills to make sure that their databases were properly patched, secured, tuned and managed.

However, today there is another option with the recent announcements that Oracle have made around Autonomous Databases for both OLAP and OLTP data processing. What this means, is that Oracle has taken automation to a totally new level with the assistance of Machine Learning. The idea is that the DB itself is self-sufficient with a full set of automated activities that range from patching, securing, optimising, etc. This will reduce not only the effort to run data workloads, but removing completely human errors, creating the opportunity to not only keep the lights on, but to focus on crucial business activities around innovation and differentiation.

Continue reading “Teaching How to get started with Autonomous Database for OLTP”

Active Directory Delegated Authentication in Oracle Identity Cloud Service

AD Delegated Authentication is a way to synchronise user passwords between an on-premises Microsoft Active Directory enterprise directory structure and Oracle Identity Cloud Service (IDCS). Users can use their AD passwords to sign in to IDCS to access resources and applications protected by Oracle IDCS. We will use Office365 as one of the target applications. Oracle IDCS can provision user into Office365 and keep users synchronised.

The following diagram 1 depicts the scenario:

diagram1