Importing into the Autonomous Data Warehouse using Oracle Data Pump

Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Classic Infrastructure (OCI). Versions OCI Compute    Oracle-Linux-7.6-2018.11.19-0 Instant Client     18.3.0.0.0 for Linux x86-64 (64-bit) ADW DB            18.0.3.3 SQL Developer 18.3.0.277 Assumptions An Oracle Cloud […]

Connecting Oracle Data Integrator Cloud Service to the Autonomous Data Warehouse

Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to the Autonomous Data Warehouse (ADW). It demonstrates both the Thin and Oracle Call Interface (oci) versions of the Oracle JDBC driver. It is a companion post to Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse which uses ODI […]

Add a Logout Function to the Default Log Out Menu Item in Oracle Integration Cloud Visual Builder

Introduction Each Visual Builder (VBCS) web application in Oracle OICS (Oracle Integration Cloud Service) comes with a default shell. The default shell displays a simple title, username (as a menu button) and a Log Out menu item. See picture below.   However, if you click the Log Out button, nothing happens. This is because no […]

Trigger OIC Integration Using OAuth

As businesses move to the cloud there is a high demand for securing/protecting their HTTP resources from unauthorized access. There are several approaches to protecting these resources which include SAML for SOAP service, OAuth for REST services, HTTP basic for both, and sometimes home grown proprietary mechanisms. It may not be widely known yet, but […]

Enabling Debug Logging for Managed Servers in Oracle Service Bus 12c

In 12c, changing the logging settings for Service Bus is done via the EM console. However, this only works for the Admin server. If you’re using a clustered domain and need to enable debug on one or more managed servers, you must update the log configuration by hand.  This is true for Service Bus whether […]

OIC Connectivity Agent Installation Pointers

The connectivity agent has been a feature of Oracle’s integration cloud strategy from the beginning to address the challenge of the cloud/on-premise integration pattern. However, the implementation of the agent differs between Oracle Integration Cloud Service (ICS) and Oracle Integration Cloud (OIC). With both offerings, the pattern for setup remains the same: 1. Create Agent […]

Completing the Migration from Business Intelligence Cloud Service to Oracle Analytics Cloud

Introduction This post is the second in a two-part series and details the tasks required to complete a migration from Business Intelligence Cloud Service (BICS) to Oracle Analytics Cloud (OAC) running on Oracle Cloud Infrastructure (OCI). For details on preparing for the migration to OAC see Preparing to Migrate from Business Intelligence Cloud Service to Oracle Analytics […]

Preparing to Migrate from Business Intelligence Cloud Service to Oracle Analytics Cloud

Introduction This post is the first in a two-part series and details the tasks required to prepare for a migration from Business Intelligence Cloud Service (BICS) to Oracle-Managed Oracle Analytics Cloud (OAC) running on Oracle Cloud Infrastructure (OCI). For details on completing the migration to OAC see Completing the Migration from Business Intelligence Cloud Service to […]

Getting Started Using Terraform with OCI

Introduction Standing up infrastructure requires building networks, servers and storage entailing complex build and configuration management processes. Traditionally done with scripts or even manually, Terraform gives you a new alternative. Using Terraform you can write a declarative description of your infrastructure. Using the Terraform “compiler” the declaration is converted to a build plan and then […]

Performance of MFT Cloud Service (MFTCS) with File Storage Service (FSS) using a Hybrid Solution Architecture in Oracle Cloud Infrastructure (OCI)

Executive Overview MFT Cloud Service clusters in Oracle Cloud Infrastructure Classic (OCI-C) are provisioned with database file storage system (DBFS) for shared storage as discussed in one of our earlier blogs[1]. In Oracle Cloud Infrastructure (OCI), customers also have the option of using File Storage Service (FSS) for shared storage. FSS can be used for […]

Less is more: improving by reducing REST calls.

One of the challenges when building an application that uses the Content and Experience Cloud Delivery API is improving the performance by reducing the number of API calls that the client application has to make.   The normal flow is to search for items, and then iterate over the number of items to get to […]

Best practices to model prospects, customers, suppliers, partners in an Oracle Fusion cloud implementation

Introduction Three major entities of every business/enterprise in most industries, are Customers, Suppliers and Products. In reality, customer, supplier and product data is required to be stored in all applications and each application might have different data model and data structure requirements. If customer data and product data are not consistently stored in all applications […]

ICS Connectivity Agent Concepts and Best Practices

ICS Connectivity Agent Concepts and Best Practices Introduction The on-premises connectivity agent enables you to create integrations between on-premises applications and Oracle Integration Cloud Service (ICS) Read all about agents in the documentation link below – Integration Cloud Service (ICS) Connectivity Agent In this blog, I wish to explain some problems that may be encountered […]

MFTCS: Production and DR in the Cloud

  Introduction Oracle Managed File Transfer (MFT) Cloud Service is a Platform as a Service (PaaS) computing platform solution for running a high performance, standards-based, end-to-end managed file gateway in the cloud. It features design, deployment, and monitoring of file transfers using a lightweight web-based design-time console that includes transfer prioritization, file encryption, scheduling, and embedded […]

Cloud Security: User Provisioning to Fusion Applications Cloud

Introduction The notion of a user is the most common reason for misunderstanding and confusion. When we mention a user, we often think of the person who is allowed to use an application. However, nearly every application has a different user structure implemented. The challenge is to find a common ground for these differing user […]

Address Validation Integration in CPQ

This is a short article that illustrates how integrations can be done in CPQ Cloud. To keep it simple I chose to demonstrate how to integrate with an address verification service. Register for Service In the past I created this integration with a provider that requires you to purchase a license. For this blog, I […]

Connecting Data Visualization Desktop Version 5 to the Autonomous Data Warehouse

Introduction This post details the steps required in Data Visualization Desktop (DVD) version 5 (12.2.5+) to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data connections. For DVD Version 4 ADW Connections refer to Creating a Connection in Data Visualization Desktop Version 4 to the Autonomous Data Warehouse Cloud For additional details on ADW, visit the […]

Mobile App Development with OAuth 2.0 and IDCS: A High Level Approach

Introduction IDCS is used by enterprises and organizations to allow secure access to their applications.  IDCS uses various open standards such as OAuth 2.0, SAML etc. to protect these applications.  One of the many features of IDCS is to facilitate client applications accessing backend (REST) APIs using OAuth 2.0 (https://tools.ietf.org/html/rfc6749).  Client applications come in different […]

Set up Fusion SaaS BI Cloud Connector (BICC) to use Cloud Storage

For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up a Cloud Storage Container, for use with the Fusion SaaS BI Cloud Connector. This may be of particular interest to Oracle Analytics Cloud customers, wanting to use the new Data Replication functionality from Fusion SaaS (for more details, […]