Integrated Change Data Capture Technologies

tcVISION automatically detects data changes (read, update, delete) to databases and files on the mainframe and on Linux, UNIX, MS-Windows – without programming effort.

Efficient bulk transfer utilizing efficient powerful bulk processors

tcVISION provides powerful bulk processors. Mass data transportation for initial load or cyclic data exchange is easy, fast and reliable. Recovery and backup formats can be used for this purpose.

Extensive Metadata repository

The tcVISION repository contains all structure information, all replication rules, scripts for data transport and application to the target systems. It is the central place for control and surveillance of all exchange processes.

Data transformation & processing for the target systems

Comprehensive database and system-specific conversion logic avoids programming effort and makes a fully automated data exchange.

The tcVISION replication solution has a modular design. It supports mass data load from one source to one or more targets as well as continuous data exchange process in real-time with change data capture technology.

tcVISION Components

1. Transformation Platform with Repository

This contains all utilities of automatic data mapping to generate metadata for sources and targets, and the rule set for extracting the data from the source, the transformation/processing of the data for the target systems as well as the implementation into the targets. A cost-effective system platform such as UNIX or Linux is recommended for operating the tcVISION transformation platform.

2. Dashboard / Administration GUI – Command Line Editor

The tcVISION dashboard is provided for administration, review, operation, controlling, and monitoring of all data exchange processes. The tcVISION Command Line Utilities can be used to automate data exchange processes as well as for the “unattended” operation of data synchronization processes.

Environments Supported by tcVISION

Environments Supported

Mainframe Databases

Non-Mainframe Databases

Big Data / Hadoop

IBM z Systems

z/OS
z/VSE
Linux on z Systems

Distributed Systems

Linux on IBM Power Systems
IBM AIX
Microsoft Windows
Unix
Linux

IBM Db2
IBM IMS/DB / DL1
VSAM
Software AG ADABAS
CA IDMS/DB
CA DATACOM/DB
PDS/PS

IBM Db2 LUW
IBM BLU Acceleration
IBM Informix
IBM NETEZZA
Oracle
Sybase
Microsoft SQL Server
Software AG ADABAS LUW
PostgreSQL
Teradata
MongoDB
Flat File Integration
SAP Hana
MySQL / MariaDB

JSON
Avro
KAFKA
with Avro
with CSV
with JSON
Hadoop Data Lakes
HDFS
CSV

Cloud

Aurora MySQL
Aurora PostgreSQL
AWS S3
Amazon Web Services
Amazon Kinesis
Microsoft Azure
Amazon Kinesis
Azure SQL-Database
Azure Database for MySQL/MariaDB
Azure Database for PostgreSQL
Azure Event Hubs