|
Article:
Do You Want Your Own Fully Programmable ERP? - Part 2 by: J.C.Melo In the first article we mentioned the main characteristics that should have a software to be used as a Front-End with some functions of an Enterprise Resources Planning ERP: ODBC, Replication, Computed Views, Integrated e-Mail, and we used the Lotus Notes example, but in principle will be possible to use other softwares with similar functions. Now we will see a practical case, a system to detect and control - marketing, sales, new purchase orders - your aground products. As we know, the salesman prefer to sold new products only, and your aground products will be less and less sold. We assume that your company already have an online managerial/accounting system, with evidently its own database. 1. We will use a method to transfer your managerial/accounting data to the Notes relational database, and although this last one has tools for that - ODBC for example - we recommended the purchase of a specific software for that purpose in order to be more flexible and with more powerful features, that must allow the following transfers: From Notes to your relational database From your relational database to Notes From a Notes database to another Notes database From ASCII files to Notes database From Notes database to ASCII files Synchronization of both databases Scheduled type transfers - in a defined time, or hour or minute or day, etc. Normally this kind of software works with the following databases - and this probably include the database type used by your company: ALLBASE/SQL, Btrieve, Clipper, DB'2
|
