Trusted by over 1,500 companies worldwide
Why choose m-Power for a database front-end?
The m-Power Development Platform lets you create web-based database front-ends easily, without any coding. Here are a few reasons to choose m-Power to create database front-ends for your business:
Speed
Create front-ends with built-in searching, filtering, and sorting...in minutes.
Simplicity
No coding required! Build quickly using a simple point-and-click interface.
Licensing
With no user or distribution fees, m-Power scales easily across your entire business.
Flexibility
m-Power's open architecture works with any relational database, and runs on-premise or in the cloud.
Mobility
Automatically create cross-platform, web-based front-ends with every build process.
Security
Include security features like single sign-on, multi-tenant security, user privilege parameters and more.
We have utilized m-Power to extend capabilities of our existing Retalix ERP database--avoiding modification costs and giving us more bang for the buck.
Another aspect of m-Power is the speed at which we can produce most of the applications. If the data is in the proper format in our tables--and it generally is--then all we need to do is pick tables and choose columns through m-Power's menu driven interface. Now, we can actually build applications in hours instead of weeks.
It was clear that m-Power offered Raleigh the right tool at the right price backed up by considerable experience.
How it works: Build a Database Front-End in 4 Steps
m-Power works over your existing database tables, either on-premise or in the cloud. Creating a front end over your database is just a 4 step process:
Step 1
Choose your template and name your application
m-Power's pre-built templates come with all of the architecture and standard features baked in, which eliminates most of the development effort. The "Data List with Web Form" template is the ideal choice for a db front-end. It organizes your data in a table format, and includes options to sort, filter, view, update, and delete rows.
Step 2
Choose and sort your data
Choose your database tables and fields to include in your application. Do you need fields from multiple tables? No problem! m-Power makes table joins simple. Of course, you must also tell m-Power how to sort your data within the application.
Step 3
Optional: Add your logic/filters
This optional step provides a preview of your front end, and lets you add additional specifications to the application. Options include:
- Field Settings: Customize the fields you would like to display.
- Record Selections: Filter the data that's displayed in your application, or set run-time filters for the user.
- Calculations: Add calculated fields to your application.
- External Objects: Add custom business logic and custom code to your application.
- Smartlinks: Link your application to another m-Power application, while passing key data automatically.
Step 4
Build
When you click the "build" button, m-Power combines the specifications with the selected template to generate your front end application. The compile process automates these steps:
- Generate the Java source code, including the SQL database access statements.
- Compile the Java source code into a J2EE Java servlet program.
- Create the HTML presentation file.
- Create the XML properties file for setting application-level options.
- Deploy the entire package to the application server.
Step 5
Optional: Customize your application
You have unlimited customization options through m-Painter (m-Power's visual designer) and the Workflow Designer. Here are a few common ways that users customize their applications after they're built:
Look & Feel
You have complete control over your application's look and feel.
Add Workflows
Create workflows that are triggered by your application.
Insert Charts
Add charts and graphs to your application using m-Painter.
Add Features
Add forms, calendar pop-ups, drop-downs, and much more.
Edit the Code
Open up the code view and edit your application's HTML, CSS, or Java files.
Embed other applications
m-Power's Smartlink feature lets you embed other apps within your app, passing key data automatically.
Which Databases Does m-Power Support?
m-Power supports all major databases. Here are a few of the most common databases our clients use:
IBM Power Systems(iSeries/AS400)
Oracle
MySQL
MSSQL
Progress
PostgreSQL
Snowflake
Apache Derby
Case Study: Sunstar
Sunstar was moving from Lotus Notes to Office 365, but Office 365 doesn't include a CRM system. Since they relied heavily on their CRM system, this created a delay in their rollout. Read this case study to learn how they created a custom CRM system over their database using the m-Power Development Platform.
Results
Their choice of m-Power saved $200,000 in the first year, and $100,000 every year going forward
They now have a CRM system that perfectly fits their business
They created their custom system in less time than it would take to deploy an off-the-shelf solution
Enterprise‑Grade Security & Compliance
Row‑Level Permissions
Control which users see which rows in an application.
Application Security
Lock down application access per user role.
Use Your Authentication
Integrate with SAML, OAuth2, or Active Directory.
Audit Trails
Full logging of user actions and logins.
Video: How to create a database front-end in 5 minutes
How quickly can you create front-ends over your database? We believe the answer to that question should be measured in minutes, and we just created a new video to show you how it’s done. The following video walks you through a start-to-finish process used to create a front-end over any relational database…in just 5 minutes. You might be surprised to learn just how simple this process is.
Watch Video
Database Front-End Demos
Check out these database front-end demos that were created with m-Power.
Frequently Asked Questions
How long does it take to build a front‑end?
Do I need programming skills to build a database front‑end?
Which relational databases can I connect to?
Can I customize the look and feel of my front‑end?
How is m‑Power licensed and priced?
How can I try m‑Power before purchasing?
Learn how m-Power can help you
Sign up for a custom demo