|
|||||||
|
|
![]() |
|
|
RPG Writes to PC Databases with RJS's RPG2SQL Integrator by Joe Hertvik Many companies face a skill disconnect when importing OS/400 data to other systems. Their skill set lies in RPG and COBOL programming, but to exchange data with other systems they need to write special PC applications, use file transfer software, or use replication packages. So RJS Software Systems has developed a new product called RPG2SQL Integrator, which allows RPG and COBOL programs to directly communicate with PC databases, including Oracle, Microsoft SQL Server, Microsoft Access, Microsoft Excel, MySQL, and dBase. RPG2SQL Integrator uses an ILE service program and a Windows middleware server to integrate OS/400 data with non-OS/400 databases. Once installed, RPG and COBOL programs can open, read, and write to PC database files via SQL. The information is transmitted over TCP/IP to the package's server component, which handles the interface between OS/400 and any PC database that can be accessed through ADO or ODBC device drivers. RPG2SQL Integrator allows OS/400 programmers to run SELECT, INSERT, UPDATE, and DELETE operations against PC data without ever leaving their RPG or COBOL programs. Information can be read or modified on a record-by-record basis, and fields can be exchanged as text strings, in standard date formats, or as numeric fields. Returned information is buffered to improve performance. Special features even allow programs to export OS/400 data into named areas inside an Excel spreadsheet. And because you're working in native RPG and COBOL on the OS/400 side, data exchanges can be run interactively or put into batch job streams that can be kicked off automatically by the OS/400 job scheduler. Richard Schoen, president of RJS Software Systems, says the beauty of RPG2SQL Integrator is that, because the OS/400-to-PC interface is generated at runtime, table changes don't necessarily force RPG2SQL Interface users to recompile their code. The software can also help to alleviate OS/400 security concerns because access is provided within your native OS/400 environment, rather than allowing PC programs to upload and download information from a network. RPG2SQL Integrator is generally available, and has already been implemented at Grocery Outlet, a Berkeley, California, based chain of 117 discount grocery stores across the western United States. Every day, Grocery Outlet generates more than 450,000 sales transactions, which are stored on a sales loss and prevention system running on a Windows NT/2000 platform with the SQL Server database. The chain needed a way to upload the SQL Server-based sales loss and prevention information to its sales and accounting system, which was written in RPG and runs on the OS/400 platform. The company had already developed inquiry and report programs for the OS/400 platform, and didn't want to rewrite them, so it turned to RPG2SQL Integrator to suck the SQL Server data into the OS/400 platform. The company has created two RPG applications that use RJS Software Systems' middleware to access the SQL Server data, and Steve Tuscher, Grocery Outlet's IT director, expects to develop more. "I see RPG2SQL Integrator extending the functionality of the iSeries," Tuscher says. The software "allows us to get back to concentrating on what needs to get done, instead of endlessly discussing hardware and software platforms." RPG2SQL Integrator requires OS/400 V4R2 or later, with an ILE RPG or COBOL compiler installed. The PC server component requires a Windows NT/2000/XP server. For more information, go to www.rjssoftware.com.
|
Editor
Contact the Editors |
| Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved. |