Data Migration

Automation Tools - Data Migration Framework (DMF)

Oracle Consulting Solution Center

Vinoth Kumar Devaraja
Vinod Vishwakarma

2 Confidential – © 2021 Oracle Internal

Agenda

1 Overview Data Migration Framework

2 Features
3 Coverage and Usage
4 Demo - Using DMF, Support and Links
5 Q&A

3 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Automations Tool - Data Migration Framework(DMF)

Automation tools

Evaluator Configuration Auto Data

Analyzer Configurator Migration
Automated extraction of
On-Premises custom Framework
components to enable Automated extraction of Automated load of
analysis of approach for On-Premises configuration configuration into Oracle Automated extraction of
handling in the Cloud and translation to Cloud Cloud pod On-Premises data,
configuration transforms, Validates and
Focus load into Oracle Cloud
Engage

Engage Focus Refine & Enable

4
Copyright © 2021, Oracle and/or its affiliates. All rights reserved.
Tools in Action
Presales Extract Valid Proposal
Foundation Data
Evaluator

Implementation
Extract Setup
Configuration Load Setup Data
Data
Configuration Auto
Analyzer Configurator

Extract Master
Master Data Load Master Data
EBS/PeopleSoft Data Oracle Cloud
(SaaS)
Data Migration
Transaction Data
Extract Tool Load Open
(Open Transaction,
Transaction Data Transaction Data
GL Balances)

5 Confidential – © 2019 Oracle Internal/Restricted/Highly Restricted

Data Migration Process
Prepare DM Cycle

Migration
Data Extraction Transformation Validations Import Reconcile
Strategy

Why Automation Tools:

• Accelerated DM Cycles on Migrating Data to Fusion Cloud from EBS or Template Files
• Automation of DM Activities with Set of Tools (Extractor Tool and DMF Application)
✓ Extraction – Data Extraction from EBS ,Peoplesoft – 360+ Prebuilt scripts. If other systems , Customer
to share the data in standard templates
✓ Transform – Framework to perform simple to complex transformation (COA Change, BU Consolidation)
✓ Data Error/Validation Reports– Highlight data issues before Import - Missing data, Setup dependent
data , Data issue due to tranformation
✓ Load and Reconciliation - Support data loading and do technical reconcilation with every cell
comparison
• Eliminate Data Risk , Save over 40% of Planned DM Efforts, Improved Data Quality, Rapid Migration
Approach and Stay Compliant
6 Confidential – © 2021 Oracle Internal/Restricted/Highly Restricted
How DMF Tool Works
Source Application

FBDI
HDL
REST
Spreadsheet
EBS/PSFT
Data Extractor
ORACLE
Extract
Data Files Target Fusion
Cloud

Fusion Source
Data Extract Options Data Migration Framework
1. Batch - DMF Extractor – On Prem Extraction/SOAR (Transformation, Validation, Import and Reconcile)
2. Offline - Flat Files: For non Oracle Sources / Customer
provides data file/SOAR
3. Online – Direct connectivity to Source System (Fusion , EBS**)
Confidential – © 2020 – Oracle Internal
7
DMF Features
Migration
Data Extraction Transformation Validation Import Reconcile
Strategy

Deployment &
Docs and Artifacts Extraction Transformation Validations Import Reconciliation
Security
•Artifacts •Source •Mapping File •1900+ Prebuilt •Fusion Cloud •Field by Field •Deployment
•Mapping Details : •EBS •Multi Column Validations •SCM Comparison •Oracle Data
Source to Target •PeopleSoft •Many to Many •Mandatory •ERP •Reconcile against center
•Extraction Scripts •Fusion Transformation •Format •HCM Migration activity •Customer PaaS
•EBS •Third party (Flat •Schema Access •Fusion •Import Type •Source File vs •Security
•People Soft Files) for Advanced Configuration Fusion •OSSA Approved
•FBDI
•Reconciliation •Extraction Modes Transformation •Lookups •Reconciliation •SSO
•HDL
Scripts •Logical Report
•Offline •REST •PGP Encryption
•Fusion •Online Validation •AES Encryption –
•Rapid
•Fusion Validation •Extractor Tool for •Data Dependent Spreadsheet Batch mode
Scripts On Prem •Extensible •Load , Import and •Data Purged in
•Config •Validation Report Purge weekly basis
•Data Dependent •Error review &
Log for HDL

