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


Introduction

Greg White

Sr. Progress Consultant (Database and Pro2)


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


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


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


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?”


OpenEdge Replication / Plus


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



Production

Server

OpenEdge

Replication

Server

DR Server

OpenEdge

Replication

Agent

As real-time as possible!


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


OpenEdge Replication – Not Just Insurance

Production

Server

OpenEdge

Replication

Plus Server

DR & Reporting

Server

OpenEdge

Replication

Plus Agent


Plus

Operational

ReportsWebsites

Business

Intelligence


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.


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


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


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


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


What Is Pro2?

Supports Progress 8.3 – OpenEdge 11.x

Mature Product

Large install base


Skyward On Premise


Skyward in the Cloud


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


Skyward is Pro2 Enabled

Skyward has embedded the Pro2 technology in the product

• Change Data Capture is part of the product

• Easier Implementation


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”


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


Who uses Pro2 – 20+ School Districts


Summary

Real-Time Replication for Reporting

• Your data, Your way

Plugs Into any Existing Reporting Solution

Low Overhead and Easy Administration

Mature Product

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

Documents