oracle managed file transfer and hybrid customer …...mft role in oracle hcm cloud integration...

Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |

Oracle Managed File Transfer Cloud Service and Hybrid Customer Experiences [CON7327] David Berry, Strategic Director, iPaaS, Oracle Tommy Hoeglund, Manager, IT Systems Integration, The University of Melbourne Dilip Jain, Architect, SRI International


Safe Harbor Statement

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.


Program Agenda

MFT Update

Customer Update: The University of Melbourne

Customer Update: SRI International

Q & A

1

2

3

4

Oracle Confidential – Internal/Restricted/Highly Restricted 5


MFT Customer Highlights

• Customers spread across all verticals, many are live

• Traction with existing FMW, SOA and SaaS customers

• Primary use cases: sFTP(s) <-> eBiz/PSFT, internal apps

• Value Add: Encryption, visibility, SOA/B2B integration

• Replaced: Legacy, Custom, and ESB file solutions

– Often co-deployed alongside other file processing tools

• Cloud: MFT Cloud Service, Hybrid Cloud & SaaS/HCM Integration

Customer Quotes

“MFT doesn’t require tons of support. It’s off the shelf software with enough customization capability to adjust how it behaves to meet our needs. One less thing I have to worry about. It is 100% reliable. ”

“We love Oracle MFT”

“MFT is a great addition to a great integration platform”


Oracle Open World 2015 Session


SaaS PaaS

Uncontrollable problem of file exchanges

Proliferation of FTP servers & clients

No central control on exchanges of sensitive information

No global visibility

Not integrated with enterprise security standards: FTP servers are rarely integrated with directories

Single points of failure: FTP servers rarely offer HA capabilities

Self Managed: Pain of upgrades

Lack of control, visibility, security & reliability

Credit Data, 401k

Banks, Financial Institutions

Tax information

Administration Legal, PR

Contracts, Media

Employee Data

Service Providers


Oracle MFT – Functional Overview

• Enterprise Security – SSH, PGP, sFTP, SSL …

• Simple Console Based Designer

• Global Visibility & Management of File Transfers

• Large Pass-by-Reference File Handling

• Fully Integrated: SOA, WLS, iDM, B2B, ODI, WCC …

• MFT Cloud Accelerating Adoption: Hybrid + MFT CS

• Extensible by Integration or Programmatically

• Cloud endpoints, Event Triggers, REST API’s

send receive

FILE SYSTEM

Auditing Monitoring

Temporary store

Cloud

OnPrem

Available On Premise and Oracle Public Cloud


MFT Functional Use Case Patterns Sources

Transfers Targets Remote sFTP(s)

Local File

SOA Suite/SOAP

ODI/B2B/Healthcare

WebCenter/Oracle Cloud Storage

Embedded and Remote sFTP(s)

Local File

SOA Suite/SOAP

ODI/B2B/Healthcare

WebCenter/Oracle Cloud Storage 12.2.1

12.2.1

S T S T

Direct 12.2.1 - Run Now Event

Fan Out

T

T

MFT MFT

ODI Deliver and Notify 12.2.1

sFTP

ODI

S MFT

T

Pass-By-Reference

S MFT MFT

Document Collaboration 12.2.1

S T

S T DOCS

WCC

MFT

MFT

SaaS Deliver and Notify 12.2.1

WCC

HCM

S MFT

Hybrid Cloud

S

S

T

T

MFT

MFT SOA

SOA

MFT

Backup/Big Data 12.2.1

STOR

BIGD

S


16.3.3/5 MFT CS • Multi-node 12.2.1 cluster • MFT <-> ICS SOAP Adapter

CY15 CY16 H1 CY16 Q3

Oracle Managed File Transfer – Release Timeline

12.2.1 On Prem • OPC Storage. WebCenter • ODI binding types: sFTP • API’s: REST, Events • Schedules dashboard, New UI • Transfer Priorities, Notifications

12.2.1.1 OnPrem • PGP/SSH Certificate UI • Scheduled & Purge now UI • REST Management API’s • Target resiliancy, Performance • Actions: RunScript, Replace

12.1.3 On Prem • sFTP/FTP, Embedded servers • Visibility, monitoring • Security: PGP, SSH

12.1.3: MFT CS • Embedded sFTP (Push) • Remote sFTP (Pull) • User Clustered Provisioning • Metered + Non-Metered • Scheduled Purge

12.2.1: MFT CS • OPC Storage. WebCenter, ODI • OPC Storage. WebCenter • ODI binding types: sFTP • API’s: REST, Events • Schedules dashboard, New UI • Transfer Priorities,

Notifications

Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 12

SOA/MFT Cloud Service Supports 12.1.3 or 12.2.1


• Batch Load - Hybrid Cloud SOA onPrem to MFT Delivery(WCC) and Load(HCM)

Encrypt, Deliver and Notify

• Extract – Hybrid Cloud Retrieve(WCC) and Deliver onPrem SOA

Scheduled Retrieve and Deliver to SOA

• Cloud to Cloud MFT to/from ICS - PaaS

Fusion (WCC) to/from DOCS

Storage to/from BI - PaaS

• Secure SFTP Gateway Anywhere to Anywhere

