Data Synchronisation: If you want to keep multiple copies of data within your organisation on the same platform i.e. z/OS or perhaps even on multiple platforms such as Unix, Linux or Windows then maintaining consistent data current across all of these copies makes it paramount that the data is synchronised in a fast and reliable fashion.
Especially important is that the system used has a very simple and easy to use interface that is robust and intuitive eliminating the guesswork and technical knowledge required to operate over multiple platforms and the myriad of databases and data structures typically used across today’s corporations.
tcACCESS is a transparent integration of mainframe data sources and mainframe programs into LUW applications using industry standards.
In a nutshell tcACCESS is a comprehensive software solution that enables two-way integration between IBM mainframe systems and client/server, Web and SOA technologies without the need for mainframe knowledge or programming effort.
tcACCESS is a proven platform that facilitates SQL-based integration of mainframe data sources and programs into LUW applications using industry standards such as SQL, ODBC, JDBC, and .NET. SQL queries to access mainframe data can be easily created using drag and drop techniques with no programming effort required.
Here you can find out a lot more about tcVISION and it’s data synchronisation capabilities which is why it has been selected as the go to platform for many organisations that just cannot afford even once to be using data on any of their systems that may not be current in real-time.
tcVISION is a powerful change data capture (CDC) platform for users of IBM mainframes and Open System servers. tcVISION automatically identifies the changes applied to mainframe and Open System databases and files.
No programming effort is necessary to obtain the changed data. tcVISION continuously propagates the changed data to the target systems in real-time or can perform the process in time intervals. tcVISION offers a rich set of processing and controlling mechanisms to guarantee a data exchange implementation that is fully audit proof.
tcVISION contains powerful bulk processors that perform the initial load of mass data or the cyclic exchange of larger data volumes in an efficient, fast and reliable way.
The growing number of distributed application systems that maintain their individual databases as well as the mobility of applications demand an ongoing exchange of data between mainframe and Open System server.
In a market with no borders and no time limits the end-user demands highly accurate and timely accurate information. Innovative solutions for an ongoing information exchange between the individual application systems are required to implement the “Real-Time Enterprise”.
The number of applications that operate a database is increasing and the demand to constantly synchronise data between the mainframe and Open System platforms becomes a critical operational issue.
This is even more important if a bidirectional synchronisation is required. The traditional methods for the exchange of mass data faces limits (limited batch windows) and the general cost pressure requires efficient solutions for data exchange, data synchronisation and data replication.
tcVISION supports different “capture” methods. These methods can be individually used as application and data processing flow requires it.
The changed data will be determined using database exits.
These are the standard exits provided by the DBMS.
The changed data can either be processed through tcVISION pools or via z/OS logstreams created by tcVISION.
The changed data will be determined through the processing of z/OS logstreams. z/OS logstreams may be available for VSAM/CICS or Shared VSAM in a Coupling Facility environment.
Logstreams can also be created by the tcVISION DBMS Extensions.
The changed data is selected and processed from the active and archived log files of the data source.
Compare Processing Data changes are determined by comparing a “snapshot file” and the current original file.
At the same time a new snapshot file can be created that will be used for the next compare.
tcVISION captures changed data for the following file organisations:
Yes, tcVISION offers an LUW Manager for capturing methods “Real-time/Near real-time” and “Log processing”. This manager can be used to make sure that all transaction changes are being applied to the target system in the correct sequence.
The changed data can be applied to any target system. These systems can either reside on IBM mainframes, UNIX/Linux/Linux on System/z or Windows platforms.tcVISION offers a variety of options how the changed data can be propagated to the target system (ODBC, DRDA, Oracle-OCI, XML, FILE, Db2, VSAM, IMS, DL/I, ADABAS, CA-Datacom, etc.).
No, changed data from Open System environments is applied in the file specific (e.g. VSAM) or database specific access method (e.g. IMS, Db2, ADABAS, IDMS, etc.). No additional third-party software components are required.
Yes, the changed data can be processed and maintained. tcVISION offers certain processing points (stages) to do it. The changed data is available in a processing specific format at any of these stages.
This guarantees a high degree of flexibility and assures that all processing requirements of your organisation can be handled. Processing rules can be stored in the tcVISION repository. These rules are automatically applied during the replication process.
No, modifications to the operating system (z/OS, z/VSE) are not required. The installation of the mainframe component is simple and straight forward. The distribution libraries must be loaded and a VSAM file must be allocated.
The implementation of the DBMS Extensions follows standard and well documented procedures. No IPL is required.
A graphical Windows application, the tcVISION control board, is used to create so-called “collector definitions” and “capture definitions”. These definitions specify the resources that should be supervised to capture changed data. The control board provides intelligent wizards that help in the definition process.
tcVISION offers graphical import functions to import copybooks for various programming languages (COBOL, Assembler, PL/I, etc.).
The database definitions will be included in the analysis (PSB, DBD) during the import of metadata for an IMS or DL/I database.
In the case of ADABAS and CA-Datacom the metadata will be automatically extracted from the corresponding dictionary. Metadata for CA-IDMS, including all navigation and connection parameters, are automatically extracted from SCHEMA definitions.
tcVISION analyzes the input data and checks for “Virtual Tables” (OCCURS, OCCURS DEPENDING ON, ADABAS Periodic Groups and Multiple Fields) and offers different processing options during the import. The structure information is stored in the tcVISION metadata repository.
The tcVISION repository is the central database for all structure information and data formats used by the installation. The repository can be hosted by any relational database management system like Db2, Oracle or MS SQL Server, hence becoming an integral part of customer specific environments.
tcVISION comes with an integrated loop-back prevention for a bidirectional data exchange. Individual criteria can be specified to detect and ignore changes that have already been applied.
tcVISION offers a comprehensive monitoring, logging and integrated alert notification. During the processing optional performance data may be captured and saved into a relational database of your choice. The performance data can be analyzed and graphically displayed using a tcVISION web component.
Yes, tcVISION offers an intelligent BULK load component. This component can be used to unload data from a mainframe or Open System data source and to load it into a target database either directly or by using a loader file.
Yes, the meta structure definitions from the tcVISION repository can be used to automatically create the SQL DML statements for the creation or the LOADing of the new target database.
The latest News about tcVISION can be viewed in the NEWS page
With tcVISION practically any computer participating in the propagation process of the changed data can be used to perform the conversion and normalisation, hence providing a workload balancing solution.
As an example, the captured data can be directly transferred in a highly compressed format to a UNIX machine that has enough free capacity to process the changed data and pass it through the various stages up to the creation of the change SQL-DML.
This technique provides the most optimal utilisation of available computer resources.