The electronic registration procedure manages the church registration data with about 13 million people from a total of about 9000 parishes. tcACCESS and tcVISION synchronize the data between the z/VSE mainframe and the new application under WINDOWS with the SQL server database.
Two challenges had to be mastered for the migration of the application:
- The transfer of data from the mainframe with simultaneous conversion to MS SQL Server.
- Timely synchronization of 70 ADABAS tables with changes both on the mainframe and on Windows (bi-directional).
In particular, the special storage formats of ADABAS (multiple groups, multiple fields and a combination of both) are taken into account by the synchronization via tcVISION and implemented under MS SQL Server.
Important for the customer is the fact that tcVISION writes detailed logs and all changes are well documented.
The goal of processing all changes bidirectionally has been implemented.
All changes made by the parish offices in the SQL_Server database via the web application will be applied into the ADABAS database via tcACCESS/ODBC. tcVISION records these changes and they must not be propagated back to the MS SQL server. tcVISION offers a so-called LOOPBACK method for this. Changes made directly in ADABAS on the mainframe are replicated by tcVISION to SQL Server. The LOOPBACK function prevents replication back to ADABAS.