Warehouse Suite tools are comprised of Schema Generator Plus, WarehousePLUS, and eNVy Replicator Console: Schema Generator extracts and builds all programs necessary to attach and execute against a Codasyl DBMS database. Schema Generator uses advanced technology to extract Codasyl DBMS set/record and field elements from a Codasyl DBMS database and construct a relational “mirror” to an OpenVMS Oracle Rdb database. Schema Generator creates all source code used by Warehouse Suite running on OpenVMS. Your Codasyl database schema is converted to an Oracle Rdb relation database from which a WarehousePLUS database is created and populated. Changes to the Codasyl DBMS database are read from after-image journal files and update WarehousePLUS. WarehousePLUS databases are replicated using the eNVy Replicator Console application to an SQL 92-compliant database of your choice. Whether you deploy an SQL repository of a single or multiple databases, WarehousePLUS can do the job in a fraction of the time compared to conventional extraction methods. Implementation and ongoing maintenance do not require a large or sophisticated IT organization—anyone can benefit. The Warehouse Suite Product permits ALL applications to implement an SQL Data Warehouse of your production/archived Oracle Codasyl DBMS database to SQL Server and Oracle. Warehouse Suite SQL databases are your data source for information systems analytics and dashboards. SQL Databases can be refreshed with up-to-date Codasyl DBMS transaction data daily, hourly, or every few minutes. The information access possibilities seem endless—you can integrate your Codasyl DBMS/MANMAN environment with an SQL back end and a Windows-friendly user interface on the front end.

Contact us today for more details, to get a free quote, or to schedule an appointment.