Alpha Anywhere: Keeping the Front and Back Ends Coordinated

Development Tools / Utilities
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

Coordinating actions between the front-end of an app running on a mobile device and the back-end server or cloud that supports it can be tricky. Alpha Software's Alpha Anywhere mobile development and deployment platform builds all that in.

Written by John Ghrist

Some of the complexity of building mobile applications is because the task doesn't just involve building the functional application itself. There are also numerous supporting features to take into account, such as offline operation and data synchronization, resolving write conflicts to server databases, generating reports, security, and other factors.

Alpha Software describes its Alpha Anywhere as a "rapid application development platform for building and deploying mobile, web, and desktop business applications." It includes an extensive feature set that includes an application server, data integration, offline support with synchronization, cross-platform and cross-device support, a report writer, role-based security, and user interfaces that can include touch screens, signature capture, audio, video, and image annotations.

Even more importantly, Alpha Anywhere addresses both the front-end concerns of the mobile devices on which apps run and the back-end concerns having to do with the servers on which databases and other supporting business systems reside. For example, if an app potentially includes access to confidential information that only authorized users should see, Alpha Anywhere apps know on the back-end that this data should be omitted from any display, and the front-end part knows that it should hide where that information could potentially be displayed within the user interface. And Alpha Anywhere does it all by letting the developer simply check a box.

Developing Basic Apps

Alpha Anywhere uses an Action Scripting feature that lets developers build applications by making menu selections from a large list of potential features common to most mobile apps. Each feature on the list is connected to code that's already been tested and optimized. By making selections, developers assemble building blocks of a mobile application and use various other tools to customize appearance and function. If custom modifications not covered by the prebuilt features list are needed, these can be added using the developer's choice of Xbasic, JavaScript, Curl, HTML5, or Microsoft .NET. Built in are connectors for common back-end systems and SQL databases.

Because Alpha Anywhere builds HTML5 and JavaScript apps, those apps can run on nearly any device that supports a web browser, including smartphones, tablets, and both PC and Mac laptops and desktops. Developers can also build HTML5 or hybrid apps that can responsively adapt to screen sizes varying from four inches to four feet. Alpha Anywhere also makes it possible to create an HTML5 version of apps with a single click by integrating its Adobe PhoneGap Build service, which assembles PhoneGap apps in the cloud from HTML5 and standardized native code. This potentially adds such benefits as accessing hardware features like barcode scanners, local storage, device cameras, and contact lists.

Letting Apps Access Databases

Using mobile apps is a two-way street between users and back-end servers. To that end, Alpha Anywhere includes a build-in system for developing electronic forms that help users on the front-end enter information that can be fed directly to order systems, databases, and other apps. Also, unlike apps on desktops, key selections are emulated, so programmers can include, for example, simulated keys that contain only characters valid for confirming certain data (e.g., numbered keys for entering phone numbers) to minimize incorrect data entry.

Alpha Anywhere apps can perform create, read, update, and delete (CRUD) operations from nearly any data source, including SQL databases, NoSQL databases, and web services. Alpha Anywhere integrates native drivers for a wide range of major database back-ends, including Microsoft SQL server, Access, Excel, MySQL, Oracle, DB2, and other databases for which there is an ODBC driver.

Alpha Anywhere includes SQL Genie, which automatically generates all code for CRUD operations. Developers can also edit SQL statements directly or otherwise alter server-side code in Xbasic, C#, JavaScript, VB.NET, or any other language that supports the .NET framework. Using dynamic link libraries (DLLs), OLE/ActiveX, .NET, or web services, programmers can also execute standalone programs, load DLLs and execute their functions, connect to various databases, load and execute .NET assemblies, connect to TCP/IP sockets, and access and execute web services.

On the back-end, the Alpha Anywhere Standard Application Server handles HTTP and HTTPS requests from client browsers and servers. The server handles AJAX callbacks, translates pages and components for execution in the client's browser, and services other types of content that's stored in the server's file system (e.g., XML, JSON, multimedia) and may be required by an app.

Alpha Anywhere lets developers include touch-screen features, even for devices that don't support touch screens. Instead, Alpha Anywhere uses what's termed “abstract events,” which are events triggered by a touch event on a touch-enabled screen, or alternatively, a mouse on a desktop browser or a pointer on a pointer-enabled screen. As an alternative to the HTML5 OnClick event, abstract events can save up to 200ms per click on touch devices, improving user perception of performance. Also supported are rich user interfaces for all kinds of apps, which can include maps, charts, gauges, and special controls.

Extensive Report-Writing Features

Reports are an integral part of most applications. The Alpha Anywhere Report Writer is a banded report writer (i.e., one that uses table components with multiple, aggregated levels of detail. There's some debate about the efficacy of these for reporting on large data sets that we won't go into here), which is similar to Crystal Reports and is included with the development platform. The built-in Alpha Anywhere Quick Report Genie lets developers specify each report's overall structure and style, customize field and group labels, and adjust fonts with a few clicks.

