progress ppt template 16x9 - skyward€¦ · •choice of target database (ms sql, oracle,...

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.1

Pro2SQL

for Data Reporting

OpenEdge Replication

for Disaster Recovery

March 2017

Greg White

Sr. Progress Consultant

Progress

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.2

Introduction

Greg White

Sr. Progress Consultant (Database and Pro2)

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.3

Replication

Replication offers two opportunities

• Data Redundancy for Disaster Recovery

• Data Migration for Reporting and Business Intelligence

OpenEdge has a product for each

• OpenEdge Replication

– Provides Data Recovery Redundancy and Reporting

• OpenEdge Pro2

– Provides Data migration to MSSQL, Oracle, Progress

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.4

What is the need?

OpenEdge Replication DR

• Provides an OpenEdge Progress Database

A hot Stand by for failover and/or Data Recovery

• Data security and availability

• Replication Plus provides

– Real Time Read Only Access to off load query reporting

• Provide Local or offsite Target

Real-time

Replication

of Data

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.5

OpenEdge Replication for Disaster Recovery

Business Continuity has many

partsPersonnel

Risk

Assessment

Business

Impact

Analysis

High

Availability

Disaster

Recovery

Emergency

Response

Training /

Awareness

Public

Relations

Continuing

Operations

Business

ContinuityDisaster

Recovery

• From an IT perspective DR

is a much larger part of the

pyramid

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.6

What’s Your Exposure

Strategy RTO RPO

Basic Backup Strategy High High

After-Image Higher Med

After-Image w/roll forward Med Med

OpenEdge Replication Plus Low Low

RTO = Recovery Time Objective = “How long to recover?”

RPO = Recovery Point Objective = “How much data loss?”

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.7

OpenEdge Replication / Plus

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.8

OpenEdge Replication Plus

Near real-time replication

• Near zero-latency

• No data loss

• Guaranteed data integrity

Flexible database options

• Multiple target databases

• Read-only query access

Easy deployment

Automatic recovery

Continuous Availability With

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.9

OpenEdge Replication

Production

Server

OpenEdge

Replication

Server

DR Server

OpenEdge

Replication

Agent

As real-time as possible!

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.10

OpenEdge Replication – Two Target Servers

Production

Server

OpenEdge

Replication

Server

“ON-SITE” DR

Server

OpenEdge

Replication

Agent 2

“OFF-SITE” DR

Server

OpenEdge

Replication

Agent 1

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.11

OpenEdge Replication – Not Just Insurance

Production

Server

OpenEdge

Replication

Plus Server

DR & Reporting

Server

OpenEdge

Replication

Plus Agent

OpenEdge Replication

Plus

Operational

ReportsWebsites

Business

Intelligence

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.12

OpenEdge Replication provides a redundant set of data to be

used for Disaster Recovery in the event of a failure of the

production system.

OpenEdge Replication Plus allows you to do reporting on the

Disaster Recover Server.

Many times Reporting Needs exceed what OpenEdge

Replication can provide. Enter OpenEdge Pro2 Replication.

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.13

What is the need?

Pro2 Data Replication

• Choice of Target Database (MS SQL, Oracle, Progress)

• Timely Business Data / Business Intelligence

• Alternative Views of Data

• Heterogeneous Application Integration

• Data Consolidation / Archival

• Auditing

• Reporting

Real-time

Replication

of Data

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.14

Why is this a challenge?

Application-level replication is difficult

• Maintaining connectivity

• Managing different data types and data structures

• Complicated

• Hurts performance

Your replicated data is only as fresh as the last batch

• Disruption of normal business operations

• Poor performance

• Stale data

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.15

Evolution

Exporting data is a common practice

• Daily exports

Business decisions are made on the data

• More often exports are required

Unacceptable to make business decisions on stale data

• Real-time Replication

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.16

The Solution is Pro2

Real-time data replication

No connectivity limitations

No disruption to normal business operations or risk to your

system of record.

Create a channel for transferring Progress OpenEdge data

into a target databases

Use your third party reporting solutions and tools

A proactive approach to decision making and managing your

business requirements

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.17

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.18

What Is Pro2?

Supports Progress 8.3 – OpenEdge 11.x

Mature Product

Large install base

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.19

Skyward On Premise

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.20

Skyward in the Cloud

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.21

Pro2 Components

Change Data Capture

• Replication Trigger Based

• Keeps track of all updates

• Adds to a Replication Queue

Replication Process

• Manages the Replication Queue

• Pushes data to the SQL Server

Provides Real-time Replication

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.22

Skyward is Pro2 Enabled

Skyward has embedded the Pro2 technology in the product

• Change Data Capture is part of the product

• Easier Implementation

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.23

Pro2 Benefits

Low-impact and scalable

Records ABL and can capture SQL changes (via Java Stored Procedures)

Administration

Alerting

Customizable

Flexible Configuration

Overcome Target Limitations

Target schemas do NOT need to match

Constantly sends “net change”

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.24

With Pro2 You Can

Provide accurate data in near real-time to support better

business decisions

Leverage the value of the data in your system(s)-of-record

Tailor the data to match your specific needs

Overcome technology issues

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.25

Who uses Pro2 – 20+ School Districts

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.26

Summary

Real-Time Replication for Reporting

• Your data, Your way

Plugs Into any Existing Reporting Solution

Low Overhead and Easy Administration

Mature Product

© 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.27