8 Copyright © 2021, Oracle and/or its affiliates. All rights reserved.

Process Steps – SOAR/EBS Customer Oracle Consultant
Customer’s SaaS
Fusion
DMF Application

DMF
Extractor
Tool
Mapping
table

7. Oracle Consultant
1. Connects to 2. Executes a 3. Encrypt and 4. Consultant process 5. Consultant 6. Customer reviews migrates data to
Customer VPN / Extraction using Upload to the Data in DMF for places data files the data / cleans if
UCM(Automated by customer’s SaaS
Remote VDI and DMF Extractor or pre-validation and and pre- required and
Extractor tool) or Fusion. Data/ Error
fine tunes the SQL Developer. The transformation using validation report Approves the file for
CSV can be manually DMF Application. DMF /log Files will be
Query as per output of the and places the upload to Fusion
placed in agreed Automatically pulls placed in agreed
data rules and extraction scripts location ( SharePoint raw extracts in
data from UCM. CSV location for
transformation are a set of CSV , SFTP, Oradocs, the agreed
Files also can be Customer
files. Reviews the UCM) if extractor location
manually uploaded to Correction if any
count/data tool not used DMF if Extractor is not (SharePoint/Ora
data errors
used. docs /etc.)

Confidential – ©
9 9 2021 Oracle Internal/Restricted/Highly Restricted
Process Steps – non SOAR/Third Party Customer Oracle Consultant
Customer’s SaaS
Fusion
DMF Application

FBDI/ /
HDL/Other
Data
Templates
Mapping
table

7. Oracle Consultant
1. Oracle 2. Customer fills in 3.Filled templates 4. Consultant 5. Consultant 6. Customer review migrates data to
Consultant the data template as are placed in agreed generates CSV from places pre- the data / cleans if
location ( SharePoint customer’s SaaS
shares the per the required FBDI/HDL/Other Files validation report required and
/ SFTP/ Oradocs/ Fusion. Data/ Error
standard format or generates Template and uploads and places the approves the file for
UCM /) in DMF for pre- /log Files will be
templates to as CSV if volume is raw extracts in upload to Fusion
validation and placed in agreed
Customer to fill high the agreed
transformation using location for
in the data location
DMF Application. Customer
(SharePoint/Ora
Correction if any
docs /etc. )
data errors

Confidential – ©
10 102021 Oracle Internal/Restricted/Highly Restricted
Pre-requisites for Data Migration

• Agree on location for sharing data files – SharePoint/Oradocs/etc. Should be accessible by Consultant and
Customer.
• EBS DB Schema Credentials – Apps / Select access to standard tables
• EBS UI Access
• For Large/Complex Transformation and attachments extraction: Custom Schema in EBS to create Mapping
Tables, Packages , Function
• Connectivity to EBS
• (Recommended) -Customer VPN
• Remote Desktop / VDI
• Remote Desktop / VDI Prerequisites:
• Remote machine should be Windows OS – With min JRE 8 Installed , with min 8 GB RAM
• Mandatory Tools required in remote VDI: Microsoft Excel, SQL Developer , Notepad++. DMF Extractor Tool,
EBS Front End Access
• Optional Tools: SOAP UI, Postman , Winscp , ,Large Text Editor,
• Connectivity from VDI to Fusion Instances , EBS , Oradocs/SharePoint , Email
• Proxy Details if any – To connect fusion / EBS
• If VDI is shared between multiple consultants it should have required storage ,RAM, etc
DMF – Data Extract using DMF Extractor Client (Batch Mode)
2 3 Data Load
1 Data Extract Data Process

