mrc's Cup of Joe Blog

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

Education

A PowerApps Alternative That Lets You Own the Platform (No Per-User Fees)

By /

If you’re evaluating PowerApps for the first time in 2026, the pricing just changed.

I know…SaaS pricing changes all the time. So what? The business world has gotten used to it.

But here’s the thing. When you’re dealing with a low-code platform that creates and runs your business applications, it’s different. Your business often relies on the applications that it’s created. A pricing change can have major implications for everything you’ve built and everyone who depends on it.

I want to dig into this idea, using PowerApps’ recent change as an example. Is SaaS really the best approach for low-code?

…

A PowerApps Alternative That Lets You Own the Platform (No Per-User Fees)Read More »

Shadow AI Is the New Shadow IT (and Better Policies Won’t Stop It)

By /

Something is happening in your organization right now that you probably don’t have full visibility into.

It’s happening in organizations across the globe.

Business analysts are building reporting dashboards with AI tools, connected to live company data, with no IT involvement.

Finance staff are pasting budget projections into consumer AI platforms to run analysis faster than waiting on a request.

HR employees are running sensitive policy documents through a chatbot to get quick summaries.

Staff in operations are building workflow automations using free AI builders they found online.

None of it went through IT.

That’s shadow AI. And the reason it matters isn’t just that data is leaving your environment…though it is. It’s that this behavior is accelerating faster than any governance policy can catch up with.

Eventually, everything these people built becomes your problem to secure, maintain, and explain to auditors.

…

Shadow AI Is the New Shadow IT (and Better Policies Won’t Stop It)Read More »

How to Build AI Workflows Over Your Data

By / ,

Some things don’t really “click” until you see them in action. You hear people talking about some new technology, trend, or tool. But you don’t really “get it” until you see it.

That’s how data-driven AI workflows were for me.

I’d heard the AI hype. Then I saw an AI assistant working over live business data. My wheels started spinning. It opened up so many possibilities. 

Then I saw that AI assistant added to a workflow. Data was passed to the assistant, which then made a decision…and led to another workflow step, which could then lead to another assistant and so on.

That’s when it really clicked. You can do anything with this.

In this article, I’ll explain more about AI workflows and why they’re so important to businesses. What are they? How do they work? Why should you care?

Also, we’ve included a video that walks through the whole process of creating an AI workflow from start to finish. After all, some things don’t really “click” until you see them in action.

…

How to Build AI Workflows Over Your DataRead More »

MS Access Modernization: Why (and How) to Move to the Web

By /

Key takeaways from this article

  • What’s wrong with MS Access?
    There’s nothing inherently wrong when it’s used as intended. The real issue is that simple Access apps can quietly balloon into complex, mission-critical systems that Access wasn’t built to support.
  • When should you not use Access?
    MS Access falters in multi-user environments, in projects that require integration, apps that require mobile access, or once your database grows past its 2 GB limit.
  • Can we just build web apps directly over our Access database?
    Not reliably. Access has no native web deployment and its file-based engine isn’t designed for web concurrency. While you can connect a web server to an Access file for very light scenarios, it’s fragile and doesn’t scale. For web apps, you need to move the data to a server database (e.g., SQL Server, PostgreSQL, MySQL).
  • How can you migrate Access to the web?
    As demonstrated in the below video, moving Access data to a relational database and building web applications over it is pretty straightforward with the right tools.
…

MS Access Modernization: Why (and How) to Move to the WebRead More »

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

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 »

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.

Video: Create web-based reports over a Snowflake database

By /

Snowflake is a popular data platform and data warehouse. It provides a cloud-based, relational database that businesses use to store structured and semi-structured data. Snowflake is known for offering data access at near-infinite scale, and is often used to store massive data sets.

The big question: If you use Snowflake, what are you doing with all of your data? Are you using this data to gain a clear view of your business and make informed decisions? Do you have an easy way to quickly create reports and dashboards over your data tables?

After all, what good is your data if you don’t use it?

The good news: Creating reports over your Snowflake data tables is simple! We just released a new video demo that shows how easily you can create reports, BI applications, and dashboards over your data. In just 5 minutes, we take you step-by-step through the whole process of creating a report over a Snowflake database table using m-Power. You can find the video below:

Want to see m-Power working over your data? Set up a custom demo here: m-Power Demo.