Case Studies

Find out how businesses use our products to solve real world problems by reading the case studies below.

Delek Motors, importers of Mazda, Ford and Cadillac, have chosen Vrtech LinkIt as the solution for importing and displaying documents in their Garage Management System

delek-motors

Delek Motors, a leading automotive importer in Israel, operates more than 40 garages all over the country, all of which use an AS/400 server-based Garage Management System. The system is located at the company's main office, and users access it by AS/400 Emulation over the Web.

In the past few years a new demand developed for adding photos of damaged vehicle parts in the Garage Management System and display them on demand. Administrative workers in the garages complained that they cannot view the photos directly in the Job Card on the system and demanded to replace the existing iSeries system with a new one that supports this functionality.

With Vrtech LinkIt the IT department solved the problem easily, without any code changes in the software and without replacing the existing iSeries system. LinkIt was installed in the company's main office, where the photos arrive from the various garages by e-mail. End users in the main office use LinkIt to import the photos from the e-mail boxes into the Garage Management System and automatically index them.

Delek Motors also installed LinkIt on user workstation in garages all over the country. As soon as the photos are imported, the system can display them to every user in the garage. Using Web service technology to display photos, the system ensures secure access to the main office server. Every employee in the garage can now view the photos directly in the system, which put an end to demands for the replacement of the iSeries system.

After this successful implementation, the IT department used LinkIt abilities (rather than e-mail) to distribute internal leaflets and documentation among remote garages. The leaflets and documentation are displayed directly in Word format, within the Garage Management System.

LinkIt contains many additional integration capabilities, and Delek Motors employees now also use it to export data to Excel. Data displayed on the emulation screen can now be exported to Excel with one click. This ability saves both time and IT resources, and enables end users to export authorized data to their Excel spreadsheet on demand.

LinkIt was sold to Delek Motors as a site license, and it was implemented in 30 days.

Maccabi Health Services purchased the Vrtech LinkIt utility as a solution for creating service agreements with physicians and other medical staff.

macabi-en

Every month Maccabi must renew agreements with physicians and medical staff. Producing the agreements used to require a great deal of time and human resources. The existing iSeries system that manages the agreements was not capable of supporting the activity adequately, and many complains reached the IT manager. Users demanded a solution to the problem or a new system.

Maccabi examined many products, but only LinkIt supplied a quick and easy solution. After LinkIt was installed in the medical staff department, end users were able produce agreements efficiently by merging attachments in Word format with data from Maccabi's AS/400. The process has become quick and easy, and it saves many hours of hard work.

David Amital, IT Manager at Maccabi Health Services, says: "LinkIt integrated easily with the medical staff management system, without requiring any special training for end users. Documents produced from system data are displayed on the end user screen effortlessly, with one click. Employee pressure to replace the existing system has stopped completely."

Yana Riahi, Joint CEO at Vrtech: "LinkIt was introduced to the market three years ago and it has been a great success with AS/400 users. Over 1,500 copies have been sold to various companies all over Israel. LinkIt has been implemented in many different applications in numerous industries, including health care organizations, manufacturing, real estate, automotive, and more. The product protects the investments in existing AS/400 systems and enriches the application with many integration capabilities for PC and Office applications."

VRTech's ExcelIt was integrated with the Aman Computers Group applications and distributed as an OEM module. logoAman

Aman Computer Systems is one of the leading computer firms in Israel. It provided numerous  iSeries systems that serve hundreds of  customers in Israel.

For the new version of the iSeries system, Aman wanted to have the ability to export data from legacy systems to Excel spreadsheets. The solution was required to offer control of logos, captions, subcaptions, and fonts. Spreadsheets were expected to be saved in user folders or sent by email.

VRTech's ExcelIt was selected to provide this functionality. ExcelIt is integrated with the Aman applications and distributed as an OEM module. With ExcelIt, Aman users can export data to Excel spreadsheets with one click. Exporting takes place on the server, rather than on the user station, to avoid exposing the database to unnecessary risks. Spreadsheets are saved in user folders or sent by email.

ExcelIt is activated by a command issued in iSeries, and provides all design control functions directly from within the iSeries applications.

Chemipal implemented VRTech’s Spool2Office to obtain the spool files in Excel format. chemipal

Chemipal is a leading distributors of pharmaceutical products, including such brands ‎as Avent, 3M, and PHILIPS‏.‏

Chemipal has been using an iSeries legacy system for many years. End users of the ‎system requested to be able to obtain the spool files in Excel format in order to ‎manipulate data according to their needs‏.‏‎ VRTech’s Spool2Office application ‎provides users with this capability.‎
It took only a few hours to integrate the product, and no ‎‏code changes in the legacy ‎system were necessary. Today, end users create a spool file in a specific output queue, ‎and the corresponding Excel spreadsheet is placed in the user folder on the network.
‎‏


