Rocket wIntegrate and Rocket R/Link
Rocket® wIntegrate is a terminal emulator, file transfer, and application rejuvenation tool. Out-of-the-box, it provides users with flexible terminal emulation and file transfer capabilities to and from the MultiValue data host. The product has a powerful scripting language which enables developers to create client-side functionality, and to integrate their MultiValue applications with the Windows desktop – going as far as driving GUI interfaces indistinguishable from any other on the desktop.
wIntegrate has a reporting tool called the Query Builder. Intended for non-technical users, it lets you import MultiValue data to the PC by pointing-and-clicking to choose the required information, which can be filtered according to user privileges. So, you can import customer names, addresses and, for example, account data into a Microsoft Word mail merge. Importing to Excel is very popular too and charts can be generated automatically. Query Builder supports run-time prompting for selection criteria, and key words such as “LASTMONTH” for regular reports.
Sometimes users import data to spreadsheets for personal use, and simply open them automatically in Excel. At other times, reports may be generated for general use which need to be shared with others. Rocket® R/Link is ideal for this purpose. R/Link is a comprehensive, secure online file sharing and managed file transfer solution that resides on your network or private cloud. It replaces fragmented, unsecure FTP tools and public cloud file-sharing solutions.
The wIntegrate Query Builder can import MultiValue data to popular formats, such as Excel, shown here. Then the spreadsheet can automatically be sent to an R/Link folder.
The image above shows the sequence of events when importing host data to a spreadsheet, and sending it to R/Link. First the user specifies the host file, in this case the customer file WIN.CUST, the fields to be imported and any selection criteria. Then a new dialog box is shown to determine the destination file type and name, in this case an Excel spreadsheet. The “File Use” has been set to R/Link, and by pressing another button you’ll see a display via a dialog box with the R/Link parameters. At this point we show a popup dialog to let the user log in to the R/Link server. After that, all transfers to R/Link are automatic and seamless.
More technical users will be interested to learn that we implemented the R/Link support in scripting, like all other wIntegrate functionality. This allows complete flexibility in creating custom applications. In fact, the Query Builder itself is a script which you can customize if necessary.
So, developers can develop with R/Link relatively easily. As an example of what can be done with R/Link, we provide a sample script to link the local PC with the R/Link server, as per the image below. This makes it very easy to exchange files in either direction.
All functionality in wIntegrate is scripted. So the R/Link functionality was implemented as script functions. Here is a scripted dialog which gives an easy-to-use interface between the client PC and the R/Link server. If the dialog is dragged larger or smaller, the listboxes are automatically resized.
More importantly, this sample script can be adapted by developers into their own functionality and interfaces to create custom applications. For example, it could retrieve data from the MV host and send to R/Link. Or, the other way around, it could obtain data from R/Link to update the host. Or interact with other applications on the desktop using OLE Automation.
For more information on wIntegrate, visit the Rocket web site. And for more information on R/Link, please read an earlier blog post entitled Rocket R/Link – Why I think you’ll be interested or visit the Rocket web site.