Duration

3 days (21 CPE credits)

Audience

Implementation consultants, developers, system administrators 

Course Summary

Learn the various approaches for loading source data into Oracle EPM Cloud applications using Data Integration (Data Management). Data Integration is available with all Oracle EPM Cloud and NetSuite Planning and Budgeting subscriptions and provides a comprehensive toolset for integrating source data with Cloud applications.

PLEASE NOTE:

• This training is designed for new EPM Cloud administrators who are not familiar with the ‘on-premises’ FDMEE solution.
• This course is also appropriate for those using NetSuite Planning and Budgeting 

How Can I Take this Course? 

You can search for scheduled course dates for your time zone or request a private class for your team:

Learning Objectives

By the end of this course learners will be able to:

• Identify how to set up source systems and target EPM Cloud / NetSuite Planning and Budgeting applications in Data Integration (Data Management)
• Differentiate between mapping types and how they are used to map source information to the correct target
• Recognize how to create Import Formats and how they can be used to format data as it is being imported into Data Integration (Data Management)
• Explain how Locations bring together the required information to successfully perform an import from the source and an export to the target application
• Implement SQL, Multi-Dimensional and Format Mask mappings
• Differentiate between Simple and Complex Logic accounts and their applications

Course Description

Explore the look, feel and functionality of Data Integration (Data Management) for the Oracle EPM Cloud and NetSuite Planning and Budgeting. Find out how to load data and discover how to synchronise data seamlessly across various systems. This course explores the creation and management of mapping tables and examines the process of building import formats to capture source data in a variety of formats. We’ll investigate the available data load options, such as loading data to multiple periods, adding trial balance and journal data and scheduling import jobs, allowing them to be run automatically.

We’ll also look at how to enhance the standard workflow by building in complexity through the use of import format expressions, logic accounts and advanced mapping techniques. This course is ideal for Oracle EPM Cloud administrators who are looking to maximize the potential of their cloud environments.

Scheduled Course Dates

Course title: Oracle Data Integration (Data Management)

Duration: 3 days

Audience: System administrators, developers and implementation consultants

Pre-requisites: None

Delivery method: Group Live and Group Internet-Based

Advanced preparation: None

Recommended CPE credits: 21 credits - computer software and applications

Programme level: Intermediate