SpreadServe Tech Spec

Technical specification

SpreadServe is a Windows Server hosted server product with a web UI.

• OSes: any Windows desktop OS from Windows 7, and any server OS from 2003. SpreadServe has been tested on Windows 7, Windows 8, Windows Server 2008 & 2012.
• User interface: web UI built with Angular 1.5, <http://Bootstrap 3.3 and jQuery 2.2 enabling job control and spreadsheet interaction from a browser.
• APIs
  • Python: the best API for Web integrations, as well as rapid, ad hoc development. SpreadServe uses Python 2.7.8, 3.x is not yet supported.
  • C++: the best API for high performance systems integration. For example, this is the right way to connect SpreadServe to a low latency pub sub messaging system like TibRV or Solace. Integrations should be built with MS Visual Studio 2008 or later.
  • REST: external processes can drive SpreadServeEngines via the RealTimeWebServer REST API.
  • Java: the best option for relational database integration with JDBC. spreadserve.jar is built with JDK 1.6.
• Core implementation: SpreadServe’s native implementation language is C++ built as 32 bit binaries with Microsoft Visual C++ 9.
• VBA: SpreadServe supports VBA macros, but does not support VBA GUI operations.
• XLL: SpreadServe supports XLL addins, and has been tested with the QuantLib 1.4.0 addin.
• RTD: SpreadServe supports RTD updates.
• Excel file formats: Excel 97-2003 .xls as well as the default Excel .xlsx format are supported.
• RDBMS: the dblog component enables logging of all SpreadSheet operations to an RDB. SpreadServe has been tested with MySQL 5.6, and should work with any RDB that has a JDBC driver.
• Sockets: The SocketServer enables connections from processes based on other hosts and implementation technologies.
• Open Source Software: SpreadServe uses several powerful OSS technologies as building blocks. They include Tornado, Python, STLport , Boost and Apache Open Office.
• Cloud ready: SpreadServe has been deployed and tested on Amazon EC2 Windows 2008 & 2012 AMIs.