Mon, Jun
3 New Articles

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 This email address is being protected from spambots. You need JavaScript enabled to view it..



Support MC Press Online

$0.00 Raised:

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: