Acterys System / Platform Requirements

OS and client software versions and hardware requirements

Client-Side Requirements Cloud Version

Component

Requirements

Acterys Modeller

 

Client Machine

  • Min 2.1 GHz Intel Core 2 Duo processor or better (recommended i5 2.6 GHz)
  • Min GB RAM (recommended 4 GB)
  • Min 2 GB free hard disk space
  • Screen resolution of at least 1024×768, 32-bit colour

Network

Cloud Version (using Server: Acterys.database.windows.net server):

Requirements for Acterys Modeller

The Acterys API uses port 9998 over HTTPS protocol and needs to be open in the network. Access to this port is necessary for all Acterys Modeller users.

Users that use Acterys via Microsoft Power BI do not require any special configuration as Acterys trusts servers in the Power BI cloud infrastructure.

Azure SQL Database Access

For users that need direct access to the Azure SQL Database which contains all Acterys tables and views, port 1433 needs to be open on the client machine. 

To access the Acterys Azure SQL database, the IP address of the client machine has to be added to the firewall and whitelisted. This can be done through the Acterys Modeller web interface in the "Safe IP" menu > "Add IP". Just click on the "Add" button.

Please be aware, that when accessing Azure SQL databases you have to specify the database name!

 

Supported Operating Systems

  • Microsoft Windows 10
  • Microsoft Windows 8
  • Microsoft Windows 7
  • Mac OS X

Web Browser

  • Microsoft Edge (due to missing support of modern javascript features, legacy Microsoft Internet Explorer is not supported)
  • Chrome (all versions)
  • Firefox 18.0 and above
  • Browser Cookies must be enabled

Acterys Visuals

 

Power BI Desktop

  • This component is needed for the report designers only
  • The Latest Version of Power BI Desktop is available here 

Note: There is no native Mac OS X version for Microsoft Power BI Desktop for now. It is only available for Microsoft Windows. On request, we can provide a Power Desktop application usable from any web browser through terminal services.

You can edit and create Power BI template reports without Power BI Desktop on a Mac OS browser. Some functionality like editing DAX measures is not supported in the browser.

Internet Connection

  • A high-speed broadband internet connection will be required for processing activation, usage of Web Modeller (including access to the knowledge base), Excel Integration and Power BI Service reports.

Excel Add-on

 

Excel Integration

Supported versions:

  • Excel as part of the Office 365 suite (any edition)
  • Excel as part of the Office 2016
  • Excel as part of the Office 2013
  • Power Pivot: To use the local data model you will require an office edition that includes Power Pivot. For more detailed information Click here and to find out what version of office you are using  click here

Note: Latest version of the OLAP Libraries is normally installed with Power BI and Excel 2016. For earlier versions, or if missing, these libraries can be downloaded and installed from here: https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers

Warning: if you would like to use our Power Pivot template reports, be aware that Power Pivot is not supported in Mac OS X

Acterys Apps

 
Xero User Rights The user connecting Xero to Acterys will require Standard user permissions.

Acterys On-Premise Server Requirements

Component

Requirements

Windows Server

Software requirements:

  • Windows Server 2012 and later with IIS installed
  • The default communication happens through HTTPS protocol through port 80. The port can be changed if needed.
  • We recommend a server with at least 8GB of RAM

Hardware requirements:

  • CPU: Minimum of 4 Cores
  • RAM: Minimum of 8 GB
  • Disk: Minimum 10 GB free hard disk space

Internet Information System (IIS)

  • Version 8.5 and above

Microsoft SQL Server

  • 2017 Standard Edition and above

Microsoft Active Directory

  • A master account will be required for the Acterys application to communicate with the Active Directory
  • The intended Acterys users need to have been registered on the Active Directory

On-Premise Power BI Report Server (Optional)

If the reporting component needs to be installed on an on-premise server:

The requirements for Power BI Report Server can be found here: https://docs.microsoft.com/en-us/power-bi/report-server/system-requirements

 

Acterys Hybrid Installation Requirements (Using Acterys public API with your own SQL Server database)

Component

Requirements

Microsoft SQL Server

  1. If using an on-premise SQL server: 2017 Standard Edition and above
    1. We recommend a minimum of 4 Cores, 8 GB RAM, and 40 GH disk space for the main data files. (excluding the log files)
  2. If using an Azure SQL database: We recommend Azure SQL Standard / Premium tiers with at least 200 DTUs capacity or above.
  3. When the database is provided by the client, all the database administration tasks ate the responsibility of the client. Operations include but are not limited to:
    1. Maintenance of the SQL server.
    2. Adding and managing disk space.
    3. Management of the transaction logs
    4. Backup and Restore policies of the database
    5. Monitoring the disk size and shrinking the log files when necessary
    6. Adding and management of database users/roles (these are not the same as Acterys users/roles which are managed through the Acterys Modeller)
  4. If you like to use your own database you can set it up by following the instructions on this page: How To Use Your Own Azure SQL (Or On-Premise) Database
 

 

Acterys Data Model Requirements

Component

Requirements

Microsoft SQL Server Database

The following characters are NOT allowed in field names, neither in the physical column name, view nor semantic layer (e.g. Power BI): ".", ":","[", "]"