Return to Sage 200 How it Works.png

System Requirements - Sage 200 Financial Intelligence

A La Carte Financial Intelligence - Sage 200 comprises a centralised set of management reporting databases (Financial Database - MS OLAP Cube, Report Gallery etc) along with a Server Administration component that can reside on your Sage 200 server or additional Windows server.  

On the front end, our A La Carte addin is loaded into a PC based Excel environment that is installed on each user’s machine wishing to access the A La Carte software. Where Windows Terminal Services or Citrix is preferred as a central application server, then Excel for Terminal Services and our A La Carte addin can be used as a single instance to grant each user access from a centralised location.

    Download Supported IT Infrastructures & Security Models PPT
  - Name and Email Address Required

 

Server Environment


Minimum Hardware
  • An IBM compatible server with 64bit 2GHz processors.
  • 2 Processors minimum
  • 4-8GB of RAM.
  • At least 500MB of free hard disk space.

Recommended Hardware
  • An IBM compatible computer with a 64bit (or greater) dual processors.
  • 2-4 Processors minimum
  • 8-12GB + of RAM.
  • At least 500MB of free hard disk space.


Operating systems

  • Microsoft Windows 2012 R2 Server
  • Microsoft Windows 2012 Server
  • Microsoft Windows 2008 R2 Server
  • Microsoft Windows 2008 Server

Other Required Software
  • Sage Line 200, Sage 200
  • SQL Server 2008R2, SQL Server 2012, SQL Server 2012 SP1, SQL Server 2014 or SQL Server 2014 SP1
  • SQL Server 2008R2, SQL Server 2012, SQL Server 2012 SP1, SQL Server 2014 or SQL Server 2014 SP1 Analysis Services 
    (for A La Carte)
    Standard, Business Intelligence (BI) or Enterprise Editions
    (NOT Workgroup or Developer)
  • SQL Server Native Client 11.0, 10.0 (included in install)
  • Microsoft Visual C++ 2010 Redistributable (included in install)
  • Microsoft .NET Framework 4.0 (included in install)
  • Windows Installer (included in install)
 

Client (PC) Environment


Minimum Hardware
  • An IBM compatible PC, Laptop, Ultrabook or Slate with a 2GHz 32bit processor.
  • 4Gb of RAM.
  • At least 500MB of free hard disk space.
  • An SVGA video card and monitor running at 1024 x 768 pixels, with a minimum of 256 colours.

Recommended Hardware
  • An IBM compatible PC, Laptop, Ultrabook or Slate with an Intel i3,i5,i7 64bit or equivalent processor.
  • 4GB+ of RAM.
  • At least 500MB of free hard disk space.
  • An SVGA video card and monitor running at 1024 x 768 pixels, with a minimum of 24-bit true colour.

Operating systems
  • Microsoft Windows 10 Professional or higher
  • Microsoft Windows 8.1 Professional or higher (RT is not supported)
  • Microsoft Windows 8 Professional or higher (RT is not supported)
  • Microsoft Windows 7 (Home Premium, Professional, Ultimate)

Other Required Software
  • Microsoft Excel 2007, 2010, 2013
    (Excel 2010 and 2013 can be 64 bit if required)
  • Microsoft .NET Framework 4.0 (included in install)
  • SQL Server Native Client 11.0, 10.0 (included in install)
  • Microsoft Visual C++ 2010 Redistributable (included in install)
  • Windows Installer (included in install)

 

Cloud Deployment Requirements

For Simple Storage of Dashboards (Excel only data) In The Cloud

  • SkyDrive, Google Docs, Dropbox or Box cloud storage account.
  • iOS or Android Phone or Tablet.

For Interactive Access To Dashboards (Any data *) In The Cloud

 Minimum Hardware

  • Server running Windows Server Terminal Services or Citrix with 64bit 2GHz+ processors.
  • An SVGA video card and monitor running at 1024 x 768 pixels, with a minimum of 256 colours.
  • 2 Processors minimum
  • 6-8GB of RAM.
  • At least 500MB of free hard disk space.

Recommended Hardware

  • Server running Windows Server Terminal Services or Citrix with a 64bit (or greater) dual processors.
  • An SVGA video card and monitor running at 1024 x 768 pixels, with a minimum of 24-bit true colour.
  • 2-4 Processors minimum
  • 8-12GB + of RAM.
  • At least 500MB of free hard disk space.

Operating systems

  • Microsoft Windows Server 2008 / 2008R2 / 2012 / 2012R2
  • Microsoft Windows Terminal Services or Citrix
  • Microsoft RemoteApp and RD Web configured

Other Required Software

  • Terminal Services Version of Microsoft Excel 2007, 2010, 2013
    (Excel 2010 and 2013 can be 64 bit if required)
  • Excel Terminal Services Client Access Licenses (CALS) to support number of users
  • Microsoft .NET Framework 4.0 (included in install)
  • Windows Installer (included in install)

* 'Any data' refers to Microsoft AS OLAP data, SQL tables and views and Excel data