sqdata - market experts

Consolidate multiple data sources (i.e., IMS, DB2, Oracle, etc.) into a single view.

+1.800.267.0730 | [email protected]

Data Integration and Synchronization

SQData provides a comprehensive range of data integration and data synchronization solutions that deliver fast time to value. With enterprise wide scalability, SQData solutions integrate disparate data sources and support multiple data delivery styles, enabling frictionless sharing of data across the entire enterprise.

Our solutions provide the power and flexibility to:• Move data from any source to a range of targets

(more than just traditional DBMSs) • Move data in any direction, using multiple data delivery styles • Move data with near real time latency • Move only data that is changed • Provide the confidence of consistency checking at the speed of data • Provide the ability to trigger business events based on data values

Choose the combination of data access, transformation and delivery options to ensure that timely and trusted data is available to all types of consuming applications and DBMSs:

• Synchronize your data multi-directionally amongst a number of like systems for high availability

• Replicate data changes to a live standby subsystem • Replicate changed data to a variety of heterogeneous systems on

different platforms and OS to make it available wherever you need your data

• Implement staged consolidation of data from a variety of heterogeneous systems onto a data warehousing platforms for BI

• Implement near-real-time conversion and integration of data between legacy systems and new systems.

• Create a single view of an object, such as an order, from a multiple of differently formatted source versions

D A T A S H E E T

Al low your legacy appl icat ions and new applications to seamlessly exchange data.

Maintain near-real-time synchronization amongst multiple databases with the confidence of LiveCheck™

SQDATA

Market Experts Distribution, SL | www.markedist.com [email protected] +34679 250 046 | © 2016 DataKinetics Ltd.

REPRESENTED BY:

http://www.markedist.com

mailto:[email protected]






SQDATAD A T A S H E E T


Data integration and replication options:








With any of these replication options, identify data of interest or capture events that can be:

• Routed to a different platform • Put on a queue, or other downstream delivery (options including XML, binary

or delimited) • Used for event publishing to capture key business events (such as trouble

tickets, orders, product shipments) • Used as a business event trigger (eg. for fraud detection) • Augmented with other information via lookups or joins • Forwarded to other applications

For those looking to upgrade their replication solution while maintaining their existing investment:

• Enhance your existing ETL with the addition of SQData’s CDC to maintain your investment in existing business rules and eliminate the replication of unchanged data

• Enhance your existing data replication with LiveCheck to provide superior checks for data consistency, at the speed of your existing data movement, to eliminate post-processing to address data inconsistencies

Highlights• Handles standard relational data (DB2,

Oracle, SQLserver), non- relational data (IMS, VSAM) and unstructured data, as well as many Big Data and Analytics targets such as IDAA/DB2AA, Pu reDa ta , Hadoop , Cassandra, etc.

• Has a proven track record of handling very large volumes of data

• Provides scalability: Modular architecture allows incremental addition of integration engines as needed

• Has a proven track record of capturing, processing and integrating complex database structures (IMS and VSAM)

• Provides comprehensive conflict detection and monitoring with SmartApply™; enables identification of conflicts that may occur during replication and specification of the actions that are to be taken – including compensate, and notify (if all the other rules are not able to be applied)

• Checks for data consistency at a high rate of speed while data is moving (LiveCheck™ with LiveSynch)

• Allows multiple options to format and transport information from source to destination(queues, XML, delimited, binary)

• High performance movement of large data volumes

• Multiple targets beyond databases, including Tibco, WMB, BizTalk, DataSource, Active MQ, etc

• Lets you specify near real time or deferred or trickle for replication

• Replicates data with different latencies, even on a table by table or object by object basis

• Replicates data from any source to any destination on any platform (see detailed list)

• Provides intuitive Control Center GUI to control and monitor the data integration interfaces from a single point

• Provides an easy to use and powerful scripting language that does not require specialized software programming skills

• Streamlines processing by using CDCstore for capture and transient storage on the specialty processor

• Can be completely automated eliminating any potential for human errors

• Designed to fit into existing version control framework










SQData Control Center• An easy to use web based GUI to link the data integration

interfaces from a single point • Lets you control and monitor the status of the integration

engines and obtain runtime statistics • Lets you see at a glance that status of the replication, and how

much data has been transferred • Accessible via mobile devices (iPhone and iPad)

SQData Design Studio• A powerful scripting language used to define the business

rules for SmartApply and for event capture • Integrated metadata repository contains target data mapping

and associated business rules. • Use the modelling feature to create relational DDL, XML, and

C/C++ structures from COBOL copybooks

SQData LiveCheck™• Checks source target integrity during active replication • Eliminates post-processing to address data inconsistencies • Provides data consistency for high-volume, 24x7 data

operations • Resynchronizes individual rows or ranges of rows (with

LiveSynch; available with LiveCheck™) • Can be added to existing CDC installations










z/OS X UNIX (AIX, Solaris and HP-UX) X zLinux X Linux X Windows X

Operating Systems z/OS Multi-platforms

IMS X DB2 X X DB2 Unload Utility X X VSAM X Oracle X MySQL X SQL Server X PostgreSQL X Greenplum X Teradata X Hadoop HDFS X Kafka X Spark Streams X Netezza (PDA) X DB2 Analytics Accelerator (DB2AA) X Flat Files (fixed,delimited) X X

Datastore Formats z/OS Multi-Platforms

COBOL Copybooks X X PL/1 Copybooks X X XML (DTD) X X C/C++ Headers X X Relational (DDL) X X Binary X X CSV (delimited) X X JSON X X

Data Formats z/OS Multi-Platforms

IMS > IMS/DC and CICS/DLI X VSAM > CICS and Batch X DB2 z/OS X Oracle X SQL Server X DB2 iSeries X

Data Synchronization z/OS Multi-Platforms

Technical Specification Summary

General• Concurrent operation across multiple operating

system platforms • Multi-step processes within a single script

(UNION) • Simultaneous multi-record type file handling • Multi-level array handling (repeating groups) of

source data store records/rows • Data filtering and cleansing • Dynamic lookup table processing • Support for data transfer and communication

using TCP/IP and MQSeries • Preservation of referential integrity (RI) rules on

target updates • Joins / merges of heterogeneous databases/files

Data Transformation• Case (if/else) logic • Extensive date cleansing and formatting • Arithmetic functions (add, subtract,

multiply, etc.) • Aggregation functions (sum, min, max,

avg, etc.) • Data type conversions • String functions • Data filtering • XML data formatting • Delimited data formatting Data Movement

• MQSeries • TCP/IP • FTP

Datastore Processing• High performance bulk data transfer • Concurrent processing of multiple data store

types • Creation of target data stores from source

data store format • Insert / append to existing target data stores • Update / replace existing target data stores • Delete from existing target data stores • New column / field creation data movement

Integration Engine Capability Summary

© DataKinetics Ltd., 2016. All rights reserved. No part of this publication may be reproduced without the express written permission of DataKinetics Ltd. DataKinetics and tableBASE are registered trademarks of DataKinetics Ltd. SQData is a trademark of SQData Corporation. DB2, z/OS, PureSystems, PureData, and Netezza are registered trademarks of IBM Corporation. All other trademarks, registered trademarks, product names, and company names and/or logos cited herein, if any, are the property of their respective holders.


D A T A S H E E TSQDATA

REPRESENTED BY:







sqdata - market experts

Documents