UCM
Data Fusion
Files Configs ESS
Oracle Logs
EBS DB

Web
Services

Fusion UCM
Data ESS
Files Transformation Services
User 1 Via Fusion UCM. No Logic & Mapping
Direct connection
DMF Client Tool Extracts Data
Files User 1 User 2

Fusion Database

DMF in Oracle/ Customer’s Fusion SaaS Application

Customer Network Customer PaaS (Optional)
12 Confidential – © 2021 Oracle Internal V8.Q1CY20
Security – DMF Application

• Oracle SSO Enabled. Oracle Hosted DMF can be accessed without any
• Not exposed in Public Internet and it can be prerequisite.
used only within Oracle network.
Prerequisites to deploy in Customer PaaS:
• Role Based Authentication , data access
controlled by Project level and user security Part Number: B90571 , DBCS Enterprise Edition
High Performance
• DMF Internally invokes standard Oracle Cloud
web services for import and Oracle cloud web Shape: OC5, 2 OCPU /16 GB Memory
services are secured with https TLS1.2 and Storage: 250 GB , OS: Linux
same https authentication is used. Recommended provisioning is to have DBCS and
• DMF does only outbound connection. Does SaaS in the
not exposes any data. No API are same data center region
enabled/exposed.
• No password is stored in DMF and it will be
entered in the tool at run time for processing.
• Auto provisioned in Oracle
DMF Extractor Client Tool - Overview

• Used to perform data extraction of EBS/Legacy data and push the extracted data to DMF Server for
further processing and migration.
• Standalone Light weight Java based tool can be installed on Windows Laptop/Desktop. (Similar to
SQL Developer)
• Can be used by consultant or customer to extract data
• Can connect to EBS over Customer VPN or can be installed on Customer remote desktop machine
which has access to EBS.
• Avoids manual task of running SQL in SQL Developer and eliminates transferring files over drives.
• Files are transferred via Customer Fusion UCM and encrypted.
Data Extraction – Extractor Tool - On Prem

2 • Extractor Tool/ Batch

mode : On Prem
Customers – EBS
3 • Windows Desktop Tool
1 for extraction.
1. Review and Modify the
Extraction scripts from
Update Query tab
2. Enter Source
Credentials
4 3. Enter Target
Credentials
5
4. Select entity
6
5. Extract and Revie Data
6. Zip and Upload to
UCM

15 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Security and Prerequisites – Extractor Client

• Connects to EBS/Legacy data secured as similar to

SQL Developer.
• No ports are opened on the on-premises system for
communication.
• All communication is via Fusion Web services which
is secured using SSL https 443.
• The DMF Client can use a proxy to access the Fusion
Instance optionally for additional security.
• No private SOAP/REST-based web services are
exposed.
• No existing J2EE container is required to deploy the
DMF Extractor Client.
• Data is persisted only till extraction, post extraction
it is deleted from the machine post zip. Prerequisites:
• Windows Laptop/Desktop which has access to EBS Database
• All files are encrypted and zipped. Post upload files
are deleted by Client tool • Recommended to have Min 4GB Memory Free.
• Machine should have access to Internet/Fusion Instance i.e should
be able to open the customer fusion instance over browser on the
same machine this tool has been installed.
• JDK
Data Processing in DMF Application – Pick file from UCM

1. Choose the Batch

Mode
2. Choose the batch
name/version and
Submit Run
3. DMF Will pull data
from UCM and
remaining process will
remain same.

17 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

DMF Application – OSSA Certified
Need for Data Migration Framework Tool
• Approximately 25% of effort in an implementation
Effort
project is taken by data migration

• Generally data migration involve manual work and

Quality
error prone because of data quality and volume

• Migrations takes time for extraction,

Duration
transformation ,validation and migration

Multiple • On a Implementation project data migrations are

