From Video to Value; Video Analytics Redefined with OCI Vision and Oracle APEX

Luc Bors

Two weeks ago I presented at APEX World in Ede the Netherlands.  The session was about how OCI Vision can be used to analyse videos and how to use these capabilities from within Oracle APEX.
By integrating OCI Vision with Oracle APEX you can do the analytics from within the application and immediately see the results. During the session I showed how to setup all the individual components and how to connect them into one unified solution. This post is just a quick summary of my presentation. Slides can be downloaded from APEX World Website or I will share them with you on request.

I started with an overview of OCI Vision and showed the differences between results when using OOTB Oracle models, or custom models. This was helpful for understanding models and training. From a video analyses perspective I used one of the Oracle Live labs, and I did a quick demo of the code that allows for soccermatch analyses.

The general architecture (image by Oracle) is rather straight forward. You can upload images, analyse them and use the result in an application.

So from an APEX perspective this is rather straightforward. In order to make things work, you need to create Web Credentials and a REST Datasource in APEX. The information needed for this can be retrieved from the OCI configuration file, which is available from OCI when you create an API key.

To integrate OCI Vision with APEX, we create Web Credentials in APEX. As said before, the info needed can be found in the config file.

The REST Data Source will be set up with the following parameters:

Rest Data Source Type: Oracle Cloud Infrastructure (OCI)
URL Endpoint: https://vision.aiservice.your-region.oci.oraclecloud.com/20220125/actions/analyzeImage
Authentication: We use the web credentials created above.

Using OCI Vision, you can upload images to detect and classify objects in them. The request to the OCI Vision service analyzeImage is an HTTP POST request

And thats it. Call the REST Source operation from a page process (or any other way you prefer) and work with the OCI Vision service.