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 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
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.
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.
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.
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.
Quickly build packages, avoid repetitive work, and take advantage of many development accelerators, all integrated into your familiar 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.
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.
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.
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 firstname.lastname@example.org for more information.
BI xPress comes bundled and there is no way to only sell one feature of the product.
Yes, you can designate the reason for the message to go out and make your own custom message that you can share with others.
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