BI xPress Server

Key Features of BI xPress in a Web-Based Server Solution for Only $2995!

Watch 2 Minute Intro Video

Key Features and Benefits

Easily share information about your BI systems with other departments and business users with BI xPress Server. BI xPress Server delivers the monitoring console functionality to users without requiring a local desktop installation. It integrates with the audit framework functionality provided from either the BI xPress Server or BI xPress Pro Edition to provide all the capabilities of the monitoring console in a web-based format that can be viewed on mobile devices. 

The server-based Auditing Framework allows your team to apply or remove the Auditing Framework from your SSIS 2012 and later projects (ISPAC files) within a web browser*. Enable your SSIS packages to come to life with more information such as performance metrics, data counts and detailed error messages. If you need to integrate the adding or removing of the Auditing Framework with other automated processes, you can take advantage of the Command Line tool for Auditing Framework, available with the BI xPress Server*.

The SSIS Monitoring Console allows your team to watch SSIS package execution down to the tasks and components for packages that contain our Auditing Framework. Control Flows within the Monitoring Console contain precedence constraints for nested tasks such as Sequence Container, ForEach Container and more. Also, tasks and components can now be moved around freely on the page in order to get a better view of some clustered items. No client-side software is required, just a web browser. 

Integrate the power of BI xPress Server into your SSIS Packages. The Notification Engine allows you to send notifications to multiple groups or individual people via email, SMS, log files, SQL Scripts, or even Twitter. You can also build your own notification provider to suit your own needs. The BI xPress Notification Engine is also a Visual Studio Team Services provider and includes a default template for creating VSTS notifications.

BI xPress Server is now a complete product for running SSIS packages through our easy-to-use dashboard reports. The dashboard also contains additional reports about the health and performance of your ETL processes. Brighten up your dashboard with customizable tiles that show how many packages have failed, succeeded, or generated warnings. Filter by package name and limit the duration to a time period of your choosing to further refine your dashboard and add as many tiles as you'd like.

* The Microsoft SQL Server SSIS runtime for the version(s) of SSIS you wish to support must be installed on the same machine as Workbench Server (which hosts BI xPress Server and DOC xPress Server).

Feature Reporting $199 - Per User Standard $1,095 - Per User Pro $1,695 - Per User Server $2,995 - Per Server Pro + Server
Best Practices Analyzer
Best Practices Analyzer inspects SSIS packages and displays recommendations based on best practices.
BI Compare
BI Compare will show users the differences between two SSIS packages and show details on each object.
Data Generation
Data Generation will investigate a database table schema and offer the user some options about how to populate that column with data.
DBA xPress
MDX Calculation Builder Wizard
This feature allows you to create complex MDX Calculations in a few clicks from several available MDX templates.
Package Builder Wizard
Package Builder helps you to build packages quickly from existing templates. There are 6 different options on the Package Builder Wizard screen. You can create/modify templates or packages using this option.
Script Snippet Library
Snippet Wizard is a tool that allows BI developers to insert pre-built and tested functionality into their SSIS packages. Users can insert a task or many tasks that are included with BI xPress or they can build their own for reuse in other SSIS packages.
Secure Configuration Manager
With the Secure Configuration Manager, you can create secure configurations and add/edit configuration values easily in just a few clicks. You can also generate multiple shared configurations for selected connections and adjust naming convention using the smart rename feature.
Auditing Framework Wizard
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.
Auditing Framework Command Line
Auditing Framework Command Line allows teams to integrate adding/updating/removing of Auditing Framework with their DevOps (Developer Operations) and build systems such as TFS (Team Foundation Services).
SSIS Monitoring Dashboard
SSIS Monitoring Console allows you to monitor current or past SSIS executions. You can use control flow diagrams to see package execution visually just like BIDS while you debug packages.
Notification Framework Wizard
Notification Framework Wizard will allow you to create notification event handlers on events for any of the packages in the current solution. You can also choose to be notified on your mobile device by specifying a phone number and service provider.
Notification Engine
Notification Engine allows you to send notifications to multiple groups or individual people via email, SMS, log files, SQL Scripts, or even Twitter. You can also build your own notification provider to suit your own needs.
Package Deployment Wizard
Package Deployment Wizard gives users more options when deploying SSIS packages. Users can deploy multiple packages at once without having to deploy an entire project.
Reporting Performance Monitor
Report Performance Monitor will give immense insight to the performance of SSRS reports. It compiles a multitude of stats into a concise dashboard that consists of four reports.
SSIS Unit Testing
Unit testing allows developers, users, and package lifecycle administrators to ensure that a package is performing exactly what the developer implemented and handling unexpected circumstances with predefined behavior. Unit testing allows specified inputs to be used as "source" data and evaluates the task output with expected task output thereby ensuring the package behaves correctly.
Report Deployment Tool
Provides a way for users to move reports from one Reporting Services instance to another within their domain allowing an easy deployment of reports from a QA server to a production server simply by dragging and dropping reports.
User Defined Best Practices
Allows users to write their own scripts and create their own rules.
Quick Deploy Wizard
Quick Deploy SSIS Package command allows you to deploy selected packages in one click using predefined target location selection. Unlike other wizards this wizard runs in a separate thread so you can work with BIDS while deployment is in progress.
Expression Highlighter
Expression Highlighter will point out the connection managers and variables that evaluate expressions. It will also indicate which connection managers are using configuration files. Learn More
Expression List and Expression Editor
Expression List lists all objects with expressions along with object name, property name and expression. You can edit each expression by clicking the edit link. BI xPress has a custom Expression Editor which has all of the features from the standard expression editor and a reusable expression snippet library. Learn More
Variable Edit
With the Variable Edit, you can easily edit multi-line text, which is not easily possible with standard BIDS functionality. Learn More
Variable Copy/Move to New Scope
Variable Copy/Move feature allows you to copy variables from one scope to another within the same or other packages with a single click. Learn More
Variable Dependency Scanner
Find, rename, or delete unused variables. Find dependent objects for selected variables (e.g. Tasks, Precedence Constraints, Connections, Variables with expression, Configurations). Learn More
Expression Manager
Using Expression Manager, you can add/edit user defined expressions. User defined expressions are listed under "Snippets - My Expressions" node in the expression editor. Learn More
Package Sorter
With this option you can sort packages listed under "SSIS Packages" node in the solution explorer. You can sort packages by name, size and date modified. Learn More
Compile Script Tasks/Components
When working with packages in a 64 bit environment that were originally created in 32 bit, BIDS may give errors stating “Binary script not found”. To fix this manually, one must open and close each script. BI xPress will allow developers to automate this process and save time by compiling every script within a project. Learn More
Quick Config Edit
Quick Config Edit allows you open existing configurations from XML files or SQL Table. You can edit, search and save your changes easily using this tool. Learn More
Insert Data Flow Nugget
Insert Data Flow Nugget are data flow tasks that have been stored in SSIS packages and can be reused at any time. Learn More
SSIS Catalog Import
Allows organizations to import native SSIS 2012 Catalog logging data into the BI xPress repository. Users no longer have to invasively alter their SSIS packages just to view them like they would within SQL Server Data Tools (SSDT). Learn More
SSIS Unit Command Line

Contact us to schedule Live Product Demos

(904) 413-1911

Send Email