BI xPress - Workforce Logic
"BI xPress has accelerated our development project by enabling rich configurable auditing and notification to our hundreds of packages without any code changes."
C. O'Connor

Data Warehouse Architect

Workforce Logic

BI xPress - Gary M
"Use of tools such as BI xPress and DOC xPress from Pragmatic Works are relatively inexpensive tools that do amazing things with SSIS. BI xPress is a must for making notification more friendly and providing real-time and historical monitoring of ETL."
BI xPress - Tech Data
"BI xPress has saved us an incredible amount of SSIS development time and allowed us to create new across the board development standards..."
Dave F.

Sr. SQL Server DBA

Tech Data

BI xPress - Peter Schott
"Finally got around to trial of BI xPress from Pragmatic Works - really wishing I'd done it a LOT sooner. Near real-time monitor==cool."
BI xPress - Severstal NA
"BIxPress has really helped us in our ETL and in streamlining our SSIS Packages.. This product is a thumbs up for anyone doing SSIS Packages."
Akhil Mahajan

Sr. Software Developer

Severstal NA, Greater Detroit Area

BI xPress - Verisk Health
"It’s such a cool and functionable tool/product mainly designed for the SSIS field."
Anil Maharjan

Software Engineer

Verisk Health, Nepal

 

 

Standard Edition
only $1095
Buy Now Free Trial Download Compare Editions
BI xPress

Audit, Notify, Deploy and Manage SSIS Packages

  • Quality - Create more efficient, reliable packages, cubes and reports.
  • Performance - Ensure your environment is performing well and not breaking best practices
  • Productivity - Never have to code the same code twice! Ensure team 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 with Service 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.

New Features
The data generation feature in BI xPress will give users the ability to generate random data into a table or group of tables, and populate tables using existing sources of data.
Read More
Quality
Allows users to write their own scripts and create their own rules.
Read More
Dataset testing in the SSIS unit testing feature gives users the ability to compare two different sets of data during a unit test.
Read More
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.
Read More
The Best Practices Analyzer inspects SSIS packages and displays recommendations based on best practices.
Read More
Insert Data Flow Nugget are data flow tasks that have been stored in SSIS packages and can be reused at any time.
Read More
BI Compare will show users the differences between two SSIS packages and show details on each object.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
Performance
The Best Practices Analyzer inspects SSIS packages and displays recommendations based on best practices.
Read More
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.
Read More
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.
Read More
Productivity
The Best Practices Analyzer inspects SSIS packages and displays recommendations based on best practices.
Read More
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).  
Read More
The Pragmatic Workbench is the common user interface for Pragmatic Works tools and offers several usability features. 
Read More
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
Read More
Insert Data Flow Nugget are data flow tasks that have been stored in SSIS packages and can be reused at any time.
Read More
BI Compare will show users the differences between two SSIS packages and show details on each object.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
Using Expression Manager, you can add/edit user defined expressions. User defined expressions are listed under "Snippets->My Expressions" node in the expression editor.
Read More
Find, rename, or delete unused variables. Find dependent objects for selected variables (e.g. Tasks, Precedence Constraints, Connections, Variables with expression, Configurations).
Read More
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.
Read More
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.
Read More
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).
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
Security and Compliance
The Best Practices Analyzer inspects SSIS packages and displays recommendations based on best practices.
Read More
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).  
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
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.
Read More
SLA Management
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.
Read More
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.
Read More
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.
Read More
Some Of Our Clients
Copyright 2014 by Pragmatic Works