BI xPress: Real-Time Monitoring and Notifications for SSIS Packages

 Free Trial                                            Buy

Want a better, faster way to manage Microsoft SSIS data packages?

Accurately managing data packages can consume significant time and resources from data teams, causing bottlenecks in efficient deployment:

  • Combing through error messages when data packages fail is time-consuming and often unproductive

  • Capturing errors often means developing custom-built event handlers, requiring additional resources

  • Troubleshooting data package performance in production can be difficult

 

If you manage a constantly changing data environment with continuous ETL processes, you need an efficient way to deploy, audit, and monitor SSIS data packages.

BI xPress accelerates SSIS data package management

 

BI xPress helps data pros efficiently manage SSIS data packages from development through production, ensuring speed and accuracy of data-centric apps:

  • Quickly build data packages and eliminate repetitive coding tasks

  • Ensure data packages run as expected and monitor their execution with an auditing framework

  • Use detailed reporting to monitor package performance and proactively take corrective action

 

BI xPress is essential for managing, auditing, and deploying SSIS data packages 

The Package Deployment Wizard in BI xPress gives users more options when deploying SSIS packages. Users can deploy multiple packages at once without having to deploy an entire project.

Explore how BI xPress helps you manage and monitor SSIS data packages

BI xPress Auditing and Monitoring

Audit and monitor SSIS packages

Ensure your SSIS packages run as expected and monitor their execution. With BI xPress, you can use the SSIS Monitoring Console to view real-time monitoring metrics, performance data, and execution trends. Take advantage of additional detailed reporting to oversee package performance and proactively take corrective action. Plus, you can use the Notification Framework Wizard to create notifications based on package execution so you'll always know the status of your data packages.

Learn more

Improve SSIS package performance

The Best Practices Analyzer inspects SSIS packages and displays recommendations for increasing data package performance based on best practices. The analyzer displays findings in a graph with total violations categorized by errors, performance tips, warnings, and other information—all of which you can store in the auditing database.

 

Learn more

Easily edit the auditing framework 

With BI xPress the Auditing Framework Wizard will allow you to add, remove, or edit the auditing framework for each of the packages in the solution you are currently working in. You can specify auditing database connection information, generate configuration files for the packages, and specify logging options.

 

Learn more

 

Use templates to build packages

The Package Builder Wizard in BI xPress helps you avoid tedious programming by supplying package templates that you can modify based on selected tasks. The package builder wizard provides 150+ templates that you can use to quickly create similar packages and includes capabilities for handling sensitive data as you're building templates.  The templates are fully customizable, giving you the ability to edit objects, connection strings, and other properties. 

 

Learn more 

Save time building SSIS packages

Quickly build packages, avoid repetitive work, and take advantage of many development accelerators, all integrated into your familiar BIDS/SSDT development environment. With BI xPress, you an easily compare SSIS packages, quickly compile scripts, and create complex MDX calculations with just a few clicks. With the Secure Configuration Manager, you can create secure configurations and add or edit configuration values. 

Learn more

BI xPress Developer Productivity
BI xPress Data Generation

Quickly create test data

Quickly create test or sample data in your SQL Server databases. With BI xPress, you can work with randomly generated data or take advantage of the built-in data lists to generate realistic test data. Leverage your existing data to help generate data that matches your expected values. You can generate data for a specific table or an entire database, and create randomized data to protect sensitive data.

Learn more

Share reports with web-based Server Edition

Get the monitoring and management features of BI xPress in a web-based server solution. Easily monitor SSRS reports and SSIS packages, dive into performance trends and notify users when packages succeed or fail.

Learn more

BI Express Server Edition

BI xPress Buying Options

Standard

Annual Subscription License

$545

Per User / Per Machine
Includes annual maintenance

Buy
 

Increases productivity & reporting

Pro

Annual Subscription License

$845

Per User / Per Machine
Includes annual maintenance

Buy
 

Also includes DBA xPress

 

Server

Annual Subscription License

$1,995

Per Server
Includes annual maintenance

Buy
 

Frequently Asked Questions

 

How are BI xPress and BI xPress Server licensed?

BI xPress is licensed per user, per machine where it is used. BI xPress Server can support up to 1000 users (if hardware permits). Please contact sales@sentryone.com for more information.

Can I get just one feature of BI xPress and not purchase the entire product?

BI xPress comes bundled and there is no way to only sell one feature of the product.

Can I make custom templates for the Notification Framework?

Yes, you can designate the reason for the message to go out and make your own custom message that you can share with others.

What are the system requirements for BI xPress?

  • SQL Server Integration Services 2008, 2008 R2, 2012, 2014 or 2016
  • BIDS 2005, 2008, 2008 R2 (Business Intelligence Development Studio), or SSDT 2010, 2012 (SQL Server Data Tools)
  • Microsoft ® .NET 3.5 with Service Pack 1
  • Microsoft ® .NET 4.0
  • Microsoft ® Report Viewer 2005
  • Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86

What are the differences between BI xPress Pro and Server?

BI xPress Server provides the ability to monitor SSIS package execution as well as Reporting Services, making it easier to provide access to this information without the need to install the full BI xPress Pro software.