BI xPress

Test, Audit, Notify, Deploy and Manage SSIS Packages. Prices Starting at $199

    Add To Cart Free Trial Download

  • Quality - Create more efficient, reliable packages, cubes and reports.
  • Performance -Ensure your environment is performing welland not breaking best practices
  • Productivity - Never have to code the same code twice! Ensureteam collaboration and reusability.
  • Security and Compliance - Never fear an audit or wonder what's running in your environment.
  • SLA Management - Track down a failure faster and recover in seconds not hours withService Level Agreement features.
Speed up Microsoft business intelligence development and administration. BI xPress is an SSIS and SSAS tool that integrates directly into Visual Studio for developers, and has a launcher application for DBAs who prefer to not work in BIDS. It allows you to quickly build packages, install robust auditing frameworks, and helps DBAs deploy packages. To find answers to common questions, please visit our Product FAQs page.

BI xPress Features

BI xPress Server-Beta

BI xPress Server brings the features of BI xPress to a web-based server solution. BI xPress Server delivers the monitoring console functionality to users without requiring a local desktop installation.

Learn More

Reporting Performance Monitor

To make monitoring and troubleshooting of SSRS reports easier, we have added a report dashboard. The report dashboard will display critical performance statistics related to SSRS reports. The Report Performance Monitor in BI xPress 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.

Learn More

Report Deployment Tool

Provides a way for users to move reports from one Reporting Services instance to another within their domain allowing easy-as-pie deployment of reports from a QA server to a production server simply by dragging-and-dropping reports.

Learn More

Auditing Framework Wizard

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

SSIS Monitoring Console

The 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. You can also view predefined reports that will display extraction and load details/trends, recent executions, any packages that may be currently running, package execution trends, execution dashboards, and execution alerts. The data in the reports can be filtered in a variety of ways, including; by date, package, machine, execution account, and execution mode.

Learn More

Notification Framework Wizard

The Notification Framework Wizard will allow you to create notification event handlers on events such as OnError, OnWarning, OnSuccess, and OnComplete 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.

Learn More

Snippet Wizard

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.  Some of the included tasks (snippets) that come with BI xPress are email, HTTP download, Windows registry access, XML, file compression, and much more.

Learn More

Package Deployment Wizard

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. A special ‘2 way deployment’ feature allows for copying packages from a target location to a source.

Learn More

Quick Deploy Wizard

The 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.

Learn More

Expression Highlighter

The 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

Package Builder/Template Wizard

The Package Builder option 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.

Learn More

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.

Learn More

Expression List and Expression Editor

The Expression List Plugin 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 (more than 25 snippets provided).

Learn More

Variable Edit

The Variable Edit Plugin opens Value Expression. If a variable is set to Evaluate As Expression then the BI xPress expression editor is displayed. 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

The 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

MDX Calculation Builder

This feature allows you to create complex MDX Calculations in a few clicks from several available MDX templates. This option is available when you are in the SSAS Cube Designer and the Calculations tab is active.

Learn More

BI Compare

BI Compare will show users the differences between two SSIS packages and show details on each object.

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

DBA xPress

DBA xPress provides next-generation SQL tools specifically tailored for performance and ease of use when architecting or administering large Microsoft SQL Server database systems. Contains Data Inspector, Data Space Analyzer, Data Surf, Schema Inspector, and Schema Surf

Learn More

Pragmatic Workbench

The Pragmatic Workbench is the common user interface for Pragmatic Works tools and offers several usability features. 

Learn More

SSIS Catalog Import

Allows organizations to import native SSIS 2012 Catalog logging data into the BI xPress repository.  Users can then view their packages within BI xPress’ SSIS Monitoring Console just as if they had instrumented their packages with BI xPress’ Auditing Framework.  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

Best Practices Analyzer

The Best Practices Analyzer inspects SSIS packages and displays recommendations based on best practices.

Learn More

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.

Learn More

SQL Server Data Tools 2012 Support

BI xPress is now supported in the Visual Studio 2012 / SQL Server Data Tools 2012 environment. This update updates the BI xPress add-in so that it supports working with the Business Intelligence project templates when they are used inside the Visual Studio 2012 environment.

Learn More

BI Data Testing

Dataset testing in the SSIS unit testing feature gives users the ability to compare two different sets of data during a unit test.

Learn More

User Defined Best Practices

Allows users to write their own scripts and create their own rules.

Learn More

SQL Server 2014 Support

This product is now compatible with SQL Server 2014.

Learn More

Data Generation

Data Generation will investigate a database table schema and offer the user some options about how to populate that column with data.

Learn More

Some of our clients