Notes
Note: BI xPress Version 2020.1.1 adds support for Visual Studio 2019 and SQL Server 2019.
Important: BI xPress no longer supports Business Intelligence Development Studio (BIDS). BI xPress no longer supports SQL Server Data Tools (SSDT) versions 2010, 2012, or 2013. You need to upgrade to SSDT versions 2015 or 2017 to continue using BI xPress for Visual Studio. BI xPress features that utilized BIDS or SSDT versions 2010, 2012, or 2013 only have been deprecated.
BI xPress System Requirements
The hardware requirements for BI xPress are based on your environment's deployment model. The following deployment models are available for BI xPress:
Deployment Model | Description |
---|---|
Single Machine | Workbench and the BI xPress database are installed on the same machine. |
Multiple Machines | Workbench and the BI xPress database are installed on different machines. |
BI xPress Single Machine Deployment
In the single machine deployment model, SentryOne Workbench and the BI xPress database are installed on the same machine. The SentryOne Workbench is the program that contains BI xPress and its associated assemblies while the BI xPress database is hosted within a SQL Server Instance.
The following memory and processor requirements apply to all editions of BI xPress:
Note: Hardware requirements can vary based on workloads and other processes.
Hardware Component | Minimum Requirements | Recommended Requirements |
---|---|---|
Memory | 4 GB | At least 8 GB. Note: You should increase your system's memory as the BI xPress database size increases for optimal performance. |
Processor Speed | 1.4 GHz | 2.0 GHz or faster |
Processor Type | N/A |
|
BI xPress Multiple Machine Deployment
In the Multiple Machine deployment model, the SentryOne Workbench and BI xPress database are installed on separate machines. The SentryOne Workbench is the program that contains BI xPress and its associated assemblies, while the BI xPress database is hosted within a SQL Server Instance.
Important: It's important to differentiate between the client machine and the server machine:
• Client machine is the machine where the SentryOne Workbench is installed.
• Server machine is the machine containing a SQL Server instance where the BI xPress database is deployed.
The following memory and processor requirements apply to all editions of BI xPress:
Note: Hardware requirements can vary based on workloads and other processes.
Client Machine Hardware Requirements
Hardware Component | Minimum Requirements | Recommended Requirements |
---|---|---|
Memory | 4GB | 6GB |
Processor Speed | 1.4 GHz | 2.0 GHz or faster |
Processor Type | N/A |
|
Server Machine Hardware Requirements
Hardware Component | Minimum Requirements | Recommended Requirements |
---|---|---|
Memory | 4 GB | At least 6 GB. Note: You should increase your system's memory as the BI xPress database size increases for optimal performance. |
Processor Speed | 1.4 GHz | 2.0 GHz or faster |
Processor Type | N/A |
|
BI xPress Software Requirements
Before installing the SentryOne Workbench, make sure that you meet the following requirements:
- SQL Server Integration Services 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019
- SQL Server Data Tools (SSDT) 2015, 2016, 2017, 2019
- 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 SentryOne Workbench:
64-bit Operating Systems | 32-bit Operating Systems |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Unsupported: 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:
Feature | Requirements |
---|---|
BI xPress extension for Visual Studio 2015, 2017, 2019 |
|
Auditing Framework, BI Compare, Package Builder Wizard, and/or SSIS Unit Test Plug-ins |
|
Report Mover |
|
Report Monitoring Console |
|
The following prerequisites are required to enable some features within BI xPress and DOC xPress:
Software Requirements for Providers
Provider | Operating Systems |
---|---|
SQL | |
SSAS |
|
SSIS |
|
SSRS |
Unsupported: 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. |
Unsupported: Hive, Informatica, and Oracle have been deprecated in BI xPress. No additional updates or support are available for these providers.
Required Permissions
Many of the features within SentryOne Workbench only need db_owner when issuing database updates 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:
BI xPress Required Permissions
Feature | Required Permissions |
---|---|
Best Practice Analyzer |
|
Data Generation |
|
Deployment Wizard (2005 and 2008) |
|
SSIS Unit Test |
|
SSRS Monitoring Console |
|
Monitoring Console |
|
SSIS Catalog Import |
|
Other Features |
|
Technology Specific Permissions
Technology | Required Permissions |
---|---|
Hive |
|
Informatica |
|
SQL Server |
|
SQL Server Integration Services |
|
SQL Server 2008 R2 (or higher) Reporting Services |
|
Oracle Permissions |
|
Tableau Permissions |
|