OCI Functions

OCI Functions integration with data flows is one of my favourite Oracle Analytics features as it provides to business analytists full control and flexibility over specific data processing needs. This article illustrates how the feature can be used to implement a web scraper, which allows us to extract data from a website and save the result in a new dataset. Please note that I already wrote about creating OCI functions and invoking them from data flows in Oracle Analytics, so I’m not going to cover all the details again. ...

In my previous article I wrote about creating OCI functions from scratch. Now it’s time to show you how to register your functions in Oracle Analytics and invoke them from data flows to transform your data. Ensuring OCI Functions are Compatible Once your OCI function has been created, you must add the oac-compatible free-form tag to it to ensure that it’s compatible with Oracle Analytics. Open the navigation menu in the OCI Console, select Developer Services, and click on the Applications option (Figure 1). ...

In Oracle Analytics Server (OAS) you can leverage custom Python/R scripts to give your users greater control and flexibility over specific data processing needs. Unfortunately, the custom script feature is not available in Oracle Analytics Cloud (OAC), but you should not worry too much about it as there is an alternative: OCI Functions! In this article I’m going to illustrate how to create an OCI function from scratch. It will be followed soon by another one where I show you how to register the function in Oracle Analytics and invoke it from a data flow to transform your data. ...