Žiga Vaupot's Blog

In a recent project, a customer required integrating visualizations from Oracle Analytics into an Oracle APEX application running within Oracle Cloud Infrastructure. This article shares my experience with this integration, highlighting useful resources and addressing some challenges I encountered along the way. Integration is not my primary focus, so I started by reviewing Oracle's documentation. Unfortunately, there is no comprehensive "cookbook" available, which led me to explore various resources online. While many blog posts, articles, and videos exist, most are somewhat dated, though still relevant, as both products have evolved rapidly over the past few years. Despite this, I found some excellent resources that helped me significantly. For instance, Mike Durran's blog is an invaluable source for topics like this. I highly recommend his article A Guide to Embedding Oracle Analytics into Oracle APEX for a thorough understanding. Let's begin with Oracle An...

In many occasions analytics systems users expect that analyses or parts of analyses would be available for the public, exposed through public web pages. And in many instances, this is not so easy to achieve due to security and probably some other reasons.  With Oracle Analytics, we have an option to give public users secure access to analyses we maybe want to share publicly. Exposing content such as charts, graphs and other data visualisations in a web page, portal, Oracle APEX and similar systems has been available for a while.  With the latest versions of Oracle Analytics, token-based authentication in now also supported. In this first blog in this series, we will take a look, how to prepare a HTML file which will present embedded Oracle Analytics project. To start with, we need a web server. For the development it doesn’t have to be really sophisticated one, therefore, I am using a simple apache server installed on my laptop.  We will also need an analysis that was cre...