mrc's Cup of Joe Blog

Join us in exploring the world of modern development, evolving technologies, and the art of future-proof software

Author name: Sal Stangarone

Sal Stangarone is a partner at mrc—the software company behind the award winning development platform, m-Power. Sal shares his technology insights through the Cup of Joe Blog, focusing primarily on modern development and evolving technologies.

Choosing a Web Query Alternative: One Consultant’s Methodical Approach

By / ,

When IBM announced the end of Db2 Web Query for i, it caught many businesses off guard. Web Query was the go-to reporting tool for IBM i shops. Suddenly, those companies were left asking the same question: Now what?

Rick Flagler, an experienced IBM i consultant, heard that question from his clients almost immediately. They depended on Web Query for reporting and needed a reliable replacement that wouldn’t compromise functionality.

Rick approached the challenge with the precision you’d expect from a seasoned consultant. First, he created a “shopping list” of features that a Web Query replacement should include. He then dove into the landscape of BI tools built for IBM i, narrowing the field to those that ran natively and aligned with his clients’ needs.

From there, Rick didn’t rely on vendor claims or promises…he put each option to the test. He reviewed report designs, requested proof-of-concept demos, and evaluated each product’s ability to meet his criteria.

While I’m happy to say that his search led to m-Power, I’m just scratching the surface here. Rick wrote an article on the whole process, and goes into more details on his approach and criteria. You can read it here: “Life After IBM Db2 Web Query for i: Finding an Alternative.”

If you’re looking for a Web Query replacement, this article is well worth the read. It provides great insight into a thoughtful software evaluation process, what to look for in a BI replacement, and how an experienced consultant approaches this task.

To learn more about m-Power and how it can replace Db2 Web Query, check out this page: IBM Db2 Web Query Replacement

Internal Tools: How to Build Apps That Streamline Your Business

By / , ,

Imagine being stuck in an endless email chain…just to get a simple approval. Or worse, imagine wasting hours pulling data from disconnected spreadsheets only to realize it’s already outdated. 

The fact is, most internal processes are a mess.

Teams jump between tools. Spreadsheets do things they were never meant to do. Manual workarounds become the standard. Everyone knows it’s inefficient, but…no one knows how to fix it. Or, they’re just used to it.

That’s where internal tools come in.

Internal tools are custom apps built to solve problems inside your business. They help your team work faster, cut out repetitive tasks, and replace duct-taped processes with real solutions.

Better yet, they fit into your own infrastructure and unique business processes. When done right, these custom internal tools are invisible. They just work. They streamline processes and never get in the way.

The best part? Creating internal tools isn’t that hard. You don’t need a huge development team or a massive budget. With the right plan (and the right tools), anyone can build internal tools that make a real difference.

In this article, I’ll walk through how to do it. You’ll learn what works, what to avoid, and how to make internal tools a real advantage for your business. 

Sound good? Let’s get into it.

…

Internal Tools: How to Build Apps That Streamline Your BusinessRead More »

How to Build a Web-Based Dashboard (+ Video Guide)

By / ,

Dashboards should make your life easier. Many don’t.

What happens? Some try to show everything at once…without really showing anything useful. Others take months to build and still don’t have the right data. Yet, making a change might take weeks. I could go on.

The good news? Dashboards have come a long way. They’re accessible from anywhere. They update in real time. And with the right tools, you can build one in a day—not a quarter.

In this article, you’ll learn how to build web-based dashboards in minutes that actually help people do their jobs. We’ll cover different types—like KPI dashboards, executive dashboards, and other business dashboards your different teams might use. You’ll learn some best practices, mistakes to avoid, and the best approach to development. 

Sounds good? Let’s get started.

…

How to Build a Web-Based Dashboard (+ Video Guide)Read More »

How to create a custom, web-based scheduling calendar in 12 minutes

By / ,

developmentLet’s be honest: There’s no shortage of web-based calendar tools these days. You’ll find dozens of off-the-shelf scheduling calendars that you can set up and deploy in your business.

The problem is, they’re all generic and every business is different. While these off-the-shelf scheduling applications might fit most of your needs, they won’t provide a perfect fit. They might do some things very well but lack key features in other areas.

But, what if you could create a custom scheduling application…faster than it takes to deploy a generic solution? What if you could create a data-driven, web-based calendar that was 100% tailored to your business…in a little over 10 minutes? It’s possible, and we’ve created a video to show you how it’s done.

Want to try it for yourself? Set up an m-Power Test Drive.

What is a CRUD Application (And How Do You Build One)?

By / , ,

Let’s talk about the unsung hero of business web applications: The CRUD application. They’re everywhere, whether you realize it or not. Your customer database? It’s a CRUD app. Your company’s inventory system? Also a CRUD app. Even when you’re posting updates on LinkedIn – you guessed it – you’re using CRUD apps.

