AX Server requirements

For the best AX Server performance, ensure your hardware and software meet the minimum requirements. Satisfactory production environment performance may require greater resources than the minimum specification.

Hardware

Processor, memory, and hard disk requirements for production systems depend on the following factors:

  • the number of concurrent users and their usage profiles
  • the size of the data payload
  • the desired response time
Component Minimum Recommendation

Processor

2.5 gigahertz (GHz)

Quad-core processor (or two Dual-core processors) at 3.5 GHz or higher

Memory (RAM)

8 GB

16 GB or higher

Hard disk

100 GB

This is the approximate amount of disk space required to download, extract, and install the prerequisites. (AX Server is 4.5 GB)

200 - 500 GB

Data storage requirements vary by the number of types of audit tests performed and the volume of transactions. Smaller implementations typically require 50GB per year, while larger implementations may require up to 500GB per year.

For use in production, high-speed disk access and throughput is recommended.

Other

TCP/IP connectivity. The ability to connect to Launchpad is required during online server activation.

 

Software

Software requirement Minimum Recommendation
Operating system
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012 R2

Note

Apply all critical Windows updates before installing AX Server or AX Engine Node. Running Windows Server using the Server Core (no GUI) option is not supported.

Windows Server 2012 R2

Windows Server 2016 or 2019

Caution

If you install AX Server or AX Engine Node on Windows Server 2012 R2, you must install the KB2919355 Windows Update first.

If you do not install the Windows update first, your AX Server or AX Engine Node installation cannot succeed.
Oracle connector

To use the ACL Connector for Oracle, you must install:

  • Oracle Instant Client 11g or 12c
  • You do not need to install Oracle Instant Client if you do not intend to use the ACL Connector for Oracle
  • The bitness of Oracle Instant Client must match your operating system's bitness. If the 32-bit Instant Client is installed on a 64-bit machine, the connection fails
  • If you install the Oracle Instant Client after AX Server, you must restart the ACL Analytics Exchange Service before you can use the connector
  • If you are using Oracle as the database server for AX Server, you must also install Instant Client on the machine that hosts the database server, see Database server
 N/A
Web browser
  • Chrome
  • Firefox
  • Internet Explorer

Internet Explorer version 11

Latest version of Chrome
Optional integrated programming languages

Python, 32-bit (optional)

To use Analytics functions that integrate with the Python programming language, you must install and configure Python on the server where AX Server is installed.

The following versions of Python have been tested and work with Analytics Exchange:

  • 3.4.x

  • 3.5.x

  • 3.6.x

For more information, see Configuring Python for use with AX Server.

Note

You do not need to install Python if you do not intend to use the Analytics Python functions.

Python 3.4.x

Any version of Python from 3.4.x onward should work with Analytics Exchange. However, versions other than those listed are not guaranteed to work.

R, 64-bit (optional)

To use Analytics functions that integrate with the R programming language, you must install and configure R on the server where AX Server is installed.

The following versions of R have been tested and work with Analytics Exchange:

  • 3.2.3

  • 3.2.5

  • 3.3.1

  • 3.3.2

  • 3.4.4

  • 4.0.3

You can use either CRAN R or Microsoft R.

If you are using one of the CRAN R packages, you may need to add the path to the R binary folder to the PATH environment variable on the server.

For example: C:\Program Files\R\R-<version>\bin\x64

Note

You do not need to install R if you do not intend to use the Analytics R functions.

 R 3.2.3

Versions of R other than those listed may also work with Analytics Exchange. However, they are not guaranteed to work.

Automatically installed prerequisites

The following prerequisites are automatically installed by the AX Server installer if the required software is not detected:

  • Amazon Corretto 8 (OpenJDK 8.292.10.1)
  • Apache TomEE 7.0.9
  • Microsoft .NET Framework 4.6.2

    Note

    If your computer already has .NET 4.6.0 or 4.6.1, the application uses the installed version of .NET and does not install version 4.6.2.

  • Microsoft Visual C++ 2019 Redistributable Package (x64 and x86)
  • Microsoft Visual C++ 2013 Redistributable Package (x64 and x86)
  • Microsoft Visual C++ 2012 Redistributable Package (x64)
  • Microsoft Access Database Engine 2016 (32-bit)

Python for machine learning commands

