• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Fresche Preps IBM i Customers for SQL Migrations

    May 20, 2014 Alex Woodie

    With its acquisition of Databorough and its highly regarded X-Analysis product last year, Fresche Legacy made it clear it viewed database modernization as a key component of its overall strategy. Now, by making a key database migration feature of X-Analysis available to a greater number of users, the company clearly is setting its IBM i customers on a SQL path.

    The big news coming out of Fresche Legacy during the COMMON conference two weeks ago was the availability of the Automated Data Model extraction feature in X-Analysis Professional Edition. Previously, this feature–which is a critical first step in the process of modernizing RPG and COBOL code to use SQL DDLs instead of traditional DDS–was only available to users of X-Analysis Enterprise Edition.

    It’s a small but meaningful change on the part of Fresche Legacy, which has come out strong in support of SQL database tools and techniques in the IBM i installed base. Professional Edition customers can get the Automated Data Model extraction feature as a free upgrade, thereby giving them a key modernization feature, according to Fresche’s vice president of corporate strategy Chris Koppe.

    “After surveying the IBM i market and our customers, it is clear that to really take advantage of IBM i’s newest database and SQL features, documenting the relational data model is a critical requirement,” Koppe states in a press release.

    Fresche Legacy jumped squarely onto the SQL-on-IBM i bandwagon in March, when it shipped a new release of X-Analysis that automated more of the DB2 for i modernization process. Specifically, X-Analysis version 10 automated the process of generating DDL from DDS code, in addition to other features that are useful during a migration, such as more fine-grained rules extraction capabilities.

    “IBM i developers find that the manual work effort required to achieve this has proven overwhelming,” Koppe continues. “As a demonstration of Fresche’s commitment to the sustainability of IBM i and commitment to improving productivity for developers, we made the strategic decision to include the automated data model extraction functionality in the X-Analysis entry-level version.”

    Fresche Legacy is also upping its targeting users of the Hawkeye Information Systems‘ cross-referencing and impact-analysis tool, called Pathfinder. The company says it’s noticed that Hawkeye customers have displayed “an urgent need for a modern graphical interface for application analysis and cross-referencing capabilities.” To that end, “Fresche is making X-Analysis available to Hawkeye users through a free upgrade,” the company says.

    X-Analysis was launched by Databorough in 1989 as a cross-referencing tool for RPG coders. Over the years, Databorough expanded the product with business rule extraction, Java generation, and code migration capabilities. Today, X-Analysis contains hundreds of internal analytical tables and many hundreds of static analysis and re-engineering programs. For more info see www.freschlegacy.com.

    RELATED STORIES

    Fresche Legacy Automates DDS to DDL Conversions

    Fresche Legacy Discusses Three IBM i Modernization Cases

    Fresche Legacy Debuts with Newly Acquired Code Converter for IBM i

    Speedware Says RPG-to-.NET Code Converter Is the Real Deal



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

    Do you need area code information?
    Do you need ZIP Code information?
    Do you need ZIP+4 information?
    Do you need city name information?
    Do you need county information?
    Do you need a nearest dealer locator system?

    We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

    The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

    PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

    Just call us and we’ll arrange for 30 days FREE use of either ZIP/CITY or PER/ZIP4.

    WorksRight Software, Inc.
    Phone: 601-856-8337
    Fax: 601-856-9432
    Email: software@worksright.com
    Website: www.worksright.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    BCD:  June 5 Webinar: RPG Open Access in Presto Gives You More Modernization Options
    LANSA:  Webinar: Mobile and the IBM i: Why Should You Care? May 21, 9 am PT/11 am CT/Noon ET
    RJS Software Systems:  Webinar: Learn how WebForms can save time and money. May 27.

    More IT Jungle Resources:

    System i PTF Guide: Weekly PTF Updates
    IBM i Events Calendar: National Conferences, Local Events, and Webinars
    Breaking News: News Hot Off The Press
    TPM @ EnterpriseTech: High Performance Computing Industry News From ITJ EIC Timothy Prickett Morgan

    Reader Feedback On Power8 Processing Power And What Matters Lining Up Power7+ Versus Power8 Machines With IBM i

    Leave a Reply Cancel reply

Volume 14, Number 11 -- May 20, 2014
THIS ISSUE SPONSORED BY:

ProData Computer Services
Fresche Legacy
HiT Software
Manta Technologies
Shield Advanced Solutions

Table of Contents

  • Profound UI 5 Expands What i Can Do
  • Robot Simplifies Setup of IBM i Message Monitor
  • Logicalis Touts Cloud as IBM i Skill-Replacement Solution
  • Linoma Adds Single Sign-On to MFT Offering
  • Surround Tech Revs Windows-Based Dev Tool for IBM i
  • IBM Cranks Up Storwize V7000 Capacity to 4 PB
  • Fresche Preps IBM i Customers for SQL Migrations
  • iFD Goes Mobile with iSign Signature Capture
  • ARCAD Integrates Source Code Management in RTC
  • Pivot Tables Now Supported in SEQUEL Web Interface

Content archive

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

Recent Posts

  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24
  • Big Blue Raises IBM i License Transfer Fees, Other Prices
  • Keep The IBM i Youth Movement Going With More Training, Better Tools
  • Remain Begins Migrating DevOps Tools To VS Code
  • IBM Readies LTO-10 Tape Drives And Libraries
  • IBM i PTF Guide, Volume 27, Number 23

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