Cromwell – eCommerce Sales Reporting
Sales figures at the touch of a button
Pulling in information from a remote Microsoft SQL database Server (MS-SQL) and a remote PostgreSQL database server, this application allowed for online sales figures to be viewed for the two eCommerce systems in operation (previously there was no sales reporting information available) and for the information to be compared between the systems.
Written in PHP, this system utilised the Yahoo! YUI Javascript library to enable online graphs to be displayed and interacted with – along with allowing output in web page (HTML) and CSV (Comma Separated Value) file formats for importing into Microsoft Excel. The system, due to the confidential nature of the data, had a strict user authentication system which used Active Directory network logons and PostgreSQL’s user management facilities.
Date
December 2007
Technologies
PHP
PostgreSQL
MS-SQL
Active Directory integration