In this post we will look at Oracle Autonomous Database, specifically the data load from object storage feature of "database actions" including how to access this feature and how to use it! This data loading feature is really simple to use allowing you to efficiently create tables or update existing tables with data that you might have stored in the cloud, all without writing any code.
OCI
How to Use Your Own Encryption Key for Data Encryption in Oracle Cloud
In this post, I will focus on securing object storage data with your own encryption key, but note that this content is still very relevant for other OCI services such as block, object or file services or Oracle's platform solutions such as databases, analytics, etc. By default, OCI/Oracle automatically manages the keys that are used to encrypt and secure your data on the OCI platform.. this makes things a little simpler - you know your data is secure, so you don't need to worry about it. However, there may be requirements to use customer-managed encryption keys. We will explore how in the post.
Accessing an Object Storage Bucket in Oracle Cloud using Pre-Authenticated Requests
In my previous post, Creating an Object Storage Bucket in Oracle Cloud, I introduced Object Storage in Oracle Cloud and I outlined how you can very easily create an object storage bucket. In Oracle Cloud, object storage is used to store and manage data as objects, providing a reliable, secure and scalable service. OCI Object storage uses “buckets” as a method of organizing the objects (or files). Ultimately, you can think of a bucket as a container that stores –ideally related– objects within an Oracle Cloud compartment within a namespace. A bucket can only be associated to a single compartment and it’s possible to set policies against the compartment & bucket which define the actions/permissions that a user or group have to manipulate the bucket and the objects in the bucket. There are many use cases in which you might want or need to access an Oracle object storage bucket, in this post, I will explain how you can access objects within your bucket using a pre-authenticated request. Look out for a future post on accessing object storage buckets with granted user permissions.
Creating an Object Storage Bucket in Oracle Cloud
In Oracle Cloud, object storage is used to store and manage data as objects, providing a reliable, secure and scalable service. OCI Object storage uses "buckets" as a method of organizing the objects (or files). Ultimately, you can think of a bucket as a container that stores -ideally related- objects within an Oracle Cloud compartment within a namespace. A bucket can only be associated to a single compartment and it's possible to set policies against the compartment & bucket which define the actions/permissions that a user or group have to manipulate the bucket and the objects in the bucket. In this post, I will explain how you can very easily create a object storage bucket in Oracle Cloud.
Creating a KeyVault in Oracle Cloud
In this post, I will explain how you can very easily create a KeyVault in Oracle Cloud.
Creating a Compartment in Oracle Cloud
In Oracle Cloud, compartments are used to implement a degree of organization to your provisioned resources. They can also help you to more easily control access to your nicely organized resources. Assuming you are organizing things well, Compartments should be a collection provisioned resources that are related to one another and might typically be accessed/controlled by the same kind of user. In doing so permissions can be given to specific user groups to access and manage a compartment by an administrator. In this post, I will explain how you can very easily create a compartment in Oracle Cloud.
Oracle Integration: Connecting to Autonomous Database OOTB using Adapters
Oracle Integration Cloud comes with a library of adapters for both Oracle and 3rd Party applications. All of these capabilities mean that it’s possible to integrate applications faster and increase business agility. I've been writing a lot lately on the topic of Oracle Autonomous Database and also presenting about Oracle Integration Cloud, so I thought, why not merge the 2 subjects and document here how you might go about using the Oracle Integration out-of-the-box adapters to integrate to an Oracle Autonomous Transaction Processing (ATP) or Autonomous Data Warehouse (ADW) instance (both Oracle Autonomous Database - ADB - offerings). In this post I will describe how to use the Oracle Autonomous Database adapter in Oracle Integration Cloud to directly connect to an ATP or ADW instance.
Oracle Autonomous Database: Load Data from a Local File
In this post we will look at the data load from local file feature of "database actions" including how to access this feature and how to use it! This data loading feature is really simple to use allowing you to efficiently create tables or update existing tables with data that you might have stored locally or in the cloud, all without writing any code.
Connecting to an ATP Database in Oracle Cloud
In this post, I document the steps to help you to connect to (and use!) a newly created Oracle ATP Database Service
Creating an ATP Database in Oracle Cloud
In this post, I document the steps to help you create your own Oracle ATP Database Service.
AMY SIMPSON-GRANGE - BLOG 