Software Requirements

Parent Previous Next


Software Requirements


Before installing Workbench, make sure you meet the following system requirements:

  SQL Server Integration Services 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017

  BIDS 2005, 2008, 2008 R2 (Business Intelligence Development Studio) or SSDT 2010, 2012, 2014, 2016, 2017 (SQL Server Data Tools)

  Microsoft ® .NET 3.5 with Service Pack 1

  Microsoft ® .NET 4.0

  Microsoft ® .NET 4.5 (2017 Providers only)

  Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86


The following operating systems are supported by Workbench:

  64-bit (x64) Operating Systems:

o   Windows Server 2003 (at least Service Pack 2) *

o   Windows Vista (at least Service Pack 2)

o   Windows Server 2008 R2

o   Windows Server 2012

o   Windows Server 2016

o   Windows 7

o   Windows 8

o   Windows 10

  32-bit (x86) Operating Systems:

o   Windows XP (at least Service Pack 3) *

o   Windows Server 2003 (at least Service Pack 3) *

o   Windows Vista (at least Service Pack 2)

o   Windows Server 2008 R2

o   Windows Server 2012

o   Windows 7

o   Windows 8

o   Windows 10


Important Note:

Windows XP and Server 2003 have been deprecated from full support. Any issues encountered on either Windows XP or Server 2003 must be reproducible on newer versions of Windows to be eligible for support.


The following prerequisites are required to enable some features within BI xPress:

  BI xPress extension for Visual Studio 2015 requires:

o   An installation of one of the following editions of Visual Studio:

  Visual Studio 2015 Community Edition        

  Visual Studio 2015 Professional

  Visual Studio 2015 Enterprise

o   The following extension installed within their Visual Studio 2015 environment:

  SQL Server Data Tools for SQL Server 2016 (now includes BI Projects)


  Plug-ins:

o   Auditing Framework, BI Compare, Package Builder Wizard, and/or SSIS Unit Test:

  Any Third-Party Products (Connection Managers, Tasks, Components, et cetera) that are used within the SSIS Package(s)


o   Report Mover

  Reporting Deployment is compatible with SQL 2008 R2 or later


o   Report Monitoring Console:

  Reporting Performance Monitor is compatible with SQL Server 2008 or later


The following prerequisites are required to enable some features within BI xPress and DOC xPress:

  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

  Microsoft ® .NET 4.5 (SSAS 2017 Only)


o   SSIS:

  Each version of SQL Server Integration Services (2008 R2 or above) that the user wishes to document.

  SQL Server Data Tools or Business Intelligence Development Studio.

  Any Third-Party Products (Connection Managers, Tasks, Components, et cetera) that are used within the SSIS Package(s)

  Microsoft ® .NET 4.5 (SSIS 2017 Only)


o   SSRS:

  At least one version of SQL Server Reporting Services (2008 R2 or above) that the user wishes to document.

  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


System Requirements for other Workbench products:

The following prerequisites are required to enable some features within DOC xPress:

  SQL 2008 or higher is required to create a DOC xPress metabase.

o   However, if connected to a valid DOC xPress metabase, SQL 2005 and up may be documented, though there are some limitations to SSRS 2005 and 2008 documentation.


  Documentation

o   CHM

   HTML Help Workshop and Documentation