OneCloud

OneCloud for Oracle EPM Cloud Quick Start

❗️

This article has expired. Please visit the OneCloud Knowledge Base for the latest documentation.

OneCloud has some very convenient features to help with the integration, automation, and management of your Oracle EPM Cloud environment. These features can be combined with other touchpoints that OneCloud has with various technologies including Salesforce, Tableau, Workday, NetSuite and relational databases.

This Oracle EPM-focused quick start guide will walk you through setting up OneCloud so that it is optimized to work with Oracle's cloud technology. Not all sections need to be completed, but some do build off of work from the completion of prior sections.

🚧

How do I get access to OneCloud?

We have made it easy for people interested in OneCloud to get access. Simply visit https://app.onecloud.io/new-user to spin up your own full-use trial of OneCloud.

If your company is already a OneCloud customer and you would prefer to use your primary OneCloud environment for this tutorial, then please contact your OneCloud system administrator to ensure you are added to a security group with Workspace administrator access. Please contact [email protected] if you require additional guidance.

Task

Summary

Time Estimate

Required

Configure your OneCloud Workspace

Create Workspace variables and create environments for LCM.

5m

Yes

Create an Oracle EPBCS Connection

Create a standard connection to Oracle EPBCS to exchange data, run Data Management jobs, perform conversions and other administrative tasks.

10m

Yes

Create an Oracle Analytics Cloud Connection

Create a standard connection to Oracle Analytics Cloud to exchange data and perform other administrative tasks.

10m

Yes

Create a Source Text File Connection

Access source data for the various exercises.

5m

Yes

Create a Relational Connection

Create a connection to either an Oracle or SQL Server relational database to query, load and execute commands.

5m

Yes

Part 1 - Load from Flat File to EPBCS

Load a sample text file to EPBCS as a cloud staging file

15m

Optional

Part 2 - Transform Base Source Data

Learn how to transform data with OneCloud

30m

Optional

Part 3 - Convert to Oracle Cloud EPM Format

Transform tabular data to Oracle's native Cloud EPM format

20m

Optional

Load OAC from Relational

Load a sample text file to OAC as a cloud staging file

15m

Optional

Synchronizing Data between EPBCS and OAC

Export and transform data from EPBCS to load into OAC

15m

Optional

Chain Promotion

Learn how to promote a chain from one environment to the next.

10m

Optional

Updated 9 months ago

OneCloud for Oracle EPM Cloud Quick Start


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.