Double-Take Share:Easy, Automated Data Sharing is Possible!

Anne-Elisabeth CAILLOTSenior Solution Architect@AnneECaillot

Automate data sharing

Industrialize manual

processesSimplify data integration

Transform the Way You Do Business

Transform the Way You Do BusinessBreaks down barriers between • Multiple databases• Incompatible applications• Disparate platforms

Makes data sharing easy• Captures changes• Transforms the data• Replicates it to the desired

target

Allows for • Greater productivity• Higher profitability• Immediate ROI• All with no programming!

How can Double-Take Share transform the way you do business?

MigrationWhat is migration really?

• Hardware Upgrades• P->V, V->P, etc.• OS Version• Server Consolidation• Data Center Move (and to/from

Hosting)• SAN Migration (to/from or vendor)• Ground to Cloud• Database Vendor• Database Version• OS Vendor• Application Version• Reorg While Active

Modernization• Upgrading database version• Upgrading application version

Conversion• Moving data to new database or application• Switch to new operating system

Consolidation• Reducing # of database platforms• Standardizing on fewer vendors• Reducing number of DBs by

consolidating into a centralized database, data mart or data warehouse

Legacy

App/Database

Legacy

App / Database

New

App / Database

30% planned to consolidate/combine databases in the next year.

28% plan to convert to a different database.19% plan to reduce the number databases.

What are your migration plans?

Database Migration scenario

Supported Platforms

One Way Two Way

Cascade

Bi-Directional

Distribute

Consolidate

Flexible topologies

DT Share : Migration to Azure

BI, reporting, application… can work

directly from Azure

Replicated data are applied into a SQL DB in Azure

3

Users work on application locally

Target

Double-Take Share capture DB changes and replicate them

1

2

4

Sample screen

Source

DT Share at a glance

MonConThe monitoring and control interface is one of several ways to monitor the status of replication in real time. WebMonCon that allows monitoring through a web browser.

EDMMAll data replication rules including data mappings and data manipulations are stored internally using a scripting language in an Enterprise Data Movement Model.

DT Share – Component & Monitoring

Data is captured and shared as it changes, immediately and quickly replicated to other databases as specified

Only changed data is transferred, so efficient

Automatically handles the extraction, transformation (if any) and load to target database (no intervention or manual scripting)

Ensures write order consistency and guaranteed delivery

Change Data Capture - CDC

Log-Based Data Capture

TargetDBMS

Queue

SourceDBMS

Retrieve/Transform/Send

Apply

Changed Data

1

1 3

4

Log / Journal

ChangeSelector

Did you know? Double-Take Share can leverage published Log or Journal standards to identify and capture the change before copying to the Double-Take Share Queue

The Double-Take Share Queue ensures that data integrity is maintained and zero data loss occurs in the event of a dropped connection during file transmission

2

Guarantees Information AccuracyEnsures ongoing integrity

> Changes collected in queue on source

> Moved to target only after committed on source

> Ensures write-order-consistency retained

> Queues retained until successfully applied

> No database table locking

• Ensures failure integrity> Automatically detects

communications errors> Alerts administrator> Automatically recovers the

connection and processes> No data is lost

SMTP Alerting

Share exactly WHAT you need

Filters determine what data gets moved

– Select specific column and table

– Select specific rows and table

Share exactly HOW you need toTransforms data into useful information

> Over 60 built-in data transformation methods

> Fields: - DECIMAL(5,2)- nulltostring(ZIP_CODE,'00000')

> Tables: - Column merging- Column splitting- Creating derived columns

> Custom lookup tables> Create custom data

transformations using powerful Double-Take Share Java scripting interface

Manipulating Data

Target Column ExpressionsFast way to specify simple and medium complexity data manipulations

Join TablesIt’s possible to join tables together and build a new table on the target.

Replication Scripting Language (RSL)All data manipulations stored in a easy to readscripting language, which can be exported, edited and imported for advanced manipulations by power users. Also a big time saver in sophisticated enterprise environments with lots of tables.

Data Sharing Services from VisionQuick Start for new implementations• Accelerate your implementation

– Project planning workshop – Software installation– Custom configuration– Data sharing audit

• Fast-track staff proficiency with skills transfer– Model building– Data movement and monitoring

Update for existing implementations• Refresh your software

– Installation of the latest version of Double-Take Share

– Configuration tune-up• Update your skills

– Skills transfer to your staff on the latest features

– Gain a better understanding of your data sharing environment

19

DT Share : Migration to Azure

BI, reporting, application… can work

directly from Azure

Replicated data are applied into a SQL DB in Azure

3

Users work on application locally

Target

Double-Take Share capture DB changes and replicate them

1

2

4

Sample screen

Source

N° 21