04
Mon, Nov
6 New Articles

Overcoming the Challenges of Mixed RPG and .NET Development

General
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

Can Windows and IBM i live in application development harmony?

 

Editor's note: This article is an extract from the white paper titled "Using Microsoft .NET to Build Scalable Enterprise IBM i Applications" available free at the MC Press White Paper Center.

 

Over the last decade, we've watched Microsoft technology shift from running on the fringe of our IBM i enterprise to being intertwined, creating a ripple effect across what we need to integrate with, synchronize with, and monitor on a daily business. As the number of companies running both IBM i and Microsoft hardware continues to grow, so does the number of IT shops struggling to integrate these disparate platforms. In a world of synchronized data, data conflicts and unprotected access to DB2 from Windows applications can make us feel like we are losing control.

 

This situation prompted Mike Otey to write a white paper titled "Using Microsoft .NET to Build Scalable Enterprise IBM i Applications." It addresses how to maximize the integration of Microsoft and IBM i to provide you with the choice and flexibility you need to achieve the best of both worlds. The white paper's guidelines can help to ensure that your IBM i .NET applications meet the scalability, adaptability, and security requirements of your enterprise. The report is divided into three parts:

 

  • Part 1 discusses the business benefits that .NET can bring to your organization.
  • Part 2 focuses on the requirements for developing and running .NET applications connected to the IBM i.
  • Part 3 concentrates on the most critical enterprise-level development issues faced by IBM i .NET applications. It also covers some of the most important issues that you need to address when designing production applications that must scale to support hundreds of users across multiple locations and devices.

 

The remainder of this article contains snippets from Mike Otey's white paper, which can be downloaded here.

Benefits of .NET for the IBM i

Microsoft .NET provides a way to modernize IBM i applications by creating graphical Windows and Web-based applications that integrate with data on the IBM i. In addition, .NET applications can be used as a tool to connect third-party applications, Microsoft server platforms, and Microsoft Office to the data stored on IBM i. While .NET isn't the mainstream development option for the IBM i, it is growing in popularity, particularly for Web applications. Some of the advantages for using .NET as an IBM i development platform include the following:

 

.NET vs. Java

 

.NET is not the only graphical development option for IBM i applications. When your organization is evaluating modernization technology, the choice often comes down to .NET vs. Java. IBM has traditionally favored Java over .NET. Even though Java and .NET have a number of similarities, they also possess some major differences. Both Java and .NET are object-oriented languages. Java and the .NET C# language in particular were both essentially derived from C/C++. Both have hierarchical namespaces or class libraries and provide automatic garbage collection. In addition, both platforms require a host runtime component in order to run applications.

 

Real-World Production Application Issues

 

Getting the initial building blocks in place and connecting your .NET applications to the IBM i are certainly essential elements in the process of building IBM i .NET applications. However, the initial connection and database access is just the starting point. Enterprise-level application development requires attention to real-world application development issues, like scalability, data integrity, integration, team development, and security. In this section of the white paper, you'll get some hard-to-find architectural guidance and recommended best practices for building enterprise-level IBM i .NET applications.

 

Data Integrity

 

Another vital issue for enterprise applications is the accuracy and integrity of corporate data. Whether it's used to generate management reports or to populate a data warehouse for business analytics, enterprise data is the basis for management's decision-making process. Inaccurate data can render these reports ineffective, or, even worse, it can lead to bad managerial decisions. Guarding against data corruption from .NET applications is much more important than it is for native IBM i applications because the legacy 5250 programs already contain all the enterprise business logic and validation rules. If your IBM i .NET applications generate bad data and corrupt DB2 data on the IBM i, the application won't be trusted by either end users or management. This can lead to the application being abandoned or replaced. In some cases, it can also result in the termination of the personnel involved if there are adverse effects on the organization's ability to do business.

 

Security

 

Security is another essential design consideration when developing IBM i .NET applications. Most IBM i applications utilize menu-level security where code in the application governs the access rights for different types of users within the same application. It's important to realize that .NET data access mechanisms like ADO.NET and the .NET Data Provider will not be governed by the same menu-level restrictions that controlled end user security within your 5250-based applications. However, don't infer that .NET access to the IBM i is insecure; .NET access is controlled by native IBM i object-level security instead of menu-level security. This fundamental difference underscores the importance of planning and implementing your IBM i object-level security.

 

Siloed Development Teams

 

Another enterprise application development issue facing IBM i organizations today is managing siloed development teams. Many organizations with an IBM i have two sets of developers: one team dedicated to IBM i and another for Windows. The personnel comprising each respective team are typically very knowledgeable about the platform they work on every day. However, by the same token, they typically have very little knowledge about the other platform. This disparity becomes problematic when organizations embark on developing IBM i .NET applications. Typically, the .NET development team is tasked with developing all the Windows applications, which makes sense to management because that group has the best expertise in developing on that platform. However, problems will arise because the vast majority of .NET developers don't understand the IBM i. The IBM i is a sophisticated and unique computing platform that has many features and attributes that are not known to Windows developers.

 

Complete Platform Integration

 

Today, most IBM i .NET applications use a SQL-based .NET Data Provider to integrate with the IBM i database. The IBM .NET Data Provider provides your.NET applications with seamless IBM i database integration for reading, inserting, updating, and deleting data from the IBM i's relational database. Remember, database access is only one aspect of platform integration. Real-world production IBM i applications almost always require native platform access to features like CL commands and programs, RPG programs, i5/OS APIs, data queues, data areas, the IFS, spool files, job queues, and output queues.

 

Find out more by downloading the free white paper titled "Using Microsoft .NET to Build Scalable Enterprise IBM i Applications" from the MC Press White Paper Center.

 

David Brault
As Product Manager at LANSA, David Brault draws on his knowledge of IBM i (System i, iSeries, AS/400) technology to help determine the market message for LANSA's products. David has over 15 years of experience in the IBM i industry, including extensive involvement integrating IBM i applications with various Windows, Web, and wireless technologies. He is currently responsible for launching new LANSA products and serving as the U.S. product line expert for press and analyst briefings. David is a member of the COMMON Americas Advisory Council (CAAC) and a frequent speaker at COMMON and other industry events.

 

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: