Software Requirements
Before installing BI xPress Server, make sure you meet the following system requirements:
• Internet Information Services (IIS) 7 or later with:
o Dynamic Compression installed
o Windows Authentication installed and enabled
• .NET 4.5.1 or later installed
• PowerShell 3.0 or higher installed
• SQL Server Integration Services 2008 R2, 2012, 2014, 2016, 2017
• BIDS 2008 R2 (Business Intelligence Development Studio) or SSDT 2010, 2012, 2014, 2015 (SQL Server Data Tools)
• Access to SQL Server 2008 or later instance
o BI xPress Server needs access to a SQL Server 2008 or later instance to install the following database:
■ Workbench Server User and Administration database
■ BI xPress database
The following operating systems are supported by BI xPress Server:
• 64-Bit (x64) Operating Systems:
o Windows Server 2008
o Windows Server 2012
o Windows Server 2016
o Windows 7
o Windows 8
o Windows 10
• 32-Bit (x86) Operating Systems:
o Windows Server 2008
o Windows 7
o Windows 8
o Windows 10
The following optional prerequisites are required to access some resources using BI xPress Server:
• Security
o Windows User account(s) that can be used to access databases, servers, and documentable objects within the user's organization
o SQL Server User account(s) to use for accessing BI xPress Server databases
• Auditing Framework
o Each version of SQL Server Integration Services that the user wishes to apply the auditing framework to.
o Any Third-Party Products (Connection Managers, Tasks, Components, et cetera) that are used within the SSIS Package(s)
Browser Support
• Supported Web Browsers
o Mozilla Firefox 29 or later
o Internet Explorer 8 or later
o Google Chrome 35 or later
• JavaScript must be enabled within the Web Browser for proper viewing of BI xPress Server
Software Requirements for other Workbench Server products:
The following optional prerequisites are required to access some resources using DOC xPress Server:
• Security
o Windows User account(s) that can be used to access databases, servers, and documentable objects within the user's organization
o SQL Server User account(s) to use for accessing DOC xPress Server databases
• Documentation
o CHM
■ HTML Help Workshop and Documentation
The following optional prerequisites are required to access some resources using DOC xPress Visual Studio Extension
• Visual Studio 2012
o Professional
o Premium
o Ultimate
• Visual Studio 2013
o Professional
o Premium
o Ultimate
• Visual Studio 2015
o Professional
o Premium
o Ultimate
The following optional prerequisites are required to access some resources using DOC xPress Remote Agent
• 64-bit Operating Systems:
o Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 x64
o Microsoft ® SQL Server ® 2012 Shared Management Objects x64
o Microsoft ® SQL Server ® 2012 Analysis Management Objects x64
o Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x64
o Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 x86
o Microsoft ® SQL Server ® 2012 Shared Management Objects x86
o Microsoft ® SQL Server ® 2012 Analysis Management Objects x86
o Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86
• 32-bit Operating Systems:
o Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 x86
o Microsoft ® SQL Server ® 2012 Shared Management Objects x86
o Microsoft ® SQL Server ® 2012 Analysis Management Objects x86
o Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86
• Providers:
o Hive:
■ 64-bit Operating Systems:
• 64-bit HortonWorks Hive ODBC Driver
• 32-bit HortonWorks Hive ODBC Driver
■ 32-bit Operating Systems:
• 32-bit HortonWorks Hive ODBC Driver
o Oracle:
■ 64-bit Operating Systems:
• 64-bit Oracle Data Access Components (ODAC) 12c
o 64-bit Oracle 12c Managed Data Access Client installed into the GAC
• 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio 12c
o 32-bit Oracle 12c Managed Data Access Client installed into the GAC
■ 32-bit Operating Systems:
• 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio 12c
o 32-bit Oracle 12c Managed Data Access Client installed into the GAC
o SQL:
■ 64-bit Operating Systems:
• Microsoft ® SQL Server ® 2012 Shared Management Objects x64
• Microsoft ® SQL Server ® 2012 Shared Management Objects x86
■ 32-bit Operating Systems:
• Microsoft ® SQL Server ® 2012 Shared Management Objects x86
o SSAS:
■ 64-bit Operating Systems:
• Microsoft ® SQL Server ® 2012 Analysis Management Objects x64
• Microsoft ® SQL Server ® 2012 Analysis Management Objects x86
■ 32-bit Operating Systems:
• Microsoft ® SQL Server ® 2012 Analysis Management Objects x86
■ SSAS Azure Analysis Services:
• Microsoft Azure Analysis Services Client Libraries
o SSIS:
■ Each version of SQL Server Integration Services (2005 or above) that the user wishes to snapshot.
■ SQL Server Data Tools or Business Intelligence Development Studio.
o SSRS:
■ Each version of SQL Server Reporting Services (2005 or above) that the user wishes to snapshot.
■ SQL Server Data Tools or Business Intelligence Development Studio.
■ Support provided for the following report locations:
• File System: SQL Server 2005 and above
• Native Web Services: SQL Server 2008 R2 and above
• SharePoint Web Service: SQL Server 2008 R2 and above
o Informatica PowerCenter:
■ If connecting to a SQL Repository:
• 64-bit Operating Systems:
o Microsoft ® SQL Server ® 2012 Shared Management Objects x64
o Microsoft ® SQL Server ® 2012 Shared Management Objects x86
• 32-bit Operating Systems:
o Microsoft ® SQL Server ® 2012 Shared Management Objects x86
■ If connecting to an Oracle Repository:
• 64-bit Operating Systems:
o 64-bit Oracle Data Access Components (ODAC) 12c
■ 64-bit Oracle 12c Managed Data Access Client installed into the GAC
o 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio 12c
■ 32-bit Oracle 12c Managed Data Access Client installed into the GAC
• 32-bit Operating Systems:
o 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio 12c
■ 32-bit Oracle 12c Managed Data Access Client installed into the GAC
The following optional prerequisites are required to access some resources using LegiTest Server:
• Scheduling Test Assemblies
o MSTest Suites: Microsoft Visual Studio 2013 or Agents for Microsoft Visual Studio 2013
o NUnit Test Suites: NUnit Test Console
o Any software requirements (SSIS, SSAS, et cetera) used by LegiTest needed to execute a deployed test suite