Brief
This product enforces strong practices on handling spreadsheets to achieve spreadsheet management processes compliant to Sarbanes-Oxley Act, reduce risks imposed by spreadsheet management, validate data in the spreadsheets against other data sources, facilitates audit and version control capabilities.
Architecture
A desktop application accessing a spreadsheet repository service via HTTP and using a relational database.
Brief
Main purpose of this system is to automate validation of data read from various sources (any JDBC compliant DBMS or flat files) and detection of erroneous transactions. Validity of a transaction is determined by executing a set of custom statements on each transaction and can be based on data of the current transaction, variables that keep aggregated data from this or any other available source. Upon detection of an invalid transaction it may perform one of several available actions. Validation can be performed in passive mode, where transactions are fed to the system via API, or in active mode, when the system fetches information about transactions from the sources. Custom statements are expressed in a UI-driven pseudo programming language.
Architecture
A desktop application accessing database hosted on either Oracle or SQL Server.
