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.
|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 7 months ago