To enable Analytics machine learning commands, the AX Server installer installs the Python engine for Analytics (version 3.7.9).

Note

This instance of Python is not intended for use with the Analytics Python functions. You must install a separate instance of Python for this purpose, explained above.

Analytics data connectors

The ODBC drivers listed below are installed for use as Analytics data connectors:

Big Data and NoSQL
  • Amazon Athena
  • Amazon DynamoDB
  • Amazon Redshift
  • Apache Cassandra
  • Apache Drill
  • Apache HBase
  • Apache Hive
  • Apache Spark
  • Azure Data Catalog
  • Azure Data Lake Storage
  • Azure Table
  • Couchbase
  • Google BigQuery
  • MongoDB
  • Parquet
  • Presto
  • Snowflake
ERP and CRM systems
  • Concur
  • Dynamics 365 Business Central
  • Dynamics 365 Finance and Operations
  • Dynamics 365 Sales
  • Dynamics CRM
  • Epicor ERP
  • Exact Online
  • NetSuite
  • Salesforce
  • SAP
  • SAP ByDesign
  • ServiceNow
  • SugarCRM
Accounting tools
  • Dynamics GP
  • Dynamics NAV
  • QuickBooks
  • QuickBooks Online
  • QuickBooks POS
  • Sage 50 UK
  • Sage Cloud Accounting
  • Sage Intacct
  • SAP Concur
Marketing and analytics
  • Google Analytics
  • LinkedIn
  • Marketo
  • Oracle Eloqua
  • Oracle Sales Cloud
  • Splunk
  • SurveyMonkey
  • Twitter
Collaboration solutions
  • Active Directory
  • Airtable
  • AWS Data Management
  • Azure Management
  • DocuSign
  • Email
  • Excel
  • Excel Online
  • Exchange
  • Google Contacts
  • Google Sheets
  • Jira
  • SAP SuccessFactors
  • SharePoint
  • Slack
  • Zendesk
File and API integration
  • Amazon S3
  • Box
  • CSV
  • DigitalOcean
  • Dropbox
  • Google Drive
  • JSON
  • LDAP
  • Microsoft OneDrive
  • OData
  • REST
  • RSS/ATOM
  • SFTP
E-commerce solutions
  • Edgar Online
  • Open Exchange Rates
  • Square
  • Stripe
  • UPS
  • USPS
Relational databases
  • Azure Analysis Services
  • Cloudera Impala
  • Microsoft Access
  • Microsoft SQL Server
  • MySQL
  • Oracle
  • SAP Hybris Cloud for Customer
  • Sybase
  • Sybase IQ
  • Teradata
  • xBase
Security tools
  • Qualys
  • Tenable.sc
Other connectors
  • Rsam

Prerequisites included in Windows server

The following prerequisites are included in a default Windows server installation. The versions listed are the minimum requirement and most OS installations include later versions:

  • Microsoft Core XML Services (MSXML) 6.0
  • Microsoft Data Access Components (MDAC) 2.8
  • Microsoft Jet 4.0

Database server

AX Server supports two database platforms, Oracle and PostgreSQL.

Software requirement

Minimum

Recommendation

One of the following Oracle versions if Oracle is selected as the Analytics Exchange database platform:

  • Oracle 12c
  • Oracle 18c
  • Oracle 19c

    (Contact Support before using version 19c. Some features and configurations may not be supported.)

Note

The server that Oracle is installed on must meet the hardware requirements specified by the database vendor. You must also install Oracle Instant Client for your database version if you intend to use AX Connector direct database access.

Oracle databases running on Amazon RDS are supported.

Oracle RAC (Real Application Clusters) is not supported.

 Oracle 12c Oracle 18c

PostgreSQL 13.3-2 if PostgreSQL is selected as the Analytics Exchange database platform.

Note

If PostgreSQL is installed on the same server as AX Server, meeting the AX Server hardware requirements is sufficient. If PostgreSQL is installed on a separate server a 64-bit dual CPU, 64-bit operating system, and 2 GB of memory are recommended for production use.

 PostgreSQL 13.3-2 PostgreSQL 13.3-2

AX Server and AX Exception

If your organization is implementing both AX Server and AX Exception the supported configurations are:

  • both application databases using Oracle
  • configuring AX Server to use PostgreSQL as the database, and AX Exception to use Microsoft SQL Server as the database