Technical Specifications

SheetKraft is an automation framework geared towards automating spreadsheet based processes.

The software has three components:

Microsoft Excel Add-on: This is installed on the user's profile on his / her desktop. It helps business users specify the process steps via a user interface within the excel spreadsheet.
SheetKraft Server: This is a software which sits on a server and is capable of running processes setup via the Excel add-on. Multiple users can log on to the server and users will be allowed to setup processes which can then be run on the server.
Database: This holds all the application data.

Application Server Requirements:

Windows Server 2012 or above (64-bit) with the latest service pack installed
3 GHz quad core processor or better is recommended
16+ GB RAM available for SheetKraft processes
500 GB of free disk space (required for installation, log files, temporary files, and user input files)
.NET Framework 4.7.2 or above
Windows Powershell 4 or above
SSL Certificate to enable https protocol (if https is required)
Connectivity to database server
Connectivity to Active Directory servers and database servers (if such integration is desired)
Administrative access during initial installation and at the time of applying patches.
A functional Id which has admin access to the server to run the application pool, activity runner and access shared folder from the server. A functional Id is a user account whose password will not expire.

Database Server Requirements:

SQL Server 2012 or above (with the latest service pack installed) or PostgreSql Version 11 and above. This may require .NET Framework 3.5 and .NET Framework 4.7.2
3 GHz quad core processor or better is recommended
8+ GB RAM
500 GB of disk space (required for the database)
Permissions to create a database (during initial installation) and create users with full access to that database (The installation tool generates a script that does this. This script may be run by a database administrator if permissions are not granted)

Development Machine Requirements (for development and maintenance):

64 bit Microsoft Excel 2013 or above
100 GB of disk space (required for installation of SheetKraft Add-in and temporary files)
Windows 7 or above (with latest service pack) 64 bit
3 GHz dual core processor or better is recommended
8 GB RAM or more (16 GB is recommended)
.Net Framework 4.7.2 or above
Visual C++ Redistributable 2015
SQL Server Management Studio (latest version)
Connectivity to Active Directory servers for user logins (if such integration is desired)
Connectivity to Database Server
Remote Desktop access to Application Server
Unrestricted permission to download files from https://www.sheetkraft.com (This is required for applying patches)
Administrative access to install any other useful software (If this is not provided, considerable delays can occur during implementation)

Client Requirements (for web access):

Note: Any pre-requisites for any of the above mentioned software need to be installed on the machines.