Data Warehouse & Data Mart Access
With dbFront, your users can easily explore and work with your Data Warehouse and Data Mart tables. No configuration is required beyond the initial security and database connection.

dbFront intelligently takes into account: keys, relationships, field types, indexes, full-text indexes, table security and more, as it dynamically generates the form and table layouts. The table layout is automatically updated if the database structure changes.
- Administrators can adjust the base layout and add complex functionality as required.
- Users can adjust their own layouts and add custom filters.
- Users have access to reporting, exports, imports, mass-update functionality, and more...
- Respects the database security and integrates with AD and SAML-based SSO.
What Real Professionals Are Saying
"Our team is working on data warehousing solutions, and we have moved to a model where each department gets their own datamart. This means many databases all needing to share standards and best practice. We tried putting an Access front end on the process, but quickly gave up, seeing how complex and time-consuming it was. dbFront, on the other hand, was installed and working within 30 minutes and has gone from strength to strength."
— Alex Abbott, Consultant via Capterra Reviews
"Saves lots of time compared to developing your own web (or stand-alone client) front end."
— Johnathan R., LinkedIn Reviewer
"If you are looking for a database management module WITHOUT the coding, simply put, dbFront is for you! Don't waste another minute."
— Dennis, Veria Tech via G2 Certified Reviews
For More Details...
To see what is possible, please review the product details, or watch our video tutorials.
Adventure Works - Product Table
The following interface was created from the product table in Microsoft's sample database
Expense Reporter - Home
A free and open source dbFront application that allows your employees to submit expense reports which would pass through management and finance for approval and processing. Implements: Workflow, Auditing and a TodoList
Depreciation Calculator - Home
Depreciation Calculator is a simple open source dbFront application that allows you to maintain a simple list of Assets and calculate the yearly depreciation for each item.
Responsive Design
Support for everything from a small smartphone to a 4K monitor and beyond
Simple or Distributed Setup (DMZ)
A simple setup allows for everything to be installed on a single server. The most secure setup is to spread the Database, Application Server and Web Application over three servers. dbFront allows for any combination.
Child Tables (1-M)
Regular (1-M) child tables appear in separate tabs, each with a grid and form
Child Tables (1-1)
A child (1-1) relationship will appear without a grid
Single-Select Foreign Keys (1-M)
Simple Lookup to Store Table
Multi-Select Foreign Key (M-M)
Multiselect Lookup to Credit Card Table (intermediate associate table)
Configure Relationship Details
Arrange, Rename or Hide related tables
Reporting - Quick Reports
Template based reporting allows regular users to simply, quickly and safely create their own reports. Administrators can save these reports to enable single click reports with optional prompts for search fields or output choices.
Reporting - Invoice Template
Invoice Template setup on the Adventure Works Sales Table
Reporting - Sample Item Listing
This is a simple listing of selected records. Users can easily create these listings and either print or export the results.
Reporting - Crystal Reports
dbFront has the ability to directly process and print SAP Crystal Reports. Users can optionally choose to print to a server-attached printer, view it as a PDF or download the output as either CSV, DOC, PDF, RTF, TSV or XLS.
Advanced Search
Below every table is a configurable and collapsible panel with a list of fields that you can search on individually. This allows advanced access to range and other custom searchs.
Row Level Security
Row Level Security is applied using SQL expressions that evaluate to true or false. The expression syntax is similar to a regular where clause. Select, Update, Delete and Insert permissions are supported.
Stored Procedures
Stored Procedures can be triggered by an Action Button and can be used perform any process and then dynamically return results that can be used to drive a report or export. Multiple recordsets are supported.
Table Views
Database views can be added to tables and their fields can be used everywhere that a regular table field can be used. This includes Reports, Exports, Row Security Expressions, Dropdown Columns, everywhere...
Workflow in Database
Workflow is implemented within the Database using a status and workflow table with dbFront providing the UI. A fully functional example is provided in the Expense Reporter Application.
Layered Security for Defence in Depth
Security is a thorny issue when building database-driven web applications. With dbFront, we have and will take this problem seriously which is why we designed dbFront with the view of defence in depth.
Database Compatibility
Oracle 10+, Microsoft SQL Server 2000+ and MySQL 4+
Try dbFront for Free
dbFront offers a 30-day free trial so that you can download, install and test it in your environment. After the trial you can continue to use the FREE version of dbFront for up to 3 users. Please review the video tutorials and plan to start a free trial today. We believe you will be impressed.
Content you want the user to see goes here.
close