Reference data for the control of business processes are an essential element of corporate management at ista. This data is used in countless ista applications. Quality assurance is of great importance especially
when maintaining this reference data.
Since 2008, ista is using BOI software – TABEX4 – on the mainframe to maintain its reference data. As a leading, cross-platform standard software for table access and table maintenance, TABEX4 enables efficient and audit-proof management of reference, control, and parameter data. The user-friendly web interface offers secure data management, even
with complex data organization in the company. Thus, even employees without IT or database knowledge can perform quality-assured, efficient maintenance of all data. At ista, TABEX4 is used to implement e.g. the parameterization of programs, control of automated maintenance tasks and accounting, software access control, and mapping of the corporate structure including address information and teams in an audit-proof,
secure way.
During migration from mainframe to Linux, the TABEX4 installation was also moved to Linux. The project was realized cost- and time-efficient and the previous configuration was retained. Since November 2019, ista‘s reference data are being maintained in SQL databases on Linux by more than 100 professional users – with identical user interfaces and maintenance tasks similar to the mainframe.
ista, a global leading energy service provider, adds sustainable value to buildings for their residents. ista manages data and processes to make buildings climate-friendly, safe and comfortable. As a driver of innovation, ista consistently directs its infrastructure towards the Internet of Things.
Migrating the reference data maintenance from mainframe to Linux
For 12 years, ista has relied on TABEX4 for the maintenance of its reference data. With its configurable authorization and client system, TABEX4 enables mapping of the ista-specific organization of data and roles.
In 2018, ista decided to replace the mainframe and operating system z/VSE, and migrate all applications to Linux. At the same time, TABEX4 should be migrated to Linux as well.
ista maintains its reference data in TABEX4 and stores it in the BOI-specific table format. Data is centrally available for high-performance access by
ista applications. For this purpose, the TABEX4 application data was stored on the VSE host. Daily operation, maintenance, and administration
were carried out via the TABEX4 Client/Server System.
An important criterion was that the migration should not result in any changes in the reference data maintenance for the employees in the respective departments. In addition, tight deadlines had to be met. Once again, TABEX4 was able to prove its strengths and enabled a time- and cost-saving migration to Linux.
Migration of the audit-proof TABEX4 reference data maintenance from z/VSE to Oracle on Linux
The following project objectives were defined:
Identical maintenance process for reference data on Linux
TABEX4 Ultimate is platform neutral and thus compatible with many common operating systems. Therefore, TABEX4 can be used not only on the mainframe but also on server systems.
By default, TABEX4 is used with the proprietary table format. With the add-on „Relational Bridge“, all TABEX4 functionalities can also be used for tables from relational databases: „Relational Bridge“ enables the comfortable and audit-proof maintenance of table data from different RDBs with the same TABEX4 User Interface.
All project objectives were achieved with the successful migration from z/VSE to Linux-Oracle:
BOI’s close adherence to schedules and budget made the successful, on-time migration of TABEX4 from mainframe to Linux possible.