But what exactly makes these applications “CRUD,” and why should you care? In this article, we’ll cut through the technical jargon and explore:

  • What makes an application “CRUD”
  • Real-world examples
  • Important tips for building them (the right way)
  • How to build CRUD apps quickly

Whether you aim to replace that aging system or build new applications, mastering CRUD apps allows you to understand your development project better and ultimately make more informed decisions about them. 

Sounds good? Let’s dive in.

…

What is a CRUD Application (And How Do You Build One)?Read More »

How to turn a spreadsheet into a web app in 6 minutes

By /

EducationI’ve mentioned the dangers of spreadsheet misuse on many occasions, and explained why it’s so important to put that spreadsheet data into your database. However, I realized that I’ve never showed you how to turn your spreadsheets into database-driven web apps.

So, we created a video to do just that. The following video explains why you should convert your spreadsheets into web apps, and even shows you how it’s done. You might be surprised to learn just how simple this process is.

Note: This video is best viewed in 720p(HD) resolution at full screen. Click the “gear” icon below the video to change the resolution.

To learn more, please visit this page: https://www.mrc-productivity.com/solutions/spreadsheets.html

How to create a customer portal in 11 minutes

By /

developmentA customer portal provides a secure, customer-only area on your site where customers can purchase products, view information, submit support requests, update account information, and more. They help businesses improve customer satisfaction, streamline customer support, and even drive revenue.

But…building a customer/vendor portal is a tricky task. One portal must display different data to different users. If one user logs in and sees data that they shouldn’t see, you’ll have a big problem on your hands. You need a way to not only build all of the applications in your portal, but ensure they have at least 3 types of security set up:

1. User security: The most basic security option, user security limits portal access to only registered users.
2. Application security: Once a user logs in to the portal, application security controls which applications they can access.
3. Multi-tenant security: This type of security controls user access at a row level. That means different users can access the same application but only see the data that they’re authorized to access.

Here’s a question: How long does it take to build a secure customer portal and populate that portal with applications for your customers? A few weeks? Months?

How about 11 minutes?

We just created a video to show you how it’s done. This video walks you through the process of building a few applications, setting up security, and creating a customer portal. We walk you through everything from start to finish so you can see just how easy portals can be (with the right tools).

Want to try it for yourself? Set up an m-Power Test Drive.

Want to read the video transcript instead of watching the video? You can find it here: How to create a customer portal in 11 minutes.

Build an Inventory Management System in 75 minutes with Low-Code (step-by-step video)

By / , , ,

We just released a new video that takes you step-by-step through an inventory management system build process. We created this video to demonstrate just how quickly you can create custom applications (like an inventory management system) with m-Power. In roughly 75 minutes, we go from just the data in our database to a fully functional inventory management system, and explain each step along the way. Watch the video below to see the whole process!

Want to see what m-Power can do for your business? Shoot us a note to set up a demo: Setup an m-Power Demo.

…

Build an Inventory Management System in 75 minutes with Low-Code (step-by-step video)Read More »

Case Study: Learn how this non-profits meets development challenges…without developers

By / ,

Picture this: You’re running an IT department, and everyone’s asking for custom applications. The catch? You don’t have a single programmer on your team. What do you do?

Well, that’s exactly what Lifeskills, a Kentucky-based non-profit, was dealing with. But instead of pulling their hair out, they found a secret weapon: The m-Power Development Platform.

…

Case Study: Learn how this non-profits meets development challenges…without developersRead More »

Case Study: Learn how the AICTP outperforms larger companies

By

The American Institute of Certified Tax Planners (AICTP) is a not-for-profit corporation that trains and licenses tax professionals in the expertise of advanced tax reduction.

Shortly after the AICTP was founded, Dominique Molina (President and Founder) noticed a problem: There was no technical solution for this discipline. Everyone used different methods rather than one, standardized approach. This created a problem: When everyone’s doing things in different ways (and getting different results), it’s nearly impossible to effectively teach and lead them.

The solution: The AICTP partnered with mrc’s services team to help them develop a solution for their industry. With Molina providing the tax expertise and mrc’s consultants providing the development, they created a solution that perfectly fits their industry’s needs.

The result: The AICTP offers an industry-leading solution that outperforms solutions from much larger companies. According to Molina, “We’ve been at this for many years. In that time, other competitive solutions have entered the marketplace from some really well-known, well-funded organizations. Their solution is not as effective as ours. That helps us stand out with our clientele because they know that our solution can give them results that other off-the-shelf applications can’t deliver.”

To learn more, you can watch the interview below or read the whole case study here: https://www.mrc-productivity.com/customers/aictp.html.