The report-writing tools enable development of full-featured business reports that include grouping, calculations, summaries, and images, as well as the ability to optimize the reports for any device or platform. Users can jump directly to report sections of interest via bookmarks or links to each report's table of contents, with options at each point to drill down further into the supporting data. With a single button click, users can display reports as HTML, PDF, or both. In addition, users can export report data directly to Microsoft Excel, Word, or an ASCII file with the full structure of a report definition.

The performance of the report-writing features is augmented by the Alpha Anywhere Report Server, which can parcel out report-generating tasks to separate processes on different cores. This feature supports handling multiple report requests concurrently without bogging down server performance. The reporting tools also include charting options (e.g., bar, 3D, donut, hi-lo, box, spline, line, pie, scatter) that can function as visual components to reports or be used to support development of dashboards. The charting capabilities let users plot multiple data series on a single chart, mix chart types, activate server or client events based on user interactions, and dynamically display additional information based on user events. Reports can also include grouping, summaries, and images, all optimized for smartphones and tablets.

Finally, the report writing tools include the Google Visualization API, which lets developers set up creation of charts, gauges, and other visual elements by simply checking boxes to load the appropriate code.

What About Security?

Alpha Anywhere includes role-based security, encryption functions, and Secure Sockets Layer and Hash-based Message Authentication Code support. It also can use the security features of IIS and the .NET framework. Administrators can use the application server to track users, groups, and page accesses. Only users with correct permissions can update and modify data as their access is managed via field-level access controls.

Alpha Anywhere's security system tests every page and file request, eliminating the need to incorporate custom security controls. An inherent login/logout component works with integrated app security systems to handle new user registration and automates resetting lost passwords. It lets administrators hide controls when no one is logged in, set rules for login names, set expirations for logins, log all user activity, display warning dialog if sessions are about to expire due to inactivity, specify message templates, and similar functions.

Alpha Anywhere is also integrated with Apperian, the mobile app management platform and app store. Using app wrapping via Apperian, developers can provide additional security and policy controls without coding them. These controls potentially include corporate authentications, app-level VPNs, copy/paste protection, root protection, and crash log reporting. The controls also include data-at-rest encryption, which is encryption for inactive data stored physically in digital form (e.g., databases, archives, mobile devices).

Solving Offline Data Problems

One significant group of pitfalls for mobile apps is what happens when the mobile device, for whatever reason, has been offline for some period of time. Alpha Anywhere includes customizable capabilities for building offline HTML5 and web business apps. These capabilities can let developers control write conflicts in offline mode, let data (including data not backed up to the server) persist on the mobile device when the app is closed or the device battery fails, support conversion of SQL data into hierarchical JSON datasets, store and display transaction details (including changes and updates), and synchronize stored transactions between offline web apps and server apps. In addition, Anywhere-generated apps can incrementally download updated data from the server, better control long synchronization operations, and cache offline data.

When an offline synchronization occurs, if a write conflict happens because multiple users are trying to modify the same data, updates are suspended, notifications are sent to appropriate personnel to resolve the conflict, and the disputed updates are color-coded for easy diagnosis. Controls also exist for resolving synchronization errors based on server-side validation rules, setting rules for synchronizing list data, and dividing large updates into batches for better management of synchronization events between clients and servers.

And More…

Finally, Alpha Anywhere apps can integrate images and videos, provide access to Google Maps and GPS information, and incorporate calendars, scheduling controls, and date-picking capabilities if those are needed.

With its low-code app development, close coordination between front and back ends, granular data controls, extensive security options, and wide-ranging additional capabilities, Alpha Anywhere deserves consideration if your enterprise is looking for a platform for developing new mobile apps.


John Ghrist

John Ghrist has been a journalist, programmer, and systems manager in the computer industry since 1982. He has covered the market for IBM i servers and their predecessor platforms for more than a quarter century and has attended more than 25 COMMON conferences. A former editor-in-chief with Defense Computing and a senior editor with SystemiNEWS, John has written and edited hundreds of articles and blogs for more than a dozen print and electronic publications. You can reach him at

More Articles By This Author
Related Articles


Support MC Press Online





  • White Paper: Node.js for Enterprise IBM i Modernization

    SB Profound WP 5539

    If your business is thinking about modernizing your legacy IBM i (also known as AS/400 or iSeries) applications, you will want to read this white paper first!

    Download this paper and learn how Node.js can ensure that you:
    - Modernize on-time and budget - no more lengthy, costly, disruptive app rewrites!
    - Retain your IBM i systems of record
    - Find and hire new development talent
    - Integrate new Node.js applications with your existing RPG, Java, .Net, and PHP apps
    - Extend your IBM i capabilties to include Watson API, Cloud, and Internet of Things

    Read Node.js for Enterprise IBM i Modernization Now!


  • Profound Logic Solution Guide

    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 companyare not aligned with the current IT environment.

    Get your copy of this important guide today!


  • 2022 IBM i Marketplace Survey Results

    Fortra2022 marks the eighth edition of the IBM i Marketplace Survey Results. Each year, Fortra captures data on how businesses use the IBM i platform and the IT and cybersecurity initiatives it supports.

    Over the years, this survey has become a true industry benchmark, revealing to readers the trends that are shaping and driving the market and providing insight into what the future may bring for this technology.

  • Brunswick bowls a perfect 300 with LANSA!

    FortraBrunswick is the leader in bowling products, services, and industry expertise for the development and renovation of new and existing bowling centers and mixed-use recreation facilities across the entertainment industry. However, the lifeblood of Brunswick’s capital equipment business was running on a 15-year-old software application written in Visual Basic 6 (VB6) with a SQL Server back-end. The application was at the end of its life and needed to be replaced.
    With the help of Visual LANSA, they found an easy-to-use, long-term platform that enabled their team to collaborate, innovate, and integrate with existing systems and databases within a single platform.
    Read the case study to learn how they achieved success and increased the speed of development by 30% with Visual LANSA.


  • Progressive Web Apps: Create a Universal Experience Across All Devices

    LANSAProgressive Web Apps allow you to reach anyone, anywhere, and on any device with a single unified codebase. This means that your applications—regardless of browser, device, or platform—instantly become more reliable and consistent. They are the present and future of application development, and more and more businesses are catching on.
    Download this whitepaper and learn:

    • How PWAs support fast application development and streamline DevOps
    • How to give your business a competitive edge using PWAs
    • What makes progressive web apps so versatile, both online and offline



  • The Power of Coding in a Low-Code Solution

    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:

    • Discover the benefits of Low-code's quick application creation
    • Understand the differences in model-based and language-based Low-Code platforms
    • Explore the strengths of LANSA's Low-Code Solution to Low-Code’s biggest drawbacks



  • Why Migrate When You Can Modernize?

    LANSABusiness 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.
    In this white paper, you’ll learn how to think of these issues as opportunities rather than problems. We’ll explore motivations to migrate or modernize, their risks and considerations you should be aware of before embarking on a (migration or modernization) project.
    Lastly, we’ll discuss how modernizing IBM i applications with optimized business workflows, integration with other technologies and new mobile and web user interfaces will enable IT – and the business – to experience time-added value and much more.


  • UPDATED: Developer Kit: Making a Business Case for Modernization and Beyond

    Profound Logic Software, Inc.Having trouble getting management approval for modernization projects? The problem may be you're not speaking enough "business" to them.

    This Developer Kit provides you study-backed data and a ready-to-use business case template to help get your very next development project approved!

  • What to Do When Your AS/400 Talent Retires

    FortraIT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators is small.

    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:

    • Why IBM i skills depletion is a top concern
    • How leading organizations are coping
    • Where automation will make the biggest impact


  • Node.js on IBM i Webinar Series Pt. 2: Setting Up Your Development Tools

    Profound Logic Software, Inc.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. In Part 2, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Attend this webinar to learn:

    • Different tools to develop Node.js applications on IBM i
    • Debugging Node.js
    • The basics of Git and tools to help those new to it
    • Using as a pre-built development environment



  • Expert Tips for IBM i Security: Beyond the Basics

    SB PowerTech WC GenericIn this session, IBM i security expert Robin Tatam provides a quick recap of IBM i security basics and guides you through some advanced cybersecurity techniques that can help you take data protection to the next level. Robin will cover:

    • Reducing the risk posed by special authorities
    • Establishing object-level security
    • Overseeing user actions and data access

    Don't miss this chance to take your knowledge of IBM i security beyond the basics.



  • 5 IBM i Security Quick Wins

    SB PowerTech WC GenericIn today’s threat landscape, upper management is laser-focused on cybersecurity. You need to make progress in securing your systems—and make it fast.
    There’s no shortage of actions you could take, but what tactics will actually deliver the results you need? And how can you find a security strategy that fits your budget and time constraints?
    Join top IBM i security expert Robin Tatam as he outlines the five fastest and most impactful changes you can make to strengthen IBM i security this year.
    Your system didn’t become unsecure overnight and you won’t be able to turn it around overnight either. But quick wins are possible with IBM i security, and Robin Tatam will show you how to achieve them.

  • Security Bulletin: Malware Infection Discovered on IBM i Server!

    SB PowerTech WC GenericMalicious programs can bring entire businesses to their knees—and IBM i shops are not immune. It’s critical to grasp the true impact malware can have on IBM i and the network that connects to it. Attend this webinar to gain a thorough understanding of the relationships between:

    • Viruses, native objects, and the integrated file system (IFS)
    • Power Systems and Windows-based viruses and malware
    • PC-based anti-virus scanning versus native IBM i scanning

    There are a number of ways you can minimize your exposure to viruses. IBM i security expert Sandi Moore explains the facts, including how to ensure you're fully protected and compliant with regulations such as PCI.



  • Encryption on IBM i Simplified

    SB PowerTech WC GenericDB2 Field Procedures (FieldProcs) were introduced in IBM i 7.1 and have greatly simplified encryption, often without requiring any application changes. Now you can quickly encrypt sensitive data on the IBM i including PII, PCI, PHI data in your physical files and tables.
    Watch this webinar to learn how you can quickly implement encryption on the IBM i. During the webinar, security expert Robin Tatam will show you how to:

    • Use Field Procedures to automate encryption and decryption
    • Restrict and mask field level access by user or group
    • Meet compliance requirements with effective key management and audit trails


  • Lessons Learned from IBM i Cyber Attacks

    SB PowerTech WC GenericDespite the many options IBM has provided to protect your systems and data, many organizations still struggle to apply appropriate security controls.
    In this webinar, you'll get insight into how the criminals accessed these systems, the fallout from these attacks, and how the incidents could have been avoided by following security best practices.

    • Learn which security gaps cyber criminals love most
    • Find out how other IBM i organizations have fallen victim
    • Get the details on policies and processes you can implement to protect your organization, even when staff works from home

    You will learn the steps you can take to avoid the mistakes made in these examples, as well as other inadequate and misconfigured settings that put businesses at risk.



  • The Power of Coding in a Low-Code Solution

    SB PowerTech WC GenericWhen 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:

    • Discover the benefits of Low-code's quick application creation
    • Understand the differences in model-based and language-based Low-Code platforms
    • Explore the strengths of LANSA's Low-Code Solution to Low-Code’s biggest drawbacks



  • Node Webinar Series Pt. 1: The World of Node.js on IBM i

    SB Profound WC GenericHave 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.
    Part 1 will teach you what Node.js is, why it's a great option for IBM i shops, and how to take advantage of the ecosystem surrounding Node.
    In addition to background information, our Director of Product Development Scott Klement will demonstrate applications that take advantage of the Node Package Manager (npm).
    Watch Now.

  • The Biggest Mistakes in IBM i Security

    SB Profound WC Generic The Biggest Mistakes in IBM i Security
    Here’s the harsh reality: cybersecurity pros have to get their jobs right every single day, while an attacker only has to succeed once to do incredible damage.
    Whether that’s thousands of exposed records, millions of dollars in fines and legal fees, or diminished share value, it’s easy to judge organizations that fall victim. IBM i enjoys an enviable reputation for security, but no system is impervious to mistakes.
    Join this webinar to learn about the biggest errors made when securing a Power Systems server.
    This knowledge is critical for ensuring integrity of your application data and preventing you from becoming the next Equifax. It’s also essential for complying with all formal regulations, including SOX, PCI, GDPR, and HIPAA
    Watch Now.

  • Comply in 5! Well, actually UNDER 5 minutes!!

    SB CYBRA PPL 5382

    TRY 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.

    Request your trial now!

  • Backup and Recovery on IBM i: Your Strategy for the Unexpected

    FortraRobot automates the routine 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:
    - Simplified backup procedures
    - Easy data encryption
    - Save media management
    - Guided restoration
    - Seamless product integration
    Make sure your data survives when catastrophe hits. Try the Robot Backup and Recovery Solution FREE for 30 days.

  • Manage IBM i Messages by Exception with Robot

    SB HelpSystems SC 5413Managing messages on your IBM i can be more than a full-time job if you have to do it manually. 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:
    - Automated message management
    - Tailored notifications and automatic escalation
    - System-wide control of your IBM i partitions
    - Two-way system notifications from your mobile device
    - Seamless product integration
    Try the Robot Message Management Solution FREE for 30 days.

  • Easiest Way to Save Money? Stop Printing IBM i Reports

    FortraRobot 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:

    - Automated report distribution
    - View online without delay
    - Browser interface to make notes
    - Custom retention capabilities
    - Seamless product integration
    Rerun another report? Never again. Try the Robot Report Management Solution FREE for 30 days.

  • Hassle-Free IBM i Operations around the Clock

    SB HelpSystems SC 5413For over 30 years, Robot has been a leader in systems management for IBM i.
    Manage your job schedule with the Robot Job Scheduling Solution. Key features include:
    - Automated batch, interactive, and cross-platform scheduling
    - Event-driven dependency processing
    - Centralized monitoring and reporting
    - Audit log and ready-to-use reports
    - Seamless product integration
    Scale your software, not your staff. Try the Robot Job Scheduling Solution FREE for 30 days.