OneCloud

Oracle EPM Cloud Quick Start

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 already has a primary OneCloud environment, then simply use an alternative company name during the sign-up process. Example "Acme Corp - JSmith".

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 support@onecloud.io if you require additional guidance.

Task
Summary
Time Estimate
Required

Create Workspace variables and create environments for LCM.

5m

Yes

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

10m

Yes

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

10m

Yes

Access source data for the various exercises.

5m

Yes

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

5m

Yes

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

15m

Optional

Learn how to transform data with OneCloud

30m

Optional

Transform tabular data to Oracle's native Cloud EPM format

20m

Optional

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

15m

Optional

Export and transform data from EPBCS to load into OAC

15m

Optional

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

10m

Optional