An Information System Strategy That Works
The best leverage for an organization with more than one MANMAN plant code is to implement an infrastructure that supports a simple "build once deploy many" structure. The eNVy SQL database framework is ideal for such environments, permitting the DBA/Administrator opportunities to leverage CodasyL DBMS MANMAN data on report-friendly platforms such as Microsoft SQL Server and Oracle.
Reviewing the left graphic, each plant comprises a data layer in the framework's infrastructure. Applications can interact with data on any or all layers in the framework. This website's menu demonstrate how this can be done.
From an implementation perspective, one installs the eNVy Warehouse Suite SQL tools, creates an application (e.g. this web reporting system), then releases it to users. "Under the hood", the user can access any or all MANMAN plant codes by toggling the data source of the eNVy SQL database. In this web example, selecting a plant code from the site's menu changes the data source to the database of interest. A single code base (web application) can access any number of eNVy/MANMAN plant codes.
For non-MANMAN "off-line" data sources, an additional effort is required to map the data to corresponding SQL objects used by the eNVy SQL database (e.g. Sales Order, Invoice, Purchase Order, etc.) Added to the efficiency of single plant code data reporting is the consolidated reporting view.
Beyond the reporting framework are opportunities for bolt on applications such as coding systems, on-line ordering, EDI and decision-support reporting systems.
The eNVy SQL framework replicates Codasyl DBMS MANMAN data to a corresponding SQL Server database. Data are "mined" from the MANMAN Codasyl DBMS transaction log thus permitting net change synchronization data replication to your SQL environment.
The eNVy Systems design philosophy, "build once and deploy many", results in significant opportunities to leverage technology and your data.
Tim Peer is a Senior Engineer, eNVy Systems, Inc.