Connecting Oracle Analytics Cloud to Autonomous AI Database Using Resource Principal Authentication
Creating a basic connection from Oracle Analytics Cloud (OAC) to Autonomous AI Database is straightforward: upload the database wallet and provide a database username and password. While this works well for a small number of connections, it can become difficult to manage at scale. You may need separate connections for different databases and schemas, and you may have to replicate them across multiple environments such as development, test, and production. Passwords can expire, wallets may need to be updated, and database credentials must be securely managed and shared with the appropriate users. What starts as a simple configuration task can quickly turn into an operational burden, increasing maintenance overhead and introducing unnecessary security risks. ...
The Conversational Experience in Oracle Analytics
Asking questions in natural language and receiving coherent, contextual answers is no longer seen as futuristic; it is becoming habitual and increasingly embedded across applications, from search and analytics to customer support and productivity tools. This shift is fundamentally reshaping how people engage with data and technology, setting the stage for more intuitive, accessible, and pervasive conversational experiences. In the past, I wrote about the Oracle Analytics AI Assistant with a fair amount of skepticism. In this article, I take a closer look at how it has evolved since then and how these advancements have reshaped my initial judgment. ...
Upgrading to Oracle Analytics Server 2025 (8.2.0.0.0)
Oracle recently announced the general availability of Oracle Analytics Server (OAS) 2025, with over 100 new capabilities to help every analytics user streamline analysis, gain faster insights, and make informed decisions. In this article, I will show you how to upgrade your OAS system to the 2025 (8.2.0.0.0) update. The instructions in this article apply specifically to my OAS 2024 system running on Oracle Linux 8. If you are upgrading from a different release or operating system, please refer to Upgrading to Oracle Analytics Server. ...
The Visibility Parameter Property in Oracle Analytics
The November 2024 Update for Oracle Analytics Cloud introduced the Visibility Parameter property, allowing users to conditionally display workbook visualizations. In this article, I’ll take a deep dive into this feature. Show or Hide Visualizations Based on Parameter Values Showing or hiding visualizations based on parameter values is straightforward and more intuitive than using conditions in Classic Analytics. To do this, select the visualization you want to conditionally display and open the Properties pane. Then, set the Visibility Parameter property by either selecting an existing parameter or choosing the Create Parameter option to create a new one with two values: Show and Hide (Figure 1). ...
Hiding Columns in Oracle Analytics Workbook Visualizations
The January 2025 Update for Oracle Analytics Cloud is out, and in this article, I’ll take a deep dive into an underrated yet highly useful feature: the ability to hide columns in workbook visualizations. Hide Columns in Visualizations Hide columns in visualizations is straightforward. After selecting a visualization by clicking on it, simply right-click on the column you want to hide in the Grammar Panel and choose the Hide option (Figure 1). ...