ADVIZOR Server AE Requirements
Platform
- Microsoft Windows Server 2012 (R2) (64-bit)
- Microsoft Windows Server 2008 (R2) (64-bit)
- Note: We do NOT support Windows Server 2003 (64-bit)
- IIS 7 or newer, installed and running prior to installation of the Microsoft .NET Framework
- For IIS 7 (Windows Server 2008), the following Role Services must be pre-installed:
- Common HTTP Features/Static Content
- Common HTTP Features/Default Document
- Common HTTP Features/Directory Browsing
- Common HTTP Features/HTTP Errors
- Application Development/ASP.NET
- Security/Windows Authentication (needed for secure configuration)
- Management Tools/IIS Management Console
- Management Tools/IIS 6 Management Compatibility/IIS 6 Scripting Tools
- For IIS 8 (Windows Server 2012) and later, the following Role Services and Features are also needed:
- Application Development/ASP.NET 3.5
- Application Development/ASP.NET 4.5 (or 4.6)
- .NET Framework 3.5 Features/HTTP Activation
- .NET Framework 4.5 (or 4.6) Features/WCF Services/HTTP Activation
- For IIS 7 (Windows Server 2008), the following Role Services must be pre-installed:
Hardware
- Any current server-class computer, with multiple x64 processor cores.
- At least 16GB of RAM is recommended.
Clients
ADVIZOR Analyst projects that have been published to ADVIZOR Server AE can be accessed and interacted with using the following clients:
- Any modern browser:
- Microsoft Internet Explorer 10 or 11
- Microsoft Edge (Windows 10)
- Google Chrome (Windows or MacOS)
- Mozilla Firefox (Windows or MacOS)
- Apple Safari (MacOS)
- The ADVIZOR iPad app, downloadable from the iPad App Store.
Estimating Server RAM Usage
ADVIZOR Server AE generally requires the same amount of RAM to open the first session of a project as ADVIZOR Analyst. Additional concurrent sessions share the data pool and typically increase the RAM required by 15-30% (depending on the type and number of charts in the published project), so the example project cited above might require 2 GB to support 10 concurrent sessions (550 MB + 9 * 150 MB). Note that an ADVIZOR Server AE session is normally recycled after 20 minutes of inactivity, so typical concurrent load is much less than a coordinated training session, for instance.
Databases Supported
In addition to text files, ADVIZOR Analyst, Analyst/X, Desktop Navigator, and Server AE can load data from the following types of databases:
- Microsoft Excel (XLS, XLSX) (not via ODBC)
- Microsoft Access (not via ODBC)
- SalesForce.com (except Server AE)
- Microsoft SQL Server (version 7.0 or later)
- Oracle (version 9i or later)
- ODBC interfaces to databases (NOTE: ODBC connections must be defined as "System DSNs" through Windows Control Panel prior to using them in ADVIZOR):
- Oracle ODBC driver - SQORA32.DLL
- Microsoft ODBC for Oracle - MSORCL32.DLL
- Microsoft SQL Server - SQLSRV32.DLL
- Pervasive drivers
- Pervasive ODBC Client Interface - W3ODBCCI.DLL
- Pervasive ODBC Engine Interface - W3ODBCEI.DLL
- MySQL driver
- MySQL ODBC 3.51 Driver - MYODBC3.DLL (MyODBC-3.51.11-2-win.msi - when used with MySQL version mysql-essential-4.1.13-win32.msi)
- MySQL 5 – MYODBC5.DLL
- Splunk
- Greenplum (DataDirect, DDGPLM25.DLL/IVGPLM25.DLL)
- HP Vertica (VERTICA_7.1_ODBC_3.5_64.DLL)
No other ODBC drivers are supported.