User Tools

Site Tools


ate:start

Active Table Editor Documentation

Introduction

Common business application functionality

Every business application for example accoutring software or hospital patient admission system has the following functionality

Manual Data entry

Very common request users my want to enter payments or invoices in some of the database table plus they may want to design their own data entry screens

Import

Import is very important because everyone wants to avoid entering data twice.

Export

Same as above this should work correctly with excel as favorite data format for most of the users

Calculations

Most of the calculations are performed inside the database so it must be very easy to run stored procedure just by pressing a button

Printing

Again it is hard to imagine modern application without ability to print the data

Reports

Ability to design reports is also very important

Security

Users want to control who can see what and and who is able to modify the data. This is usually done by creating user groups ans giving them access to certain objects

Why we created Active Table Editor

While implementing data warehouse we needed to give the users ability to edit lookups tables so we created an universal solution for this kind of tasks Active Table Editor

Later this functionally was greatly extended

Table of Contents

ate/start.txt · Last modified: 2015/07/27 13:30 by admin