• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • ProData Goes Cross-Platform with DBU

    May 22, 2007 Alex Woodie

    ProData Computer Services has released a version of its Database Utility (DBU) that can access other relational database management systems in addition to DB2/400. With the new capability, available from ProData as a plug-in called DBU Remote Database (RDB), System i programmers can now get the same high-powered, real-time access to SQL Server, DB2 UDB, Oracle, MySQL, and other database as DBU customers have realized when accessing DB2/400.

    DBU is a popular and handy utility that makes it easy for programmers, administrators, and users to view and access any file in DB2/400, without programming. The software, which was designed as a replacement for IBM‘s native DB2/400 utility, called Data File Utility (DFU), has proved useful when programmers really need to get very low-level access to database records, such as during a server emergency or when testing a new application. With more than 20,000 licenses sold over the years, the product has a solid and proven track record.

    With DBU RDB, ProData is now giving DBU users the deep level of access to other databases using a tool they’re familiar with, as opposed to forcing them to learn to use another tool. Users can even access other databases from the green-screen interface, in addition to using DBU’s Java-based GUI.

    Users can do practically everything they can do with DBU on DB2/400 with DBU RDB on Oracle, MySQL, SQL Server, and DB2 UDB. Not only does this mean viewing, adding, changing, or deleting data, but a number of other capabilities, including performing mass replaces or deletes, exporting data en masse, creating DBU applications and customizing function keys, support for Boolean logic, a number of field-level controls, audit tracking (via the DBU Audit plug-in), and a full array of print options.

    ProData says it’s easy to connect to other databases using DBU RDB, which uses the same connection settings for accessing i5/OS servers with DBU. Once users have entered information such as the remote server’s IP address, the port number, schema, user name, and password, the information is encrypted with a 256-bit key stored as an object on the System i.

    Once it’s setup, when users want to access the remote database, all they do is issue the RDB command, and they are connected to the last database table they were connected to in their 5250 session. To change database tables, users simply enter the new table name.

    DBU RDB is a powerful tool, and ProData has designed it to respect security. From the System i perspective, the software supports i5/OS object-level security, enabling security administrators to provide fine-grained access control. When connecting to remote servers, DBU RDB users cannot access any databases that they haven’t been provided access to; authority must be granted from the database’s native console, not DBU RDB. The software respects all access authorities for remote systems.

    ProData owner and CEO, Allen Hartley, says the software will be well-received by DBU users. “Our customers have been asking for one tool/one interface to access all their data in their shops for the past several years,” Hartley says. “DBU RDB allows our customers simple setup and the use of one database tool across multiple platforms to access their data. With DBU RDB, they no longer have to learn other tools to access remote information.”

    DBU RDB requires DBU 7.0, i5/OS V4R5 or greater, and an IP connection to the remote server. A license to use DBU RDB across an unlimited number of databases and an unlimited number of users costs $1,995. For more information, visit www.dodbu.com.

    RELATED STORIES

    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
    ARCAD Software

    Join us for a webinar on August 25, 2022, with a presentation on how Git uses concurrent development and how it can scale to fit your development needs. You’ve heard mention of Git and now it’s time to answer the question. What is Git and Why? This should be a very informative and interesting webinar that could relate to you!

    Register Here

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    COMMON:  Join us at the Annual 2008 conference, March 30 - April 3, in Nashville, Tennessee Help/Systems:  SEQUEL is the single solution for all your business intelligence needs
    Quadrant Software:  Become more efficient, productive & profitable with paperless accounts payable

    IT Jungle Store Top Book Picks

    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

    Developer Population to Grow to Nearly 19 Million by 2010 Send a Spool File from AS/400 with a Specific Subject Line and Message Body

    Leave a Reply Cancel reply

Volume 7, Number 20 -- May 22, 2007
THIS ISSUE SPONSORED BY:

Vision Solutions
Bytware
SafeData
LaserVault
Affirmative Computer

Table of Contents

  • Rochester Alums Plan New Customer Care App for i
  • Lakeview Touts Customer Win at Competitor’s Expense
  • HarrisData Serves Competitive Party Goods Maker for 14 years
  • ProData Goes Cross-Platform with DBU
  • CollabNet Snags Former SoftLanding Development Director
  • Raz-Lee Updates iSecurity Suite
  • SoftTree Adds MySQL Support to Data Audit Tool
  • Info Builders Sees Strong Mid-Market Growth
  • Elite Adds Card Payment Processing Option
  • IBM: SOA Fits Skills Shortage to a ‘T’

Content archive

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

Recent Posts

  • JD Edwards Customers Face Support Decisions
  • Security, Automation, and Cloud Top Midrange IT Priorities, Study Says
  • Cleo and SrinSoft in Integration-Modernization Link Up
  • Four Hundred Monitor, August 3
  • IBM i PTF Guide, Volume 24, Number 31
  • Power10 Entry Machines: The Power S1022 And Power L1022
  • Highly Secure API Enablement for IBM i
  • Guru: IBM i Privileged Account Management, And What’s So Special About Special Authorities
  • IBM Finally Shows Some Growth In Sales And Profits
  • Altair Delivers More Options for Running SAS Code

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

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.