Instances done in multiple cycles in different instances

Multi • In multi country implementations the data

Country migrations are to be done for different
Roll Outs countries/Business Units/Ledgers

Data • There is no standard way to extract the data in

Validation required format and ensure it is proper
19
Confidential – © 2021 Oracle Internal
Coverage & Usage

20
Copyright © 2020, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted [Date]
ERP Coverage

Fixed Assets & Cash

General Ledger Payables Receivables PPM
Management
• GL Journals & • Suppliers • Customer Import • Fixed Asset Mass • Project Budgets
Balances • Bank Accounts • Detailed Additions • Project Forecast
• Detailed Journals • Addresses • Simplified • Banks • Project
• YTD Opening • Sites • AutoInvoice Import • Branches • Project tasks
Balances • Site Assignments • Standard Receipt • Cash Management • Import Project
• PTD Period Balances • Contacts Import Bank Statement Data Miscellaneous Costs
• Budgetary Control Import
• Business
Budget Import Classifications
• Import Account • Products and
Combinations Services Categories
• Import General • Payables Standard
Ledger Budget Invoice
Balances
• Import and Calculate
Daily Rates

21 Confidential – © 2021 Oracle Internal

SCM Coverage

Order Management &

Procurement Inventory Manufacturing Maintenance
Supply Chain Planning
• Import Requisitions • Item • Work Definition • Price List • Import Installed Base
• Purchase Orders • Item Structure Import • Import Sales Orders Assets - Maintenance
Import • Receiving Receipt • Work Order Import • Standard Costs Asset Number
• Blanket Purchase Import • Work Order Material Association
• Supply Chain
Agreements Import • Inventory Transaction Transaction Import Planning Sub • Import Installed Base
• Contract Purchase Import On Hand Qty • Work Order Resource inventories Assets - Maintenance
Agreements Import Transaction Import Asset Number
• Supply Chain
Attributes
• Import Suppliers • Work Order Operation Planning Units of
Transaction Import Measure • Item - Maintenance
• Addresses
Asset Group
• Sites • Supply Chain
Planning Routings • Import Installed Base
• Site Assignments Assets - Maintenance
• Business Asset Numbers and
Classifications BOM
• Products and • Maintenance Work
Services Categories Definition Import
• Contacts • Maintenance Work
Order Import

22 Confidential – © 2021 Oracle Internal

HCM Coverage

Core HR Absences Compensation Recruiting Cloud Talent Learning Cloud

• Work Structures • Assign Work • Salary Basis • Candidates • Goal • Course, Offering
• Worker Schedules • Basic Salary • Requisitions • Goal Plan Details
• Supervisors • Absence Entries • Element Entries • Candidate Job • Goal Plan Sets • Legacy Learning
• Contracts (Sick, Vacation • Element Entry Applications • Talent Profiles Items
etc.) Values • Learning Record
• Person Contacts • Content Items
• Pre-books • Payroll
• Department, • Education
Organization • Absence Relationships Establishments
Hierarchies Accruals • Bank, Branches • Rating Models
• DFFs, KFFs • Entitlements • External Bank
• External Accounts
Identifiers • Personal
• Users, Roles Payment
• Area Of Methods
Responsibility
(AOR)

23 Copyright © 2021, Oracle and/or its affiliates. All rights reserved.

Master
Supplier Banks
• Suppliers
Location Suppliers

Customer Bank Employees

• Customers • Job Code
Customer
• Locations
• Departments

Items Item Structures

• Item Categories • Item Categories
Item Categories
• Suppliers • Items
• Locations

24 Copyright © 2021, Oracle and/or its affiliates. All rights reserved.

Transactions
Projects & Task Project Financial Plan Project Budget Project Cost Project Asset and
• Employees • Projects • Projects • Projects Assignment
• Employees • Projects

Procurement AR Receipts AR Invoices Project Billing Events Project Contracts

