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 Cloud 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 […]

Using SSSD with Kerberos and Active Directory to Terminal into an OCI Linux Machine

Introduction OCI or Oracle Cloud Infrastructure, is Oracle’s latest cloud infrastructure that is replacing the older Oracle Cloud Infrastructure Classic. One feature it has is built-in Identity Management Governance. For example, you can add and manage users to grant who can access OCI resources among other features, please refer to this link for more information https://cloud.oracle.com/governance. […]

Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse

Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) on Windows to the Autonomous Data Warehouse (ADW). It is a companion to Connecting DIPC ODI Studio to the Autonomous Data Warehouse which uses ODI Studio in the Data Integration Platform Cloud (DIPC) and Connecting Oracle Data Integrator Cloud Service to the […]

Connecting an Oracle Analytics Cloud RPD to the Autonomous Data Warehouse Cloud

Deprecation Recent enhancements to OAC have made this post obsolete.  The latest OAC4 post is Here. The OAC5 post is Connecting Oracle Analytics Cloud Version 5 to the Autonomous Data Warehouse Introduction This post details the steps required to prepare an OAC instance for an RPD with an Autonomous Data Warehouse Cloud (ADWC) data source connection. It uses the […]

Adding Web Service Trusted Certificates to a Wallet in Oracle Database Cloud Service

Introduction This post documents how to add trusted TLS/SSL certificates to an Oracle Database as a Service (DBaaS) wallet. It uses an example of an Oracle Business Intelligence Cloud Service (BICS) REST API call to Delete Cached Data as documented in REST APIs for Oracle BI Cloud Service. This call is issued from PL/SQL and […]

Using Native SSH Tunnel Functionality within the Data Sync Tool to Secure Connections

For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), Oracle Analytics Cloud Service (OACS), and other relational databases. Last year I covered an approach that could […]

Using SSH for Data Sync Loads to BI Cloud Service (BICS)

For other A-Team articles about BICS and Data Sync, click here Introduction Since this article was written, the ability to create an SSH tunnel has been added as inbuilt functionality to the Data Sync tool.  For more details of how to use that, please see this article.  The method detailed in this article can be […]

EDI Processing with B2B in hybrid SOA Cloud Cluster integrating On-Premise Endpoints

Executive Overview SOA Cloud Service (SOACS) can be used to support the B2B commerce requirements of many large corporations. This article discusses a common use case of EDI processing with Oracle B2B within SOA Cloud Service in a hybrid cloud architecture. The documents are received and sent from on-premise endpoints using SFTP channels configured using […]

SOA Cloud Service – Quick and Simple Setup of an SSH Tunnel for On-Premises Database Connectivity

Executive Overview With the current release of SOA Cloud Service (SOACS) a common requirement often requested is to connect to an on-premise  database from the cloud SOACS instance. This article outlines a quick and simple method to establish the connectivity between the single-node SOACS instance and the on-premise database server using an SSH tunnel. Solution […]

JCS (Java Cloud Service) – An Alternative to the SSH Tunnel

The recommended way to use WLST with JCS is to use an SSH Tunnel. While this isn’t that difficult to setup and use, it is an extra step that some may feel as unnecessary.  It also changes the way you have been accustomed to using WLST against your on-premise WebLogic instances. This blog will attempt to provide a […]