• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • ProData’s Remote Database Access Tool Gains Automation

    October 16, 2007 Dan Burger

    There are several ways to access remote databases from the System i. They range from complex and expensive to simple and inexpensive. One of the least expensive and easiest to use methods has been developed by ProData Computer Services. Its Database Utility (DBU) is used by thousands of System i shops to access relational database systems, and earlier this year DBU Remote Database plug-in (DBU RDB) opened up cross-platform database access. This week ProData is releasing Remote Database Connect (RDB Connect), a new access avenue for RPG, COBOL, and CL programs.

    The difference between RDB Connect and DBU Remote plug-in is a higher level of automation with RDB Connect. DBU Remote, which became available in May, opened the door to accessing DB2/400, Microsoft SQL Server, Oracle, MySQL, and other databases and allowed users to examine those databases and edit them through ProData’s DBU, database utility interface. However, the process of attaining that data for real-time integration into current applications was not available. This new product gives developers full SQL access to remote databases from RPG, COBOL, or CL programs running on the System i. Using APIs to execute SQL queries, RDB Connect allows record-level I/O as well as the import/export of remote data and can be used in batch or interactive programs.

    An implementation of RDB Connect can contain one or more applications, a core RDB Connect library, and one or more database drivers. The library, which is independent of the applications and the remote database, acts as an “interpreter” between the applications and the database drivers, whereas the database drivers contain the remote database-specific details. Because of this design feature, programmers can write applications that use standard types and features without concern for the specifics of each remote database that the applications may encounter. Likewise, the database driver implementers only attach to the core library, which removes complexity as well.

    “RDB Connect drives our DBU Remote Database plug-in and many of our customers wanted that same remote database access integrated within their business applications,” said ProData owner and CEO, Allen Hartley. “RDB Connect allows our customers to easily share data across platforms within their programs, which can eliminate data transfers or duplicate data entry in some cases.”

    Wilson Jones, an IT consultant working for a 150-store pharmacy chain located in the Midwest, is using ProData’s DBU Remote tool to talk with four servers running SQL Server. Two of those servers are located in the same data center as the iSeries that is running DBU Remote, and two other servers are located in a data center approximately 35 miles away. The SQL Server databases are populated by pulling data from the retail stores in flat files.

    “We needed the tool to see what’s in the SQL databases,” Jones said. “The ‘400 still does not have a very good way to talk with remote SQL Servers. SQL works great on the ‘400 native, but when the ‘400 acts as a client, the process is not very good. There are tools available on the Windows side that do this sort of thing, but what I like about this tool [DBU Remote] is that it creates physical files on the ‘400 that hold the SQL table.”

    IBM‘s solution to this problem is a product called Generation Server. It’s a combination of hardware and software. It includes a blade server that the System i uses to connect with other databases.

    Jones describes DBU Remote as a manual interactive tool that lets you look at the SQL databases, analyze them, figure out what tables and views are available, and what’s in those tables and views. He says it allows him to select statements that pull all data or selected data. After deciding on a table or view, Jones and two other staffers use a combination of Java and RPG programs to automate the flow of selected data.

    “We access the SQL Server with DBU and connect to the server using an IP address, passwords, schema name, catalog server name, etc. Then DBU handles the connection. It displays the table and view. Then we pick what we want. It can use fields from those views. It can create files on the ‘400,” Jones said.

    This work has been going on since May. “We have a lot of stuff in production, but we are still using DBU every day to add new things to our applications,” Jones said.

    With ProData’s release of RDB Connect this week, users like Jones will have an automation tool that eliminates the need to code a program for every piece of information that’s necessary.

    “We are not changing any information on the SQL machines,” Jones said. “The SQL servers are used as a repository for the information. We pull it down on the ‘400. Some of it we keep in detail. Most of it we summarize and then the applications on the ‘400 present the data to the end users, who are the company executives. The information mostly relates to distribution analysis, payroll, and accounting.”

    The applications, which are running on the System i, show up on user screens after Jones and other IT staff create the predefined files. The end users import spreadsheets for their use. Jones says many of the users know how to pull data from the OS/400 files that is compatible with Acess, Excel, and other programs.

    ProData has set the price for RDB Connect at $2,495. It requires DBU 7.0, i5/OS V4R5 or greater, and an IP connection to the remote server. For more information, visit www.dodbu.com.

    RELATED STORIES

    ProData Goes Cross-Platform with DBU

    ProData Goes ‘On Demand’ with DBU

    ProData Now Supports Database Utility on Linux



                         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
    PERFSCAN

    Revolutionary Performance Management Software

    At Greymine, we recognize there is a void in the IT world for a dedicated performance management company and also for a performance management tool that’s modern, easy to use, and doesn’t cost an arm and a leg. That’s why we created PERFSCAN.

    PERFSCAN is designed to make your job easier. With revolutionary technology, an easy-to-read report and graphics engine, and real time monitoring, tasks that used to take days can now take minutes. This means you will know your system better and will be able to provide better service to your customers.

    OUR FEATURES

    PERFSCAN is full of robust features that don’t require you to take a three-day class in order to use the product effectively.

    Customizable Performance Reporting

    Whether you are troubleshooting a major system problem or simply creating a monthly report, PERFSCAN lets you select any combination of desired performance metrics (CPU, Disk, and Memory).

    User Defined Performance Guidelines

    No matter if you are a managed service provider managing complex systems in the cloud or a customer analyzing your on-premises solution, PERFSCAN gives you the flexibility to define all mission critical guidelines how they need to be.

    Understanding The Impact Of Change

    Tired of all the finger pointing when performance is suffering? PERFSCAN’s innovative What’s Changed and Period vs. Period analysis creates a culture of proof by correlating known environmental changes with system performance metrics.

    Comprehensive Executive Summary

    Creating performance graphs is easy. Understanding what they mean is another thing. With one mouse click, PERFSCAN includes an easy-to-understand executive summary for each core metric analyzed.

    Combined Real-Time Monitor And Performance Analysis Tool

    With PERFSCAN’s combined built in enterprise real-time monitor and historical performance analysis capability, you will always know how your mission-critical systems are performing.

    Cloud Performance Reporting Is Easy

    Managing performance for production systems in the cloud can be a black hole to many system administrators. The good news is PERFSCAN analyzes all core metrics regardless of the location. That’s why MSPs and customers love PERFSCAN.

    Detailed Job Analysis

    PERFSCAN shows detailed top job analysis for any desired period. All metrics are displayed in two ways: Traditional Report and Percentage Breakdown Pie Chart. This toggle capability instantly shows the jobs using the most system resources.

    Save Report Capability

    Your boss lost the report you gave to him on Friday. Now what do you do? With PERFSCAN’s save report capability, any report can be retrieved in a matter of seconds.

    Professional PDF Reporting With Branding

    Creating professional looking reports for your customers has never been easier with PERFSCAN. Branding for our partners and service provider customers is easy with PERFSCAN.

    Check it out at perfscan.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Computer Measurement Group:  CMG '07 International Conference, December 2-7, San Diego
    Clearview Software International:  Mobilize your work force with CostarMobile 2.0
    COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee

    IT Jungle Store Top Book Picks

    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 Developers' 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
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    Avnet Builds Out EMEA Business with ACAL, Magirus Acquisitions Controlling System i Shutdown Activities Using An Intelligent Power-Handling Program, Part II

    Leave a Reply Cancel reply