Agreements • AR Invoices • Customers • Projects • Projects
• Item , Item Structure • Customers • Employees
• Locations , Suppliers, • Items
Employees • Locations

PRC Contracts PRC Sourcing Rules Purchase Order AP Invoices

• Item ,Item Structure • Item , Item Structures • Locations, Employees • Suppliers
• Locations, Suppliers , • Suppliers • Projects , Suppliers Fixed Assets
Employees • Item Category, Item and
Structure

General Ledger
25 Copyright © 2021, Oracle and/or its affiliates. All rights reserved.
Tool Usage

169 58
Projects in Last
Projects 6 months

19841 99
Migration Runs in Last
6 months Active Users

97 360
Migration Entities / Extraction
Objects/Entity Scripts
Groups
26 Copyright © 2021, Oracle and/or its affiliates. All rights reserved.
Projects where DMF used ( 169+)

27 Confidential – © 2020 – Oracle Internal

Demo

28
Copyright © 2020, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted [Date]
Access to Data Migration

Account Creation Sign-in Project Creation

• Navigate to • Sign-in using SSO • Single Project for a Customer

http://ip.oraclecorp.com/
• Click on Request Access • Add multiple Source and
• Search for ‘Data Migration’. Click fusion Instance
on link to the asset.
• Email notification sent on
approval • Project Admin maintains the
• Direct Link to Data Migration- team members
https://dmf.in.oracle.com:8080/a
pex/f?p=100
• Project Closure & Data Purge

29 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Access to Data Migration Framework

