Machine Learning with Oracle Database Advanced Analytics

TL;DR: Oracle DB + Oracle Data Mining + Oracle R Enterprise = Database Advanced Analytics (OAA) The Database Advanced Analytics option allows running Machine Learning algorithms within the database itself. The on-prem flavor of OAA is available as part of database Enterprise Edition 12c and upward releases. In OPC, OAA is available as part of […]

ICS to OIC Migration

Introduction Oracle Integration Cloud (OIC) and Integration Cloud Service (ICS) are iPaaS offerings from Oracle. ICS was released back in 2015 has now been superseded by OIC. Customers on ICS can choose to be on ICS or migrate to OIC to take advantage of new features and services built into OIC. The comparison of ICS […]

Connecting Oracle Autonomous Analytics to Exadata Express

Introduction This post details the steps required to upload an Exadata Express wallet and create data and console connections in Oracle Autonomous Analytics (OAAC) or Oracle Analytics Cloud (OAC). The wallet is used for Data Visualization (DV) data sets, Metadata (RPD) connection pools, and Thin Client Modeler (TCM) models. Data connections are used for DV data […]

A production pattern for frequent updates with PGX

Oracle’s PGX (Property Graph analytiX) is an in-memory representation of Oracle Property Graph data. Analytics against the data are parallelized and as such can be extremely fast (especially compared to typical database queries). Such powerful analytics are ideal for recommendations or real-time accept/reject financial transactions for example. A list of the built-in analytics can be […]

Some Tips for Working with Visual Builder UI Components in Oracle Integration Cloud

Introduction Oracle Integration Cloud Service (OIC) has now bundled several formally independent PAAS services into a single cloud service. One of these bundled services is Visual Builder (formerly VBCS). The 18.2.5 release of Visual Builder in OIC is more user friendly than prior releases. For example, in 18.2.5, users are not forced to write Javascript code […]

Connecting Oracle Autonomous Analytics to the Autonomous Data Warehouse

Introduction This post details the steps required to upload an Autonomous Data Warehouse (ADW) wallet and create data and console connections in Oracle Autonomous Analytics (OAAC) or Oracle Analytics Cloud (OAC). The wallet is used for Data Visualization (DV) data sets, Metadata (RPD) connection pools, and Thin Client Modeler (TCM) models. Data connections are used for […]

Downloading Autonomous Data Warehouse Credentials

Introduction This post details the steps required to download an Autonomous Data Warehouse (ADW) Client Credentials Zip File. This file is required by all clients connecting to ADW. For additional details on ADW, visit the Autonomous Data Warehouse page. Updates Latest Validation: June 21, 2018 Published on: June 21, 2018 Versions Used Autonomous Data Warehouse 18.1.5 Windows 7 […]

Extracting Data from Fusion SaaS via View Objects with Data Sync

For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent 2.5 […]

Creating a React Based Conversational Chatbot Client

Built using Oracle Intelligent Bots version 18.2.3 Introduction Oracle Intelligent Bots is an integrated feature of Oracle Autonomous Mobile Cloud Enterprise (AMCe) which allows you to develop Intelligent Chatbots. A Chatbot or Bot is a computer program designed to simulate a conversation with human users, especially over the Internet. End users can easily connect to […]

Integration Cloud – File Handling Primer

Introduction The objective of this blog is to introduce to the reader all available file-based options in Oracle Integration Cloud (OIC). The blog will cover the various tools and techniques available for developers for designing file-based integration solutions The Integration Cloud documentation does contain these in relevant sections. This blog intends to present only the […]

Using Data Sync to Extract and Load Data from Fusion SaaS using the BI Cloud Connector (BICC) and UCM

For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent release, […]

Monitoring SaaS Application Performance in EM using RUEI

Introduction Performance and efficiency are essential to having a positive user experience and the diagnosis of click and flow activities can be a complex task in a SaaS environment where access to various log files is limited. Oracle Real User Experience Insight (RUEI) – monitors real user activity, records user session data and provide web […]

Under the hood: Oracle Identity Cloud Service Audits

Introduction Audit events enable organization administrators to review the actions performed by members of your organization using details provided by the Audit logs – who performed the action, performed it, and what the action was.  Before getting into the article I want to mention this blog was written by Abhishek Juneja, a Principal Product Manager of Identity & […]

Render CEC Content Item with Images in Oracle Intelligent Bots

In one of the blog published by Dolf regarding Using CEC with Oracle Intelligent Bots, he demonstrated on how to use Oracle Intelligent Bots to retrieve the content items in CEC (Content and Experience Cloud Service) using the REST API. In this blog, I will extend this use case and provide a simple example of how to […]

API Platform Service Callouts using a Groovy Policy

Purpose The purpose of this post is to demonstrate through a practical example how a Developer might enrich an API payload using a Service Callout from within a Groovy Policy.   Background Since the release of Oracle API Platform v17.2.5, there has been a standard Policy entitled Service Callout 2.0 (version 1.0 having been deprecated […]

GoldenGate Cloud Service (GGCS): How to run SSH Socks Proxy Server for Oracle GoldenGate (OGG)

Introduction In this article we shall discuss how to configure and run Secure Shell (SSH) Socks Proxy server needed for Oracle GoldenGate (OGG) replication between On-Premises and GoldenGate Cloud Service (GGCS) in the Oracle Public Cloud (OPC). The SSH Socks Proxy server is required in GoldenGate replication between On-Premises and OPC, only if there’s no […]

Restrict access to IDCS UI using Sign-On Policies

Introduction The purpose of this blog post is to describe how to use Sign-On Policies to restrict access to the OOTB Oracle Identity Cloud Service UI. One use-case could be that End-Users should not be able to view and update their own profile details using the OOTB UI. All content listed on this page is […]

Connecting DIPC ODI Studio to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create connections in the Data Integration Platform Cloud (DIPC) to the Autonomous Data Warehouse Cloud (ADWC). It demonstrates both the Thin and OCI versions of the Oracle JDBC driver. It is a companion post to Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse Cloud which uses ODI Studio on Windows. […]

Resources for learning RDF Semantic Graph (Part 1)

Continuing my series on graph databases (see: Intro to Graphs at Oracle) I thought it would be useful to provide a “cheat sheet” for bootstrapping your learning of RDF Semantic Graph technologies. I’m starting with RDF since it has been around longer, is a W3C standard, has more in-depth training available, and the lessons learned […]

Oracle Data Integration Platform Cloud (DIPC): Configure VPN as a Service (VPNaaS) for On-Premises Connectivity

Introduction This document will walk you through how to configure Virtual Private Network as a Service (VPNaaS) with Oracle Data Integration Platform Cloud (DIPC) for connectivity between On-Premises Oracle database and Oracle Public Cloud (OPC). One major requirement for DIPC to be configured with VPNaaS is; DIPC must be provisioned to use IP Network instead of […]