- Learn how to use Oracle Analytics Cloud on MySQL Database Service powered by HeatWawe.
Oracle Analytics Cloud gives you a complete, connected, collaborative platform that brings the power of data and analytics to every process, interaction, and decision in every environment – cloud, on-premises, desktop and data center. You can read more here!
- To be able to successfully test bonus lab please complete all the previous labs in this workshop.
- Make sure you completed the Step 7.4 in Lab 7.
To address your question you can send it on Discord mysql-heatwave channel.
Click the hamburger menu in the upper left corner and click on Analytics -> Analytics Cloud.
Click Create instance and in the new window, fill out the fields as shown in the image below. Make sure to select 2 OCPUs, the Enterprise version and the License Included button. Finally click Create to start the provisioning of the instance. Note: It takes about 15-20 minutes to create the OAC instance so go get a coffee in the meantime!
When the status of the instance changes to Active, click on the button Configure Private Access Channel to create a private access to the MySQL Database Service Instance.
In the next window you first need to choose a name for the channel. Then, fill in the VCN name with the same one where you provisioned the MySQL Database Service and the Heatwawe cluster. Make sure you select the correct subnet! (In lab 1 you had the option to select Private Subnet or Public Subnet) make sure you select the correct one otherwise you won't be able to connect! Check Virtal Cloud Network's domain name as DNS zone, and remove the additional DNS Zone, and finally click Configure.
Note: It will take about 50 minutes to create the private channel so go get a nice cup of tea to kill the time!
When the status of the instance changes to Active, click on the button Analytics Home Page Channel to access Oracle Analytics Cloud!
We now want to connect to our MySQL Database Service, so from the top right corner click Create and then Connection as shown in the picture below. From the list of connectors, select MySQL
Browse the connection type or simply type in the search section MySQL, and Click it.
In the new window we have a lot of information we need to provide. The host name we need to provide is a little bit tricky, we need to provide the Internal FQDN (fully qualified domain name) of the MySQL Database Instance. To find this out, you need to go back to the MySQL instance details.
In the section Endpoint you'll find all the information required. See the following images if you need guidance.
As database name, you need to use tpch, the database we used in the previous labs, and fill in with the credentials metioned when creating the MySQL DB System
username: admin
password: Oracle.123
After you filled out everything, click on Save.
You Oracle Analytics Instance is now connected to your MySQL Database Service powered by Heatwawe.
Let's now use this connection to create a very simple dashboard! From the top right corner click Create and this time click on Dataset as shown in the picture below.
From the new window select the connection we just created.
Click on the tpch database as shown below.
Now, you'll see all the database's tables and views. Select the view we created for this lab called myAnalyticsView. Then on the button, Add All to add all the columns and then on the top right corner, Add
We are creating a Dataset based on all the columns of the view myAnalyticsView
Now you can see the data that has been retrieved. From the Reccomendations column on the right we could use the suggestions to clean the data. We'll leave this topic for another time but feel free to check Oracle's documentation on how to use this useful feature!
To move forward click on Create Project button on the top right corner. You will see the Visualisation screen where you can start building your dashboards!
From the left, select the column N_NAME and then, while pressing CTRL (or Comamnd if you are on Mac) click O_TOTALPRICE, right click and select _Create Best Visualization.
A nice histogram will appear after few seconds later and we'll see that every country contributes equally to the company's revenues.
You now have all the tools to discover insights in your data!
If you want to discover more on how to use Oracle Analytics Cloud check our Tutorials and Live Labs!