• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Krengel Goes GA with New DB2/400 Integration Tool

    June 8, 2010 Alex Woodie

    Krengel Technology last month announced the general availability (GA) of DB2 Web Services Enabler (DB2WSE), a new product that makes it easier to integrate DB2/400 data with applications written in Java, PHP, or .NET. The product, which utilizes XML and SQL technology, is basically a replacement for JDBC and ODBC, the vendor says.

    Madison Lake, Minnesota-based Krengel Tech first unveiled DB2WSE back in October 2009 as a way to simplify access to DB2/400 data from Java, PHP, and .NET programs running on Windows, Unix, and Linux operating systems. Testing for the software apparently took a little longer than expected, and it only became available in mid-May.

    The new DB2WSE product is composed of an RPG service program that runs on the System i server, and a client component that installs next to the open systems program on the Windows, Unix, or Linux server. At runtime, the DB2WSE client component submits a Web service request for a SELECT, UPDATE, DELETE, or INSERT transaction, the RPG component executes the request against DB2/400, and the data is returned as XML. While XML and Web service technology is used, it exists “under the covers” and is nearly invisible to the users.

    Instead of programming on the System i server, DB2WSE customers do their programming on the client side using the APIs that Krengel provides. This eliminates the need for RPG expertise to get to DB2/400 data, and maintains security on the System i.

    This approach also reduces the likelihood that open system programmers or administrators devise other ways to get at the critical DB2/400 data, such as replicating the entire database to an X64-based database. Because once that happens, it’s a short leap to eliminating the i/OS layer completely.

    Krengel envisions a number of practical uses for DB2WSE, such as generating purchase orders and invoices; handling product or warranty data; managing accounts receivable or accounts payable data; or even handling credit card data.

    DB2WSE can also be used as a database-focused companion to RPG-XML Suite, a collection of tools for developing XML-based Web services in RPG. While DB2WSE functions as a replacement for ODBC or JDBC and eliminates the need for RPG expertise, RPG-XML provides a direct approach to help System i shops create Web services using their existing RPG business logic.

    Pricing for DB2WSE is tier- and LPAR-based, and ranges from $2,995 to $5,995. For more information, see the company’s Web site at www.krengeltech.com.

    RELATED STORY

    Krengel Tech Eases XML Integration with DB2 Web Service Enabler



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Computer Keyes

    Fax Directly from your IBM i

    KeyesFax is a full function automated IBM i fax system. Spooled files are burst by fax number and auto transmitted with overlays.  It combines both a send and receive facsimile processing system with a complete image package.

    The fax software will edit, send, receive, display, print, and track fax documents or images using any standard IBM i without additional expensive hardware, software or subscriptions.

    Computer Keyes has been developing Software Solutions since 1978!

    www.computerkeyes.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Help/Systems:  Use Robot/SPACE for your IBM i disk storage management
    ManageEngine:  Who says iSeries systems monitoring software has to be expensive?
    COMMON:  Join us at the Fall 2010 Conference & Expo, Oct. 4 - 6, in San Antonio, Texas

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    Chip Wars: List Price, $29.95

    Modern i Platform Relies on Skills as Much as Technology Re-Adopt Authority Utility

    Leave a Reply Cancel reply

Volume 10, Number 21 -- June 8, 2010
THIS ISSUE SPONSORED BY:

looksoftware
Bytware
Maxava
Computer Keyes
VAULT400

Table of Contents

  • iBoost Turbo-Charges Slow i/OS Batch Jobs
  • Vision Updates CDP Tool with Automated Recovery Feature
  • ARCAD Opens ALM Suite a Little More
  • Bug Busters Bolsters HA Offering
  • LANSA Refreshes Data Services Layer for i/OS and .NET
  • IPDS Emulator from Brooks Now Generates Searchable PDFs
  • Krengel Goes GA with New DB2/400 Integration Tool
  • Aldon Widens Reach of Report Manager
  • Hospital Taps CCSS for i/OS Monitoring Expertise
  • Kronos Touts iSeries Central Customer

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle