Cloud

ATP vs ADW – the Autonomous Database lockdown profiles

By Franck Pachot . The Oracle database has always distinguished two types of workloads: transactional (OLTP) and datawarehouse (VLDB, DWH, DSS, BI, analytics). There is the same idea in the managed Oracle Cloud with two autonomous database services.

Google Cloud Spanner – inserting data

By Franck Pachot . In a previous post I've created a Google Cloud Spanner database and inserted a few rows from the GUI. This is definitely not a solution fo many rows and here is a(…)

Google Cloud Spanner – no decimal numeric data types

By Franck Pachot . Google Cloud Spanner is a distributed relational database focused on scalability without compromising consistency and integrity. It is available only as a managed service in Google Cloud. Basically, the idea is to keep the scalability advantages(…)

Deploy a Cloudera cluster with Terraform and Ansible in Azure – part 3

After the deployment step with Terraform and the configuration/installation with Ansible, we will continue the installation of our Cloudera cluster with Cloudera Manager. By following the below steps you will see how to install CDH on our hosts using Cloudera(…)

ADWC new OCI interface

By Franck Pachot . A few things have changed about the Autonomous Data Warehouse Cloud service recently. And I've found the communication not so clear, so here is a short post about what I had to do to start the(…)

Which Bitnami service to choose in the Oracle Cloud Infrastructure?

By Franck Pachot . In the Oracle Cloud PaaS you have a marketplace where you can choose your service. Some are packaged from Bitnami and available on multiple OS. My first idea is that in PaaS you do not care(…)

SQL Developer Web on the Oracle Cloud

By Franck Pachot . You like SQL Developer because it is easy to install (just unzip a jar) and has a lot of features? Me too. It can be even easier if it is provided as a web application: no(…)

ADWC – a Docker container to start/stop Oracle Cloud services

By Franck Pachot . In the previous post, I've explained how to start and stop the Autonomous Data Warehouse Cloud service from PSM (PaaS Service Manager). There's a setup phase, and a run phase starting with(…)

Deploy a Cloudera cluster with Terraform and Ansible in Azure – part 2

In this part of the blog posts series, we will show how ansible helps us to configure our cluster and install all pre-requisite needed for Cloudera Manager. Ansible is one of the most important automation tools currently. Ansible will help(…)

ADWC: Creation of Autonomous Data Warehouse Cloud service

By Franck Pachot . You want to try the Autonomous Data Warehouse Cloud Service? That’s easy. Here is a Step-by-Step. Cloud Credits First, you need Cloud Credits. You may have bought them (any recent negotiation with(…)