Login to IP Portal (http://ip.oraclecorp.com/) & search for ‘Data Migration’. Click on link to the asset.

30 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Access to DMF – Account Creation

▪ Click on ‘Request Access’

31 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Access to DMF – Account Creation

32 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Access to DMF – New Project Creation

1. Navigate to Projects
3
Access
1 2
2. Click on New Project
1. Search for existing
Project OR
2. Create a New
Project
3. Click on Project
Settings
4
4. Once a New Project
is created, Project
Admin can manage
team members
5 5. Add Fusion Instance
and Source if
33 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022 applicable
Migration Activities

34
Copyright © 2020, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted [Date]
Migrate Data – Submit New Run

1. Navigate to Migrate
Data

2 2. Select the Project

1
3 3. Click the Entity to be
4 migrated

4. Click on Submit New

Run

35 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Migrate Data – Submit New Run

1. Choose the
5
Migration Options
1 2. Select the Source
4 File
2 1. Upload File –
3 CSV,ZIP
2. Fetch Batch File –
On Prem Source
3. Online – Fusion
3. Enter Fusion
Credentials
4. Review the
Transformation,
Validation, Recon
Setting if applicable
5. Click on Submit Run
36 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022
Migration Run - Validation

37
Copyright © 2020, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted [Date]
Validations

Mandatory Check Data Exists in

• Single Columns mandatory • Lookup – Single Column
• Multi Column Mandatory • Fusion - Single Column
• Mandatory based on Data • Custom List – Single Column
File • Fusion - Multi Column
• Mandatory based on Fusion
Setup
Unique
• Single Column Unique - Case
insensitive
• Multi Column Unique – Case
insensitive
Migrate Data – Review the Run

1. Review the
Migration with
7 Summary of Run
2. Transformed Details
3. Validations
6 Summary
1 4. Fusion Import
2 3 4 5
Details
5. Reconciliation
Details
6. Ribbon Status of
every activity and
download the
respective files
7. Resubmit if
Required
39 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022
Migrate Data – Validation Summary and Report

1
1. Entity level
Summary
2. Error Message wise
summary
2 3. Unique Data wise
error summary

40 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Migrate Data – Extend Validation if required

1. Navigate Migrate
Data→ Entity →
Click on Entity to
1 open settings
2 2. Click on Entity
Validation
3 3. Add New Validation
or modify existing
4. Enter the validation
type and details
5. Save
4

41 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Transformation / Data Updates

42
Copyright © 2020, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted [Date]
Entity Settings – Define Transformations

1. Navigate Migrate
Data→ Entity →
Click on Entity to
1 open settings
2. Click on Entity
Transformations
3 2
3. Add New
Transformation
3 4. New Transformation
Name
4
5. Upload mapping
File
5 6. Select columns to
be transformed and
save

43 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Migrate Data – Review Transformation

1. Review the
transformation
details
2. Click to review the
transformed data
3. Advanced Script
based
Transformation can
1 be performed using
DMF DB Project
Schema via
2 SQL/PLSQL

44 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Import to Cloud

45
Copyright © 2020, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted [Date]
Migrate Data – Import Details

1. Navigate to Import
Run tab to review
Fusion Import
details
5 2. Review the Purge
Program Status
1 3. Review the Load
Program and log
3 4 files
4. Review the Fusion
2
Import Program and
log files
5. Download complete
Import Details

46 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Reconciliation

47
Copyright © 2020, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted [Date]
Reconciliation

Suppliers Extract data from Import/Reconcile Data

EBS/Data Files
provided

1. Suppliers
Already
imported
Data
Migration
•
•
Reconciliation Report with Status
Extract of Base Fusion Data(FBDI
Framework format)
Scenarios

• Import Status/Import Log

2. Import &
Reconcile
Data
Migration
•
•
•
Reconciliation Report with Status
Extract of Interface Fusion Data
Extract of Base Fusion Data(FBDI
Suppliers Framework
format)
Migrate Data – Reconciliation

1. Navigate Migrate
Data→ Entity →
1 Resubmit Run
2. Click Recon Tab to
view standard
criteria
5
3. Change Recon
Criteria –
Add/Remove
2 Columns
4. Choose the recon
3 report
5. Submit Run

49 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Migrate Data – Reconciliation Details

1. Click on
1 Reconciliation
3 Ribbon to view the
2 4 recon dashboard
5 2. Download the
Interface table
report
3. Download the
Fusion base table
report
4. Download Recon
report with Field
Level Comparison of
Source File and
Fusion
5. Reconciliation
Overview – Fully or
50 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022
Partially Reconciled
Migrate Data – Reconciliation Details

1. Summary shows
1 which primary
columns got
reconciled and
unreconciled
columns
2. Could of records
Column level
3. Detailed Recon
2 3
details

51 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Extraction

52
Copyright © 2020, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted [Date]
Data Extraction – Offline ( for third party source or non SOAR)

1. Offline mode used for

Third Party Sources or
Extraction is customer
responsibility.
2. FBDI/HDL/REST
Format– CSV/ZIP files
3. Generate CSV from
standard template and
provide as input.
4. For REST , templates
as per Entity Column
5. Use Transformation for
Customer own
template

53 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Entity Settings – Extraction Scripts

1. Navigate Migrate
Data→ Entity →
Click on Entity to
1 open settings
2. Click on Entity
Extract Query
3. View and Modify as
2
per project
5 requirement
4. Apply Changes
5. View Scripts History
3

4
54 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022
Data Extraction – Online

1. Online mode : Fusion

Source and EBS Source
( if DMF deployed in
Customer Paas with
Site to Site
connectivity)
2. Modify the Extraction
scripts specific to
project criteria
3. Submit run with source
credential to pull data
directly

55 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

DMF – Online Mode Extraction
2 3 Data Load
1 Data Extract Data Process

UCM
Fusion Source Data Fusion
ESS
Files Configs
Logs

Web
Services
Port: 443
:VPNaaS
Oracle
EBS ESS
Prod Programmatically Extracted Datafiles Services

Customer’s On Premise Source System

@Customer’s premise User 1 User 2

Fusion Database

Customer’s Fusion SaaS Application

@Oracle Public Cloud
DMF
56 Confidential – © 2020 Oracle Internal/Restricted/Highly Restricted V8.Q1CY20
DMF – Data Extract using DMF Extractor Client (Batch Mode)
2 3 Data Load
1 Data Extract Data Process

UCM
Data Fusion
Files Configs ESS
Oracle Logs
EBS DB

Web
Services

Fusion UCM
Data ESS
Files Transformation Services
User 1 Via Fusion UCM. No Logic & Mapping
Direct connection
DMF Client Tool Extracts Data
Files User 1 User 2

Fusion Database

DMF in Oracle/ Customer’s Fusion SaaS Application

Customer Network Customer PaaS (Optional)
57 Confidential – © 2021 Oracle Internal V8.Q1CY20
DMF Extractor Client Tool - Overview

• Used to perform data extraction of EBS/Legacy data and push the extracted data to DMF Server for
further processing and migration.
• Standalone Light weight Java based tool can be installed on Windows Laptop/Desktop. (Similar to
SQL Developer)
• Can be used by consultant or customer to extract data
• Can connect to EBS over Customer VPN or can be installed on Customer remote desktop machine
which has access to EBS.
• Avoids manual task of running SQL in SQL Developer and eliminates transferring files over drives.
• Files are transferred via Customer Fusion UCM and encrypted.
Data Extraction – Extractor Tool - On Prem

2 • Extractor Tool/ Batch

mode : On Prem
Customers – EBS
3 • Windows Desktop Tool
1 for extraction.
1. Review and Modify the
Extraction scripts from
Update Query tab
2. Enter Source
Credentials
4 3. Enter Target
Credentials
5
4. Select entity
6
5. Extract and Revie Data
6. Zip and Upload to
UCM

59 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Security and Prerequisites – Extractor Client

• Connects to EBS/Legacy data secured as similar to

SQL Developer.
• No ports are opened on the on-premises system for
communication.
• All communication is via Fusion Web services which
is secured using SSL https 443.
• The DMF Client can use a proxy to access the Fusion
Instance optionally for additional security.
• No private SOAP/REST-based web services are
exposed.
• No existing J2EE container is required to deploy the
DMF Extractor Client.
• Data is persisted only till extraction, post extraction
it is deleted from the machine post zip. Prerequisites:
• Windows Laptop/Desktop which has access to EBS Database
• All files are encrypted and zipped. Post upload files
are deleted by Client tool • Recommended to have Min 4GB Memory Free.
• Machine should have access to Internet/Fusion Instance i.e should
be able to open the customer fusion instance over browser on the
same machine this tool has been installed.
• JDK
Data Extraction – Batch Mode

1. Choose the Batch

Mode
2. Choose the batch
name/version and
Submit Run
3. DMF Will pull data
from UCM and
remaining process will
remain same.

61 Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022

Links

• End to End Features demo: https://otube.oracle.com/playlist/dedicated/154812112/1_4l9jugtr/1_1g9l2pcy

• DMF Confluence:
https://confluence.oraclecorp.com/confluence/display/SOARDMF/SOAR+Data+Migration+Framework
• How do I Get access to tool and quick start:
https://confluence.oraclecorp.com/confluence/display/SOARDMF/How+do+I+get+Access+to+the+
Data+Migration+Tool
• Training Videos:
https://confluence.oraclecorp.com/confluence/display/SOARDMF/Training+Videos
• FAQ: https://confluence.oraclecorp.com/confluence/pages/viewpage.action?pageId=2050071286
• Security and Compliance:
https://confluence.oraclecorp.com/confluence/display/SOARDMF/OSSA+Compliance
• What are the entities Supported and Mapping details :
https://confluence.oraclecorp.com/confluence/pages/viewpage.action?pageId=2004271843

62
Copyright © 2021, Oracle and/or its affiliates | Confidential: Internal 8/23/2022
Please feel free to reach to know about DMF
Tool and DM Services

[email protected]
[email protected]

Thank You

63 Confidential – © 2021 Oracle Internal/Restricted/Highly Restricted