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

  BIDS 2005, 2008, 2008 R2 (Business Intelligence Development Studio) or SSDT 2010, 2012, 2014, 2016 (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.


System Requirements for other Workbench products:

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:

  Microsoft ® .NET 4.5 (Required by SSAS 2017 Only)

  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:

  Microsoft ® .NET 4.5 (Required by SSIS 2017 Only)

  Each version of SQL Server Integration Services (2005 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)


o   SSRS:

  Each version of SQL Server Reporting Services (2005 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


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 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


The following prerequisites are required to enable features within LegiTest:

  LegiTest extension requires:

oAn installation of one of the following editions of Visual Studio:

  Visual Studio 2012 Pro or better

  Visual Studio 2013

  Visual Studio 2013 Community Edition

  Visual Studio 2015

  Visual Studio 2015 Community Edition

  Visual Studio 2017


  NUnit Requirements

o   NUnit 2.6.4 is required to execute LegiTest NUnit tests outside of Visual Studio

o   NUnit Test Adapter 2.0 is required for LegiTest NUnit tests to be displayed within the Visual Studio Test Explorer


  SQL Server Assets

o   Supported Versions

  SQL Server 2008 R2

  SQL Server 2012

  SQL Server 2014

  SQL Server 2016

  SQL Server 2017


  SSIS Actions and Assets

o   Supported Versions

  SSIS 2008 R2

  SSIS 2012

  SSIS 2014

  SSIS 2016

  SSIS 2017

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

o   SQL Server Data Tools or Business Intelligence Development Studio

o   Microsoft ® .NET 4.5 (Required by SSIS 2017 Only)


  SSAS Actions

o   Supported Versions

  Multidimensional

  SSAS 2008 R2

  SSAS 2012

  SSAS 2014

  SSAS 2016

  SSAS 2017

  Tabular

  SSAS 2012

  SSAS 2014

  SSAS 2016

  SSAS 2017

o   Microsoft ® .NET 4.5 (Required by SSAS 2017 Only)


  SSRS Actions

o   Supported Versions

  SSRS 2008 R2

  SSRS 2012

  SSRS 2014

  SSRS 2016

  SSRS 2017