Tag: AUTONOMOUS DATABASE

Offloading Oracle Data to Object Storage and Loading as External Table in an Autonomous Database | Part 3: Oracle OCI Object Storage


Following up the posts here and here, we are explaining today how to make same thing using Oracle OCI Object Storage. The procedure and steps are quite similar so, let’s go and try! Steps Create a bucket Upload file to bucket Create an Auth Token for your user as follows: In a sql editor, execute … Continue reading Offloading Oracle Data to Object Storage and Loading as External Table in an Autonomous Database | Part 3: Oracle OCI Object Storage →

Connecting Visual Builder to an Autonomous Database


Oracle Visual Builder is a visual development tool that comes with its own database. It allows you to create objects for storing data. Those objects are also exposed as REST, making the data model of your application accesible from/to other peers. Visual builder allows the configuration change consisting in connecting to an "external" database, either … Continue reading Connecting Visual Builder to an Autonomous Database →

Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part Two: AWS S3


Following up the previous post, we are explaining today how to make same thing using Amazon S3. The procedure and steps are quite similar, let's go and try! Amazon side setup Create a S3 bucket with no public access: Upload datafile: Grab the object URL for later: Bucket located in Frankfurt Create a user in … Continue reading Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part Two: AWS S3 →

Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part One: Azure Object Storage


Oracle autonomous database (ADW/ATP) offers several approaches for storing the data: data online stored in the database internal storagedata nearline as external tables in object storagedata offline in object storage The autonomous database supports object storage provided by Oracle OCI, Amazon S3 and Azure, with them you can create external tables, external partitioned tables and … Continue reading Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part One: Azure Object Storage →

Creating a Connection between Oracle Integration (OIC) and Autonomous Database


Connect to ATP and create a new user Grab the ATP connection details and download the wallet(give it a password): TNS Name in connection details is the value to provide in the OIC connection wizzard Create the connection in OIC providing the values previously gathered Service Name is the value of TNS Name in the … Continue reading Creating a Connection between Oracle Integration (OIC) and Autonomous Database →

Microservices Versioning and the “Database per Service Pattern” with Oracle Autonomous Database


The database per service pattern with an Oracle database can be accomplished easily with one instance of Autonomous Database per microservice, a very easy to use and maintain database (relational and JSON). But not only is easy to use and maintain because you don't have to deal with administration tasks or manage different technologies for persisting … Continue reading Microservices Versioning and the “Database per Service Pattern” with Oracle Autonomous Database →