Following its recent success with Australia's Department of Immigration and Citizenship (DIAC), Bateleur Software has once again clinched a deal down under, with the sale of locally-developed software valued at R500 000 to the New South Wales Police.
The software has been bought by NSW Police to extend the functionality of ADASTRIP. ADASTRIP is a utility built by CCA in Australia for the ADABAS environment, for very high-speed extracts of data, typically for data warehouse, creation of test data, or reporting applications. NSW Police has purchased eSTRIP and Exits, which are add-ons to ADASTRIP.
As part of the data migration reconciliation process in NSW Police's COPS Phase II Modernisation project, the agency is using ADASTRIP, eSTRIP and Exits to extract data in CSV format to send to the server platform, to compare with data loaded via the automated tcVISION bulk load process, to Oracle on the server platform.
According to Bateleur Software CEO, Sam Selmer-Olsen, the new solution means NSW Police will not need to write any code to extract data. “It is also much faster and more efficient than almost any other method that processes data on the mainframe,” he says. “This reconciliation will be undertaken against the entire migrated databases, a very large volume of data using the comparison tools available under Red Hat Linux.”
Selmer-Olsen explains that ADASTRIP is a very useful ADABAS tool that strips data from a file to create a new file. However, once it has been used, there is no easy way of 'marrying' the data left in the original file with that contained in the subsequent one.
“eSTRIP enables users to strip data from a file in which the records are dependent on a previous strip or some external data source. This means that once a 'parent' file has been stripped, the 'child' files can be stripped, and related records end up in the same output file,” he says.
In addition, a variety of user exits for ADASTRIP are available, which enable the extracted data to be formatted in various ways - ideal for sending the data to a PC.
For example, ZONEDEC, which sorts out the negative zoned decimal fields that cause a problem when the data is transferred to a different platform, and STRIPZIP, which combines the features of ZONEDEC and ZIPDITTO to convert the ADASTRIP output into compressed ASCII data as one smooth operation. This means the output dataset is smallest and the transmission time to server is short. STRIPCSV converts ADASTRIP output to a comma-separated-value format.
On the local front, Bateleur Software has also sold ADAMAGIC to NWK, an established agricultural business and leading provider of agricultural services, which boasts more than 100 years' experience in the South African market. NWK will be using ADAMAGIC to help migrate its ADABAS database from a mainframe server to a Unix server.
Developed by CCA Software, for which Bateleur Software is the official South African agent, ADAMAGIC is a utility for migrating and extracting mainframe ADABAS data to either ADABAS or flat files on Unix, Linux and Windows systems.
The benefits of ADAMAGIC include the ability to perform all processing on the server platform, with no impact on the mainframe, as well as ease of use. It also eliminates the need for specialist Natural programs to convert data.
“ADAMAGIC puts unparalleled control and flexibility in the hand of the database administrator,” Selmer Olsen says. “It makes difficult data migration exercises simple, fast, safe and efficient.”
For further information, call (011) 691-1600 or e-mail sam@bateleur.co.za.
Share