Full Visibility, Encryption, Scheduling

Managed File Transfer Cloud Integration Patterns

MFT Cloud to/from

On Premise

MFT

SaaS PaaS


Scheduled Batch Load and Extract of HR Data

Hybrid or Cloud SaaS – MFT HCM File Integration Use Case

Outbound from Fusion

Inbound to Fusion

SFTP SOAP

RIDC SOAP

Benefits • Auditing, visibility, scheduling, security, encryption, notifications • Roadmap item works today with callouts

Use Cases • Employee status change, onboarding, termination, Payroll integration, 401k account sync

ORACLE MANAGED FILE TRANSFER

CLOUD SERVICE

MFT

Banks, 401k Providers


Program Agenda – Customer Updates

Tommy Hoeglund, Manager IT Systems Integration The University of Melbourne

Dilip Jain, Architect, SRI International

Oracle Confidential – Internal/Restricted/Highly Restricted 15

Oracle Managed File Transfer - An on premise implementation

Tommy Hoeglund

Manager – IT Systems Integration

Legacy

http://www.haneke.net/

Challenges

• Business

– Manual processes for file

transfers.

– Significant number of P1 and

P2 incidents.

– Long resolution time for

incidents.

– Reliant of one team for

monitoring and support.

– Significant support overhead.

• Technical

– Long setup time for new

transfers.

– Unreliable storage of data.

– Lacking visibility and ability to

resubmit processes.

– Complex design with lacking

instructions.

– Separate domain and

hardware.

Architecture

ODI Transformation

MFT Transfer MFT

SOA Orchestration

PGP Encryption

External Services

• Banks • Payment Providers • Superannuation Funds • Security Systems

Apps

Users

ZIP Compression

sFTP

File Copy

sFTP

Implementation

• Current State

– 6 month implementation on

existing hardware.

– 3,300 transfers per week on

average.

– Managed by application

support teams.

– No P1 or P2 incidents since

implementation.

– Continuously expanding with

automated transfers.

• Future State

– Access control to source,

targets and interfaces.

– Global configuration options

across transfers.

– Configurable notifications and

purge jobs.

– Customisable notifications.

Oracle MFT usage at SRI

Dilip Jain

Integration Architect

SRI International

© 2015 SRI International 23

Goals and Challenges

• Improve Security

– Lack of standardized process for encrypting files sometimes leads to unencrypted files at

rest.

– sFTP with External Partners did not leverage SSH Public Key Authentication. Password

management was a security concern.

– Multiple internal static IPs were shared with External Partners.

– Audit of file transfer was not available.

• Quicker turnaround for development and support

– Point-to-Point file exchange led to inconsistent design/development.

– Scheduled File Polling solutions often required manual intervention and fix took longer.


MFT role in Oracle HCM Cloud Integration Architecture

• SFTP Server vs MFT FTP

Proxy Server vs Oracle

WebCenter Content Server

Source Type (12.2.1)

• Encryption Gateway

– SFTP Server vs Service Provider

– File encryption

• SOA Target vs File Target Type

• Separate MFT Domain

• SSH Public Key vs Password

Authentication

• Upload to Oracle WebCenter

• Compress with SOA Source


Future State

• Source Reuse

– Use Content Filters

• Target Reuse

– For File/FTP/sFTP Targets, provide minimal folder. Provide remaining folder structure in

Transfer.

– For Archive, use a single File Target.

• UCM Target Type

• E-mail notifications

• MFT Schedule

• InlineXML to SOA


SRI International

• SRI International creates world-changing solutions making people safer, healthier, and

more productive

• Research center headquartered in Menlo Park, CA serving government

and industry

• Works primarily in advanced technology and systems, biosciences, computing and education

• Brings innovations to the marketplace through technology licensing, spin-off

ventures and new product solution

• Popular inventions – SIRI, MICR, Motobots

• 2100 employees with 41% advanced educational degrees


Oracle Process & Integration Cloud Demo Pods

SMI-016 Oracle API Platform Cloud Service

Moscone South, in Platform Showcase Middleware

SMI-017 Oracle Integration Cloud Service and Connectivity Adapters

SMI-018

Oracle SOA Cloud Service, Oracle Managed File Transfer Cloud Service, and B2B

SMI-019

Empowering Business Users with Insight into Their Processes and Streaming Data

SMI-020

Oracle Process Cloud Service

SMI-021 Oracle Self-Service Automation Cloud Service: Make Your Cloud Work for You


Compute CPU Shape

# OCPUs GB RAM

Network

SW Defined Security Access Lists

Block Storage

Disk Mounts # of GB

Java Cloud Service

Java Weblogic Coherence Clustering

MFT Provisioning Architecture

Using the PaaS Stack

Oracle Confidential –Restricted

SOA Cloud Service SOA Service Bus API Manager MFT Adapters/B2B

DB DBFS

Database CS

Object Storage Backups

Storage CS

PaaS Service Manager Provisioning Cloud Consoles Lifecycle/Management

OTD

Load balancer

MFT Cloud Service sFTP REST/SOAP Security PGP Visibility Storage Docs

MFT Runtime Architecture

oracle managed file transfer and hybrid customer …...mft role in oracle hcm cloud integration...

Documents