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.

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

Tags:

CYBER-ATTACKS ON THE RISE. PROTECT WITH THE TRIPLE PLAY.

COVID-19 has not only caused a global pandemic, but has sparked a “cyber pandemic” as well.

“Cybersecurity experts predict that in 2021, there will be a cyber-attack incident every 11 seconds. This is nearly twice what it was in 2019 (every 19 seconds), and four times the rate five years ago (every 40 seconds in 2016). It is expected that cybercrime will cost the global economy $6.1 trillion annually, making it the third-largest economy in the world, right behind those of the United States and China.”¹

Protecting an organization’s data is not a single-faceted approach, and companies need to do everything they can to both proactively prevent an attempted attack and reactively respond to a successful attack.

UCG Technologies’ VAULT400 subscription defends IBM i and Intel systems against cyber-attacks through comprehensive protection with the Triple Play Protection – Cloud Backup, DRaaS, & Enterprise Cybersecurity Training.

Cyber-attacks become more sophisticated every day. The dramatic rise of the remote workforce has accelerated this trend as cyber criminals aggressively target company employees with online social engineering attacks. It is crucial that employees have proper training on what NOT to click on. Cyber threats and social engineering are constantly evolving and UCG’s Enterprise Cybersecurity Training (powered by KnowBe4) is designed to educate employees on the current cutting-edge cyber-attacks and how to reduce and eliminate them.

A company is only as strong as its weakest link and prevention is just part of the story. Organizations need to have a quick response and actionable plan to implement should their data become compromised. This is the role of cloud backup and disaster-recovery-as-a-service (DRaaS).

Data is a company’s most valuable asset. UCG’s VAULT400 Cloud Backup provides 256-bit encrypted backups to two (2) remote locations for safe retrieval should a cyber-attack occur. This is a necessary component of any protection strategy. Whether a single click on a malicious link brings down the Windows environment or an infected SQL server feeds the IBM i, once the data is compromised, there is no going back unless you have your data readily available.

Recovery is not a trivial task, especially when you factor in the time sensitive nature of restoring from an active attack. This leads to the third play of the Triple Play Protection – DRaaS. Companies have myriad concerns once an attack is realized and a managed service disaster recovery allows employees to keep focus on running the business in a crisis state.

The combination of training employees with secure backup and disaster recovery offers companies the best chance at avoiding financial disruption in an age of stronger, more frequent cyber-attacks.

Reach out to UCG Technologies to discuss your company’s security needs and develop a data protection plan that fits you best.

ucgtechnologies.com/triple-play

800.211.8798 | info@ucgtechnologies.com

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

Table of Contents

Content archive

Recent Posts

Subscribe

Pages

Search