EOL: Bi xPress reached its end of life date on June 15, 2022. See the Solarwinds End of Life Policy for more information.
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:
64-bit Operating Systems | 32-bit Operating Systems |
---|---|
Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 (or later) x64 | Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 (or later) x86 |
Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x64 | Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x86 |
Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x64 | Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x86 |
Microsoft ® SQL Server ® 2012 (or later) Transact-SQL ScriptDom x64 | Microsoft ® 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 |
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.
Downloading Provider Files from Microsoft
Note: These instructions reference an external system from Microsoft and may appear differently than described below.
Download the additional provider requirements by completing the following steps:
1. Navigate to the Microsoft SQL Server 2012 SP4 Feature Pack.
2. Select the following additional files:
|
|
3. Select Next.
4. Select Download to install the selected components.
Success: You have now downloaded the additional provider requirements!
Required Permissions
BI xPress Minimum Permissions
The user account that is executing packages requires the following permissions to write data to the BI xPress repository database and trigger Notification Framework communications:
- The SQL Server instance where the BIxPress database is hosted needs the Connect securable for the SSIS execution account.
- For the BIxPress database level permissions on this instance, the account executing the packages must have Execute permissions.
Additional Information: See the Permissions (Database Engine) article on Microsoft Docs for details on the permissions.
Note: The permissions listed above are the minimum permissions required for the BI xPress Frameworks to function.
BI xPress 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:
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 |
|