David Lubinski ltd
using BatchFTP to synchronize company data with the manufacturers' data automatically.
Lubinski

David Lubinski ltd
is one of the leading auto importers in Israel. They import the Peugeot ‎and Citroen brands.‎
The company data must always be synchronized with the manufacturers' data; any ‎relevant changes in the importer’s system must be propagated to the manufacturers. ‎Previously, IT personnel used to manually upload the files through FTP twice a day. ‎The company wanted to automate this process to increase both the efficiency and the ‎frequency of uploads.‎
VRTech's BatchFTP enabled the company to send and receive files automatically, ‎directly from the iSeries legacy system. Product implementation was completed in a ‎few hours. Files that must be uploaded are copied to a dedicated folder, and BatchFTP ‎transfers them automatically to the requested destination. In parallel, BatchFTP ‎checks the remote sites for new files to be imported; if it finds such files, it transfers ‎them directly into the iSeries system.

In cooperation with
Dun & Bradstreet , VRTECH created the solution for checking the client’s ‎financial state directly from the iSeries emulation screen.‏
DB

The solution is based on ‎D&B’s CheckIt and VRTECH’s LinkIt products‎‏.‏
VRTECH’s LinkIt serves as the basis for fast and easy integration between the ‎emulation screen and a PC application. D&B’s CheckIt is a client application that ‎accesses the D&B Web service to check client’s financial state using the client's ID‏.‏

As a part of the order approval process, LinkIt submits the client ID to CheckIt, and a ‎few seconds later the financial status of the customer is displayed to the user, who ‎then decides whether to proceed with the order. This solution also includes real-time ‎alerts to the user.‎‏

Baccara implemented VRTech’s LinkIt to export subfiles to Excel ‎spreadsheets Baccara
Baccara is a leading manufacturer of such automation products as air valves, air ‎cylinders, solenoid valves, and nylon tubing for use in industry, agriculture, and ‎irrigation. Baccara’s legacy system is based on a AS/400 server working with 5250 ‎emulators.‎
One of the main user requirements was the ability to export subfiles to Excel ‎spreadsheets. This functionality was implemented based on the Export to Excel option ‎of VRTech’s LinkIt, which allows users to easily export data from subfiles to Excel ‎spreadsheets, and saves valuable IT personnel time.
Ledico using LinkIt to catalog and display the orders directly from the order form in the AS/400system bosch
Ledico Ltd. is an importer of professional work tools and the exclusive distributor of ‎Bosch in Israel. ‎
Most orders are placed by fax and converted to email messages using the Fax2Mail ‎system. Orders are printed or kept in a user inbox for future reference. Inboxes used to ‎be very large, which created serious system management problems.  ‎
The problem was solved with VRTech’s LinkIt: users export orders from Outlook ‎directly into the LinkIt archive. LinkIt automatically catalogs the orders by the order ‎number displayed in the order form on the emulation screen. LinkIt can display the ‎order directly from the order form in the iSeries system. All orders are saved in the ‎LinkIt archive so there is no need to save them in the user inbox.
Gestetner using MessageIt and Spool2Office for sending out to the customer, ‎by email or fax, a form listing all the printers and photocopiers rented by the ‎customer. Gestetner

Gestetner is one of the leaders in the sales and servicing of printers and photocopiers‎
One of the main business activities of the company is renting printers and ‎photocopiers. The machines are rented out on a monthly basis, and charges are ‎calculated based on usage. The invoice-generating process requires obtaining monthly ‎usage reports (counters) from the customers. The company sends out to the customer, ‎by email or fax, a form listing all the printers and photocopiers rented by the ‎customer. The customer fills out the counter readings of every machine and returns ‎the form to Gestetner‏.‏
Every month, company employees used to spend several working days sending out ‎thousands of lists by email or fax, using a semi-automated process ‎‏.‏‎ Gestetner ‎required a solution that would save sending time and also improve list design in a way ‎that would make using the form easier and encourage customers to complete the ‎forms‏.‏
The solution is based on VRTech’s MessageIt and Spool2Office. Spool2Office ‎converts the iSeries spool files to custom Word documents, and MessageIt sends them ‎to clients by fax or email. To reduce sending time, the applications were installed on ‎multiple servers that comprise several fax cards, so that the system can send several ‎faxes simultaneously‏ ‏‎ The solution enables Gestetner to send out the forms ‎
directly from the iSeries process, at considerable savings of work hours and human ‎resources.