Introduction This post describes deploying Oracle Remote Data Connector (RDC) for Tomcat in a Compute instance running on Oracle Cloud Infrastructure (OCI) for...
Introduction This post describes deploying Oracle Remote Data Connector (RDC) for Tomcat in a Compute instance running on Oracle Cloud Infrastructure (OCI) for use by Oracle Analytics Cloud (OAC). RDC is used primarily in cases where data sources are not accessible using a public IP address. It supplements the official RDC documentation found here and here with screen images and links to additional references. A step-by-step example is provided for those desiring to perform...
Introduction This post describes deploying Oracle Remote Data Connector (RDC) for Tomcat in a Compute instance running on Oracle Cloud Infrastructure (OCI) for use by Oracle Analytics Cloud (OAC). RDC...
For other A-Team articles by Richard, click here Introduction The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise...
For other A-Team articles by Richard, click here Introduction The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise data sources. There are now 2 versions. The initial version required that a web-sever, either weblogic or tomcat, be used on premise for the tool to work. That version is still available, and for customers already using Weblogic or Tomcat on-premise, that may still be the preferred approach. Details on configuring...
For other A-Team articles by Richard, click here Introduction The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise data sources. There are now 2 versions....
For other A-Team articles by Richard, click here Introduction The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise data sources. In the 5.2 release of Oracle Analytics Cloud, new functionality was added that allowed Data Visualization (DV) to connect directly to on-premise databases, via the Remote Data Connector (RDC) tool, without the need to use the repository (RPD). This article will cover the simple steps to create the...
For other A-Team articles by Richard, click here Introduction The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise data sources. In the 5.2 release of...
For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up the Remote Data Connector (RDC), for Oracle...
For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up the Remote Data Connector (RDC), for Oracle Analytics Cloud, to connect to an On-Premise Essbase source. Two methods will be described: A direct connection from the Data Visualization tool without the need to use a repository (RPD) A connection from the Analyses tool, that does use a RPD connection Notes The Essbase.war file requires Java 1.8. This impacts the...
For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up the Remote Data Connector (RDC), for Oracle Analytics Cloud, to connect to an On-Premise...
For other A-Team articles by Richard, click here Introduction Customers may want to restrict access to their Oracle Cloud Services to a set of IP ranges, for...
For other A-Team articles by Richard, click here Introduction Customers may want to restrict access to their Oracle Cloud Services to a set of IP ranges, for instance to only allow connections coming from their corporate office. That type of restriction is not possible within Oracle Analytics Cloud itself, but it possible to set up using the Identity Cloud Service. This functionality requires the 'Foundation' level for Identity Cloud Service. For more information on the...
For other A-Team articles by Richard, click here Introduction Customers may want to restrict access to their Oracle Cloud Services to a set of IP ranges, for instance to only allow connections coming...
Background Dashboard Landing Navigation Pages (also known as start page, landing page, default page, default dashboard, home page) can be used to enhance the...
Background Dashboard Landing Navigation Pages (also known as start page, landing page, default page, default dashboard, home page) can be used to enhance the user experience. As the number of analytics artifacts grows, the catalog might become cluttered and menu drop-down lists can be laborious to scroll through. Dashboard Landing Navigation Pages are a simple way to structure related content and efficiently direct data consumers to the information they are seeking. They...
Background Dashboard Landing Navigation Pages (also known as start page, landing page, default page, default dashboard, home page) can be used to enhance the user experience. As the number of...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added. This allows Oracle Analytics Cloud (OAC and OAAC), to replicate data, on a schedule, from a number of Oracle's SaaS offerings. For many use cases, this will mean that a separate extract and load processes, is no longer required. In this initial release, the sources that can be replicated are: - Oracle Fusion...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added. This allows Oracle Analytics...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to extract data for most use cases, is through the BI Cloud Connector tool. This pulls data from 'View Objects' in the Business Intelligence layer of Fusion SaaS. Other tools, the Analytics Cloud Data Replicator, and Analytics Cloud Data Sync tool, can also extract from these...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to...
For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data...
For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent 2.5 release, Data Sync added the ability to pull data directly from Fusion SaaS view objects. The same view objects that...
For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle...
