1. Automate loading a data mart for line-of-business analytics
  2. Prepare for Data Import

Prepare for Data Import

You prepare to Oracle Cloud Infrastructure Object Storage to handle file data and Oracle Autonomous JSON Database to receive the data.

You must provision two buckets in Oracle Cloud Infrastructure Object Storage to handle files:
  • Imported files bucket
  • Processed files bucket

To format the uploaded data and make it available for analysis, you must create a Oracle Autonomous JSON Database and provide access to it.

Prepare Object Storage for Integration

You must create a container, or bucket, to store data objects in Oracle Cloud Infrastructure Object Storage.

  1. Navigate to your Oracle Cloud Infrastructure Object Storage console.
  2. Click Storage and then click Object Storage.
  3. Click Create Bucket.
  4. Give your bucket a name that identifies the data.
  5. Click Standard as the storage tier.
  6. Click Object Events to enable automation based on state changes to objects using Oracle Cloud Infrastructure Events.
  7. If you want Oracle Cloud Infrastructure to manage your encryption keys, click Encrypt Using Oracle-Managed Keys for encryption. If you want leverage your own keys, click Encrypt Using Customer-Managed Keys.
  8. Click Create Bucket.

Enable Logging for Object Storage

Enable logging for the object storage bucket to facilitate event integration.

  1. Navigate to your Oracle Cloud Infrastructure Object Storage console.
  2. Locate the previously created storage bucket by clicking Storage and then clicking Object Storage
  3. Click the bucket name to show the details page.
  4. Under Resources, click Logs.
  5. Click the Enable Log toggle for each of the logs.

Provision an Oracle Autonomous JSON Database Instance

Provision an instance of Oracle Autonomous JSON Database in the Oracle Cloud Infrastructure service console.

  1. Sign in to the Oracle Cloud Infrastructure service console.
  2. Click the Autonomous JSON Database menu and select Create Autonomous Database.
  3. On the Create Autonomous Database page, select the appropriate Compartment.
  4. Enter a Display Name for the database.
  5. Enter a Database Name.
  6. Click JSON Database for workload type.
  7. Specify the CPU Core Count and Storage (in terabytes) that are appropriate for your workload based on the number of concurrent user and queries, the volume of data, and so on. For a small data sample (1 MB file) for example, specify a CPU Core Count of 2 and 1 TB of storage.
  8. If you want to automatically scale CPU Core Count and Storage values based on changes in your workload, click Auto Scaling.
  9. Specify a password for the Admin account.
  10. Specify the type of network access:
    • Allow secure access from anywhere: Access the database using a public endpoint that you secure with an access control list (ACL). Do not select this option if you want to only allow access using a private endpoint.
    • Virtual Cloud Network: This option creates a private endpoint for your database within a specified VCN.
      • Virtual Cloud Network: Select the VCN in which to launch the database. Click Change Compartment to select a VCN in a different compartment.
      • Subnet: Select the subnet to attach to the database. Click Change Compartment to select a subnet in a different compartment.
      • Hostname prefix: Optionally, specify a host name prefix for the database and associate a DNS name with the database instance.
      • Network security groups: Specify at least one network security group (NSG) for your database. An NSG functions as a virtual firewall, allowing you to apply a set of ingress and egress security rules to your database.
  11. Click a Bring Your Own License if you want to use an existing on-premises license or click License Included to provision a license with the database.
  12. Click Create Autonomous Database.

Connect using Oracle SQL Developer Web

Oracle SQL Developer Web is a cloud-based development environment that simplifies the development and management of Oracle Autonomous JSON Database.

Oracle SQL Developer Web is a browser-based interface of Oracle SQL Developer and provides a subset of the features of the desktop version, including the ability to run SQL statements and scripts in the worksheet.

Oracle SQL Developer Web connects to Oracle Autonomous JSON Database using the credentials in an Oracle Wallet.

  1. Navigate to the Service Console for Oracle Autonomous JSON Database.
  2. Click Development and then click SQL Developer Web.
  3. Enter the admin user name and password for the Oracle Autonomous JSON Database instance and click Sign In.