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

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

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)

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.

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

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.

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

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

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

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.

How to build a custom CRM system in 75 minutes with low-code (step-by-step video)

analyticsIf your business had a choice between an off-the-shelf CRM system and a CRM that’s custom-built to your needs, which would you choose (assuming you’d get either one immediately)? I’d say the vast majority of businesses would prefer a custom CRM. After all, custom CRM systems offer a number of advantages, such as:

  • Scale without user fees: Off-the-shelf CRM systems typically charge per user…which can quickly drive up the cost in larger companies. With a custom CRM system, you can scale across your entire company without user fees!
  • Custom Workflow Processes: You can build custom workflow processes into any aspect of your CRM. For instance, you can create customer onboarding workflows that fire automatically when a lead becomes a customer.
  • Integration with existing software or third-party tools: For example, you might want to update your ERP system or pass data to a third-party tool using an API.
  • Deploy anywhere: Most off-the-shelf CRM systems only run in the cloud. A custom CRM can run in the cloud or on-premise. The choice is yours.
  • Control the security: Every business has different security needs. With a custom CRM, you can control how much or how little security you’d like to have.

With these advantages, why doesn’t every business opt for custom CRM systems? It all comes down to development time. Building a custom CRM from scratch can be expensive and easily take months.

The big question: What if you could create custom CRM systems in days or weeks? What if you could get all of the benefits of a custom CRM with non of the drawbacks?

It’s not as hard as you think. We recently released a new video that shows you how easily you can create a custom CRM system using low-code development. In the video, we create a CRM system that includes custom workflow processes, API integration with third-party software, and ERP integration. The result: A custom CRM that perfectly fits our needs and can be easily enhanced and changed.

The best part: The whole process only takes 75 minutes. You can watch the video below:

Want to learn more? Set up a demo here: Set up a demo.

7 web application development challenges in 2024 (and a solution)

Summary: As technology evolves at breakneck speed, it brings new opportunities and challenges to web application development. If businesses want to create lasting, successful web applications, they must address these challenges.

Let’s talk about web applications. I know it’s a vague term, so I’ll quickly define it for the sake of clarity.

Video Demos: Watch entire low-code development projects

By now, you’ve probably heard all about the benefits of low-code development tools. They let you build business applications with little (or no) code. They reduce development time by 50-80%. They let you deliver custom business applications in hours or days.

I could go on.

The big question: If your organization does any type of manual web application development in-house, why aren’t you using low-code? If it still takes months to deliver business applications from scratch, what’s keeping you from using development tools?

Chances are, you’re skeptical. 

Maybe you don’t believe the time-saving claims.

Maybe you’re worried that it isn’t as easy to use as the vendor claims.

Maybe you’re worried that it will limit your options.

Or, maybe you think that low-code is just 4GL or RAD tools all over again. 

I could debunk every one of those fears, but prefer a different approach. I’d rather let you see it for yourself. To help you understand the low-code development process, our consultants put together videos of full development projects that:

  • Walk you through the entire process from start to finish
  • Show (and explain) each step in the development process
  • Are completed in under 2 hours 

Word of warning: These are longer videos (1.5 – 2 hours each) because we didn’t want to leave anything out. But, you’ll get a good idea of how quickly you can go from nothing to a working application with low code. Sound reasonable? Here are the videos:

1. How to build a custom helpdesk portal with low-code

In this video, we create a helpdesk portal from scratch using low-code. This portal includes user security, a helpdesk ticketing system, a helpdesk calendar, support dashboard, and more. 

2. How to create a BI/Reporting suite with low-code

In this video, we walk you through a custom business intelligence/reporting project. We start with a single spreadsheet full of data and create a suite of BI & reporting applications that includes features like multi-tenant security, forecasting, dashboarding, data write-back, data warehousing, and many more.

3. Create a Field Service Management Application with low-code

In this video, we create a custom field service management system from scratch. This system includes a job listing application, signature capture, mapping, multi-tenant security, and much more. 

Want to try low-code for yourself? Sign up for a free m-Power Trial right here