X

Best Practices from Oracle Development's A‑Team

Analytics Reporting

Analytics Reporting

Connecting to Dedicated Autonomous Databases using Connection Manager and Oracle Analytics

Validated July 27, 2021 with OAC 6.1 function myCopyFunction(pvar) { var copyText = document.getElementById(pvar);...

Validated July 27, 2021 with OAC 6.1 function myCopyFunction(pvar) { var copyText = document.getElementById(pvar); copyText.select(); copyText.setSelectionRange(0, 99999) document.execCommand("copy"); alert("Copied"); } #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th { background-color: Azure; border: 1px solid #ddd; padding: 6px; height: 20px; font-size: small; } #customers th { background-color: brown;...

Analytics Reporting

Configuring Oracle Analytics Cloud (OAC) with Data Gateway to connect to Teradata

 Background This article outlines the steps to configure Oracle Analytics Cloud (OAC) with Data Gateway to connect to Teradata. At the time of writing, the...

 Background This article outlines the steps to configure Oracle Analytics Cloud (OAC) with Data Gateway to connect to Teradata. At the time of writing, the supported data source for Teradata as outline here is Remote Data Connectivity. Remote Data Connectivity includes both Data Gateway and Remote Data Connector. This blog will only cover Data Gateway, as it is the preferred method to connect until Private access channel becomes available for Teradata. The steps in the blog...

Analytics Reporting

Connecting to Private Autonomous Databases using Connection Manager

Validated May 25, 2021 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th {...

Validated May 25, 2021 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th { background-color: Azure; border: 1px solid #ddd; padding: 6px; height: 20px; font-size: small; } #customers th { background-color: brown; color: white; } Introduction Oracle services may require a proxy to reach data sources for various reasons including security, routing and privacy. One reason may be that the service is unable to...

Analytics Reporting

Using a Web Application Firewall with Private Oracle Analytics

Validated April 7, 2021 for OAC 5.9 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th {...

Validated April 7, 2021 for OAC 5.9 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th { background-color: Azure; border: 1px solid #ddd; padding: 6px; height: 20px; font-size: small; } #customers th { background-color: brown; color: white; } Introduction Oracle Analytics now can use a custom or vanity URL. This feature enables the use a web application firewall and load balancers with HTTPs listeners....

Analytics Reporting

Creating Oracle Analytics Connections to Private Autonomous Databases in Remote Regions

Validated April 7, 2021 for OAC 5.9 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th {...

Validated April 7, 2021 for OAC 5.9 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th { background-color: Azure; border: 1px solid #ddd; padding: 6px; height: 20px; font-size: small; } #customers th { background-color: brown; color: white; } Introduction Oracle Analytics Private Access Channel currently disallows an autonomous database domain name in a remote region. This post is a step-by-step workaround...

Analytics Reporting

Enabling Private Connections to Oracle EPM Cloud Planning

Validated March 23, 2021 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th {...

Validated March 23, 2021 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th { background-color: Azure; border: 1px solid #ddd; padding: 6px; height: 20px; font-size: small; } #customers th { background-color: brown; color: white; } Introduction Oracle Enterprise Performance Management Cloud Planning is now available on Oracle Cloud Infrastructure. This allows the use of dynamic routing gateways and service...

Analytics Reporting

Filtering Parameterized Data Sources in Oracle Analytics

Validated March 23, 2021 with OAC 5.9 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th {...

Validated March 23, 2021 with OAC 5.9 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th { background-color: Azure; border: 1px solid #ddd; padding: 6px; height: 20px; font-size: small; } #customers th { background-color: brown; color: white; } Introduction This post builds upon the elements described in Using Stored Procedures as a Source for Oracle Analytics. It is a step-by-step guide for filtering stored...

Analytics Reporting

Using Stored Procedures as a Source for Oracle Analytics

Validated March 18, 2021 with OAC 5.9 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th {...

Validated March 18, 2021 with OAC 5.9 #customers { border-collapse: collapse; width: 100%; align-items: top; font-size: small; } #customers td, #customers th { background-color: Azure; border: 1px solid #ddd; padding: 6px; height: 20px; font-size: small; } #customers th { background-color: brown; color: white; } Introduction h2.chocolate {text-align: left; color:#D2691E; } A stored procedure is usually defined as a reusable component of a database system containing business...

Analytics Reporting

Invoking Oracle REST Data Services (ORDS) in Oracle Analytic Cloud (OAC) Data Visualization (DV)

* This blog was last tested on OAC Version 5.9 + ADW 18c *   Background This article walks through the steps to invoke Oracle REST Data Services (ORDS) in...

* This blog was last tested on OAC Version 5.9 + ADW 18c *   Background This article walks through the steps to invoke Oracle REST Data Services (ORDS) in Oracle Analytics Cloud (OAC) Data Visualization (DV). Possible Use Cases: * Write-back * Running DML statements (insert, update or delete etc.) * Passing pre-process dynamic parameters to selects statements or stored procedures * Passing parameters to a web service Functionality Covered: * DV Data Actions * Apex ORDS...