Volume 7, Number 39 -- October 16, 2007
THIS ISSUE SPONSORED BY:

Aldon
Quadrant Software
Profound Logic Software
SafeData
Affirmative Computer

Table of Contents

  • CYBRA Teams with Solzon to Develop i5/OS RFID Software
  • ProData’s Remote Database Access Tool Gains Automation
  • Real Vision Software Delivers RVI 8.0
  • Vision Tackles i5/OS Application Performance with Director 7.0
  • BOSaNOVA Joins PCI Security Group
  • Kisco’s WebReport/400 Now Converts Spool Files to XLS
  • First Option Chooses Invision to Host System i Hosting Business
  • Solimar Streamlines Output Management for Xerox Printers
  • Ricoh Debuts New Multifunction Color Laser Printer
  • Gas Barbeque Distributor Upgrades its Infor ERP

Content archive

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

Recent Posts

  • Fortra Issues 20th State of IBM i Security Report
  • FNTS Launches Managed Services for Power Servers in IBM Cloud
  • Total LTO Shipped Capacity Up Slightly in 2022
  • Four Hundred Monitor, May 24
  • Update On Critical Security Vulnerability In PowerVM
  • Critical Security Vulnerability In PowerVM Hypervisor
  • IBM Power: Hosted On-Premises Or In The Cloud?
  • Guru: Watch Out For This Pitfall When Working With Integer Columns
  • As I See It: Bob-the-Bot
  • IBM i PTF Guide, Volume 25, Number 21

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 © 2023 IT Jungle