Skip to content

Data warehouse setup

Luca Bösch edited this page Jun 17, 2023 · 31 revisions

Setup of the Data warehouse part using an Oracle Academy Cloud Program service

Given that you are in possession of a Oracle cloud account–in this example here, a Oracle Academy Cloud Program–access, log in to your account.

Oracle account login

Using the left hand side navigation "Databases" entry, go to "Autonomous Data Warehouse".

Navigation to "Autonomous Data Warehouse"

Click the "Create Autonomous Database" button (don't be confused if, even though you've chosen the 'Autonomous Data Warehouse' button, the title reads 'Autonomous Database.' The two terms seem to be often used interchangeably).

"Create Autonomous Database" button

In the following page, choose a "Display name" as well as a "Database name" and create credentials for the "ADMIN" user. Under "License", choose "License included", and add a "Contact email" address and leave all other settings untouched.

Create Autonomous Database page

Then, wait until the state changes from "PROVISIONING" to "AVAILABLE". You also will be notified by mail.

After this, click the "Database actions" button and authenticate with the created credentials for user "ADMIN".

Database actions page

Scroll down to the "Administration" section, then click the "DATABASE USERS" tile.

Database actions "Database users" tile

Documentation:

  1. Wiki Home

  2. Moodle plugin installation
    Installation instructions for the Moodle plugin

  3. Data warehouse setup
    Setup instructions for the data warehouse

  4. Queries for the Data Warehouse side Queries available to be run in the Data Warehouse part of the system

  5. Queries for the Moodle side
    Queries available to be run in the Moodle part of the system

  6. Documentation regarding the Moodle Database and Moodle functionalities Documentation about the inner mechanics of the Moodle LMS system

  7. Structure of tables in the Data Warehouse Documentation about the modeling of the tables inside the Data Warehouse

Clone this wiki locally