Hackathon Posts - Creating Oracle Analytics Cloud (OAC) instance

Few posts planned for use in expected Hackathons. 

Oracle Analytics Cloud (OAC) is usually a very useful component of a Hackaton. It is great both as Analytic tool and as Data preprocessing and Understanding tool as well.

 

How to create an OAC instance?

Under Analytics & AI, select Analytics Cloud

 

There make sure you are in the correct compartment (on the left), preferably not the root compartment and press "Create Instance"

Give the instance a name (it will later be part of the URL)

For Hackaton it's usually better to have OCPU based 2 OCPU instance.

For most cases Professional Edition is sufficient (the Enterprise one includes all Professional capabilities).

In most case Public access is fine. Press Create.
 

It might take 10-20 minutes to create an OAC instance.
 

Once it is created you can upload file (Create - Dataset)

Or if you want to work with Autonomous Database (or anything else) create a new connection:

Select the Autonomous Database

Press Select.. button to upload the Autonomous Database wallet zip file (* see bellow how to obtain it).

Fill the Connection name, Username and Password (only).

If successfully saved, we can create new datasets based on DB tables, views, Manual SQL....

* How to obtain Autonomous Database wallet?

In the main OCI Menu go to Oracle Database and select the Autonomous Database:

In the specific database you work with, press "Database Connection"

 

Press "Download wallet"

In the next screen enter any password (we will not need it) twice and press "Download".

This will download the wallet zip file we will use (no need to extract for OAC).