A-Team Chronicles

About The A-Team and A-Team Chronicles

The A-Team is a central, outbound, highly technical team comprised of Enterprise Architects, Solution Specialists and Software Engineers within the Oracle Product Development Organization. The team works closely with customers and partners, world wide, providing guidance on architecture, best practices, troubleshooting and how best to use Oracle Cloud Services and products to solve customer business needs. They specialize in using Cloud Solutions across IaaS, PaaS, SaaS as well as On-premise and hybrid deployments.

The A-Team provides this type of support by working with Oracle Consulting, Support and Sales – engaging in the toughest of situations, solving the hardest problems and the greatest of challenges.

The A-Team is lead from Oracle Headquarters in Redwood Shores, CA, but A-Team members are located and positioned globally, so that we are better prepared to respond quickly, and within an appropriate timezone for our Global customers.

“If you have a problem, if no one else can help, and if you can find them, maybe you can hire the A-Team”

 


Connecting Oracle Autonomous Analytics to the Autonomous Data Warehouse

Introduction
This post details the steps required to upload an ADW wallet and create data and console connections in Oracle Autonomous Analytics (OAAC) or Oracle Analytics Cloud (OAC) to the Autonomous Data Warehouse (ADW). 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 sets. Console connections are used for TCM models.

For additional details on ADW, visit the Autonomous Data Warehouse page. For additional details on OAAC and OAC, visit the Analytics Cloud page.

The instructions found in Creating Connections to Oracle Autonomous Data Warehouse Cloud are sufficient for experienced users. This post supplements the instructions with images of the screens used.
Update…

Read more

Oracle GoldenGate Microservices Architecture: Using Self-signed Certificates

Introduction
Oracle GoldenGate Microservices Architecture (OGG-MA) provides functionality for securing Rest API calls and communications channels between the Distribution and Receiver Servers over Transport Layer Security (TLS).

In order to activate this security protocol a SSL Certificate must be obtained from a Certificate Authority (CA) and installed on the server prior to creating the OGG-MA Services Manager and Deployment. SSL Certificates are small data files that digitally bind a cryptographic key to an organization’s details; such as domain name, server name or hostname, and the organizational identity and location.

However, test or sandbox environments typically do not receive CA generated SSL Certificates. In this article we’ll create a Self-signed SSL Certificate and use …

Read more

Restrict Root Compartment Access with Oracle Cloud Infrastructure Policies

The OCI Administrators group grants manage acess to all resources in all compartments including the root compartment.  So, any member of this group is considered a super user.  Is a normal practice to keep Administrators members to a small number of users and create additional groups/policies to restrict access to specific compartments.

If there’s a requirement to have policies at the root level that grant specific permissions to all compartments except the root compartment the following condition can be used:

 
…in tenancy where target.compartment.id=’ocid1.compartment*’
 

The OCID for all compartments except root starts with the string ‘ocid1.compartment.oc1’ while the OCID for the root compartment starts with ‘ocid1.tenancy.oc1’.  So, for example, the following po…

Read more

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 SP 1

Downloading the ADW Credentials
Login to the Oracle Cloud Infrastructure (OCI)
The URL is in the form: https://console.< Your Region >.oraclecloud.com. An example is below:
https://console.us-ashburn-1.oraclecloud.com/
Select your Tenant and Identity Provider e.g. oracleidentitycloudservice and click Continue.

Enter your credentials if prompted.

Navigate to the Service Console…

Read more

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. This article is focused on  customers who want to use their existing identity management services such as Active Directory. I previously wrote a four part series on SSSD starting with Part 1 of 4 – SSSD Linux Authentication: Introduction and Architecture, that includes a lot of detail from how SSSD works to the final setup, but I only covered LDAP and not Kerberos.  This article is going to sh…

Read more

Dayne Carley

Dayne Carley is a Principal Solutions Architect in the A-Team where he's mainly focused on Data Integration with an emphasis on Business Intelligence. Dayne attended the University of Hawaii and Seattle Pacific University where he earned a MBA degree in Information Systems and a Bachelor’s degree in Computer Science. He has over 20 years of experience assisting organizations design, build and implement Business Intelligence solutions. Since rejoining Oracle in 2016, Dayne has focused exclusively on Oracle’s Infrastructure, Platform, and Software Cloud Services, most notably Oracle Analytics, Data Integration Platform, and Autonomous Data Warehouse.

Ulrich Janke

Ulrich ('Uli') Janke is a Consulting Solutions Architect in the 'A-Team' where he's mainly focused on technology topics within the SaaS/PaaS services portfolio (ERP/SCM/HCM Cloud, Oracle Integrations Cloud, Java Cloud Services, Visual Builder Cloud Services etc), mostly dealing with extensibility and integration of SaaS offerings leveraging PaaS products. Uli started his career as programer, Database Administrator, and System Administrator, before he joined Oracle Consulting Germany 1997 as an Applications DBA. During his 15 years in various Oracle Consulting Organizations, he worked most of his time as a Technical Architect specialized for E-Business Suite implementations focusing on customization, extensions and integration. Uli joined the Oracle A-Team 2012 with a focus on Fusion Applications, working on installation, maintenance and cloning. In 2015, with the industry shifting towards cloud, Uli started the extending his skill set and experience to the new paradigm of IT.