Category: Oracle SQL Developer

Teaching How to get Microservices to Consume Oracle Autonomous Transaction Processing Database (ATP)

A few days ago, we published an article that shows how to provision and connect to Oracle Autonomous Transaction Processing Database (ATP). Based on this, we got multiple requests to also demonstrate how to extend the connection to the Autonomous DB, not only from SQL Developer, but also from polyglot microservices.

In this blog, we are going to take a step forward and create a simple “Hello World” NodeJS application that exposes some REST APIs that push and pull data using an Oracle Autonomous DB. The idea is to give you all knowledge required, to be start building your own microservices, consuming data from Autonomous DB.

Continue reading “Teaching How to get Microservices to Consume Oracle Autonomous Transaction Processing Database (ATP)”

Teaching How to Get Started with Oracle Autonomous Data Warehouse Cloud Service

Data Warehouses have been around for a long time and they bring multiple benefits, but these also come at a cost. Some of the associated challenges that are easily identified when talking about traditional Data Warehouses include:

  • Complexity and Expensive
  • Inability to manage data and user growth
  • Hard to deploy and maintain

Oracle Autonomous Data Warehouse aims at easing these challenges with the ability to:

  • Provision a data warehouse in as little as 15 seconds.
  • Full automation of management of the Data Warehouse
  • Instant scaling with zero-downtime
  • Automated Tuning
  • Migration tools, e.g. Redshift

In this blog, let’s show can easily we can provision a new Oracle Autonomous Data Warehouse, load data into it and run some data visualization on top.

Continue reading “Teaching How to Get Started with Oracle Autonomous Data Warehouse Cloud Service”

Configure Oracle SQLDeveloper SSH connection to Oracle Public Cloud Database

Oracle SQLDeveloper SSH Configuration

Challenge


After provisioning an Oracle SOA Cloud Service and its related Oracle Database 12c Pluggable Database Cloud Service Instance, I then needed to connect to the Database in the Oracle Public Cloud in order to run some scripts for my demo tables. Obviously mixing customer data into the SOA Meta Data-Store (MDS) Database is not best practice but it was fine for my demo purposes.

In order to run the SQL scripts I had I was presented with a couple of choices (at least).

Continue reading “Configure Oracle SQLDeveloper SSH connection to Oracle Public Cloud Database”