DBA xPress System Requirements

Hardware Requirements

Hardware Requirements

The following memory and processor requirements apply to all editions of DBA xPress:

ComponentMinimum RequirementRecommended Requirement
Memory 4 GBAt least 8 GB
Processor Speed1.4 GHz2.0 GHz or faster
Processor TypeNot ApplicableAny x64 Processor

Note:  Hardware requirements can vary based on workloads and other processes.

Software Requirements

Software Requirements

  • SQL Server Integration Services 2012, 2014, 2016, 2017 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 the SentryOne Workbench:

 64-bit (x64) Operating Systems32-bit (x86) Operating Systems
Windows Server 2003 (at least Service Pack 2) *Windows XP (at least Service Pack 3) *
Windows Vista (at least Service Pack 2)Windows Server 2003 (at least Service Pack 3) *
Windows Server 2008 R2Windows Vista (at least Service Pack 2)
Windows Server 2012Windows Server 2008 R2
Windows Server 2016Windows Server 2012
Windows 7Windows 7
Windows 8Windows 8
Windows 10Windows 10

Important:  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.

Required Permissions

Required Permissions

Many of the features within the SentryOne Workbench only need db_owner for database updates when upgrading from an older version to a newer version. Outside of database updates, you only need db_datareader and db_datawriter permissions. 

The following is a comprehensive list of each feature and their required permissions:

DBA xPress Required Permissions

TechnologiesRequired Permissions
Data Inspector, Data Space Analyzer, Data Surf, Object Browser, Schema Surf

Each object being manipulated:
  • db_datareader
  • db_datawriter
Schema Inspector, Schema Inspector Snapshot Tool

Each object being manipulated:
  • db_owner
Workbench

System Requirements for other Workbench Products

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

64-bit Operating Systems32-bit Operating Systems
Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 (or later) x64Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 (or later) x86
Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x64Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x86
Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x64Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x86
Microsoft ® SQL Server ® 2012 (or later) Transact-SQL ScriptDom x64Microsoft ® SQL Server ® 2012 (or later) Transact-SQL ScriptDom x86
Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 (or later) x86
Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x86
Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x86
Microsoft ® SQL Server ® 2012 (or later) Transact-SQL ScriptDom x86

Providers

ProviderOperating Systems
Hive
64 bit Operating Systems32 bit Operating Systems
64-bit HortonWorks Hive ODBC Driver32-bit HortonWorks Hive ODBC Driver
32-bit HortonWorks Hive ODBC Driver
SQL
64-bit Operating Systems32-bit Operating Systems
Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x64Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x86
Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x86
SSAS
64-bit Operating Systems32-bit Operating Systems
Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x64Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x86
Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x86
  • Microsoft ® .NET 4.5 is required by SSAS 2017 Only.
  • SSAS Azure Analysis Services:
    • Microsoft Azure Analysis Services Client Libraries
SSIS
  • Microsoft ® .NET 4.5 (Required by SSIS 2017 Only)
  • Each version of SQL Server Integration Services (2012 or later) that you want to document.
  • SQL Server Data Tools or Business Intelligence Development Studio.
  • Any Third-Party Products (Connection Managers, Tasks, Components, etc) that are used within the SSIS Package(s)
SSRS
  • At least one version of SQL Server Reporting Services (2012 or later) that you want to document.
  • SQL Server Data Tools or Business Intelligence Development Studio.
  • Support provided for the following report locations:
    • File System: SQL Server 2012 or later
    • Native Web Services: SQL Server 2012 or later
    • SharePoint Web Service: SQL Server 2012 or later
Informatica PowerCenterIf connecting to a SQL Repository:
64-bit Operating Systems32-bit Operating Systems
Microsoft ® SQL Server ® 2012 Shared Management Objects x64Microsoft ® SQL Server ® 2012 Shared Management Objects x86
Microsoft ® SQL Server ® 2012 Shared Management Objects x86
If connecting to an Oracle Repository:
64-bit Operating Systems32-bit Operating Systems
64-bit Oracle Data Access Components (ODAC) 12c
  • 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
  • 32-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
  • 32-bit Oracle 12c Managed Data Access Client installed into the GAC

Unsupported:

  • SSAS, SQL, SSIS, and SSRS versions 2008 R2 and earlier are no longer officially supported. The providers remain accessible in the software if the prerequisites are met, however, we will not be able to provide support for any issues that are specific to these older releases.
  • Hive, Informatica, and Oracle have been deprecated. No additional updates or support are available for these providers.

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

BI xPress extension for Visual Studio 2015 requires:

  • An installation of one of the following editions of Visual Studio:
    • Visual Studio 2015 Community Edition        
    • Visual Studio 2015 Professional
    • Visual Studio 2015 Enterprise
  • The following extension installed within their Visual Studio 2015 environment:
    • SQL Server Data Tools for SQL Server 2016 (now includes BI Projects)

Plug-ins:

  • Auditing Framework, BI Compare, Package Builder Wizard, and/or SSIS Unit Test:
    • Any Third-Party Products (Connection Managers, Tasks, Components, etc.) that are used within the SSIS Package(s)
  • Report Mover
    • Reporting Deployment is compatible with SQL 2012 or later
  • Report Monitoring Console:
    • Reporting Performance Monitor is compatible with SQL Server 2012 or later

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

  • SQL 2012 or later is required to create a DOC xPress metabase.

Note:  If you're 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.