Quite often it is necessary to give the user ability to edit data in the database or generate reports because not everything can be automated.

Active Table Editor features list

Manual Data entry

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

Active Table Editor


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


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


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


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


Ability to design reports is also very important


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

The best way to learn Active Table Editor is to watch video’s. They are very shot and designed to explain one function. Documentation provides more detailed information.

Video Tutorial

Confused? Ask question on our ETL Forum
Last updated: August 1, 2022