OCI360 - Oracle Cloud Infrastructure 360º View

What is OCI360?

Oracle Cloud Infrastructure 360º View is a free open-source framework and tool to generate fancy html output of your tenancy that allows for quick analysis of an existing cloud estate to better optimize the use of cloud resources. You can also adapt it to generate your own queries and create some custom reports over your OCI tenancy.

The tool installs nothing and all it needs is a database schema to generate and read your tenancy model (more info below). It takes around 30 minutes to execute.

Output ZIP file can be large (several MBs), so you may want to execute OCI360 from a system directory with at least 1 GB of free space.

OCI360 uses moat369 API to generate html and graphs output. If you are familiar to edb360 and sqld360, you will notice they all have the same Look'n Feel.

For a sample full report from my tenancy, check http://oci360.dbarj.com.br/.

How does it work?

OCI360 will load and convert all the JSON information of your OCI tenancy into Oracle Database tables and views, creating a full metadata structured model. After the model is created on your database, it will query those tables and create reports about your OCI.

The overall execution can be divided in 3 steps:

Exporter Phase

First, the tool will connect to OCI through the delivered command line interface (OCI-CLI) and get tenancy metadata in JSON format.

Converter Phase

Later, the tool will collect the JSON files output by the extractor and load the data to an Oracle Database for analysis and reporting.

Reporter Phase

Finally, the tool will pull the data from the Oracle database to generate tables and charts that are then output in HTML format for consumption.

Execution Steps

For the execution steps, please check the Wiki Page.

Results

1. Unzip output OCI360_YYYYMMDD_HH24MI.zip into a directory on your PC.

2. Review main html file 00001_oci360_index.html.

Sample Sections

Below are some sections generated by OCI360:

Infrastructure View

Compute Instances Info

Subscribed regions Map

Space Summary

Backup Utilization Forecast

Shapes per Compute

Volume Treemap

For a sample full report from my tenancy, check http://oci360.dbarj.com.br/.

Latest change

• 20.06 (2020-06-25)
  • Infrastructure Visual Design now includes DB Systems.
  • New BigData section.
  • New Costs and Billing sections.
  • More misc info for debugging.

Check CHANGELOG.md for more info.