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 - 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 - 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 - 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 - Verisk Health
"It’s such a cool and functionable tool/product mainly designed for the SSIS field."
Anil Maharjan

Software Engineer

Verisk Health, Nepal



Buy Now Free Trial Download Compare Editions

BI xPress User Defined Best Practices

BI xPress now has the ability to accept user defined best practices. This can be used to ensure developers are adhering to not only common best practices, but also to specific rules defined only for specific groups.

Feature Highlights:

  • Add a set of custom best practices to the Best Practices Analyzer

User Defined Best Practices

User Defined Best Practices - Step 1
In the Workbench, click the Best Practices Analyzer tile.

In the Workbench, click the Best Practices Analyzer tile.

User Defined Best Practices - Step 2
There are two options; Create, or Analyze. Click Create.

There are two options; Create, or Analyze. Click Create.

User Defined Best Practices- Step 3
On the left side of the screen, click the plus sign to add a new rule.

On the left side of the screen, click the plus sign to add a new rule.

User Defined Best Practices - Step 4
On this screen, provide information about the rule, such as the rule name, severity, message and the recommendation.

On this screen, provide information about the rule, such as the rule name, severity, message and the recommendation.

User Defined Best Practices - Step 5
After providing the information about the rule, click the ellipses next to the ‘Path Evaluation’ field. This opens the path builder window.

After providing the information about the rule, click the ellipses next to the ‘Path Evaluation’ field. This opens the path builder window.

User Defined Best Practices- Step 6
First, click ‘Select a test object’ in the middle of the window. Browse to a package that will be used to create the rule. This should be a package with an example of the rule being violated. In this example, it’s a package that contains data flow tasks that were never renamed.

First, click ‘Select a test object’ in the middle of the window. Browse to a package that will be used to create the rule. This should be a package with an example of the rule being violated. In this example, it’s a package that contains data flow tasks that were never renamed.

User Defined Best Practices - Step 7
After selecting the package, the path builder displays a list of objects contained in the package.

After selecting the package, the path builder displays a list of objects contained in the package.

User Defined Best Practices - Step 8
In the list of Object Type Filters, select ‘Data Flow Task’. A list of data flows is populated in the object browser, and properties are displayed.

In the list of Object Type Filters, select ‘Data Flow Task’. A list of data flows is populated in the object browser, and properties are displayed.

User Defined Best Practices - Step 9
With one of the data flow tasks selected in the object browser, find the ‘Name’ property and click on the value in the Property Value field. This will display a path.

With one of the data flow tasks selected in the object browser, find the ‘Name’ property and click on the value in the Property Value field. This will display a path.

User Defined Best Practices - Step 10
Click and drag the path to the path builder field at the top of the window (underneath the BI xPress banner).

Click and drag the path to the path builder field at the top of the window (underneath the BI xPress banner).

User Defined Best Practices - Step 11
Next, open the Comparison operators to the right of the screen, and look for ‘Contains’.

Next, open the Comparison operators to the right of the screen, and look for ‘Contains’.

User Defined Best Practices - Step 12
In the path builder field, remove ‘==’ and drag and drop the ‘Contains’ operator in its place. Be sure to move the parenthesis and double quotes so that the path look like the following:

In the path builder field, remove ‘==’ and drag and drop the ‘Contains’ operator in its place. Be sure to move the parenthesis and double quotes so that the path look like the following:

User Defined Best Practices - Step 13
To the far right of the path builder field, click preview. Any object matching the selected options is displayed to the left.

To the far right of the path builder field, click preview. Any object matching the selected options is displayed to the left.

User Defined Best Practices - Step 14
Click ‘Close Preview’. This returns to the object filter window. Click the back arrow next to the BI xPress logo.

Click ‘Close Preview’. This returns to the object filter window. Click the back arrow next to the BI xPress logo.

User Defined Best Practices - Step 15
The ‘Path Evaluator’ field now has a value. Click OK to save the custom rule.

The ‘Path Evaluator’ field now has a value. Click OK to save the custom rule.

User Defined Best Practices - Step 16
Click the back arrow to return to the Best Practices Analyzer. When analyzing packages, the custom rule will be displayed in the Best Practices list.

Click the back arrow to return to the Best Practices Analyzer. When analyzing packages, the custom rule will be displayed in the Best Practices list.

User Defined Best Practices - Step 17
When packages are analyzed, violation of the user defined best practices are displayed in the same manner as the built-in best practices.

When packages are analyzed, violation of the user defined best practices are displayed in the same manner as the built-in best practices.

Naming Conventions

Naming Conventions - Step 1

Download a collection of User Defined Best Practices for naming conventions

This collection of user defined best practices can be used by you and your team to search for tasks and components that do not follow naming conventions as defined in Jamie Thomson's Suggested Best Practices and Naming Conventions.

Download a collection of User Defined Best Practices for naming conventions

This collection of user defined best practices can be used by you and your team to search for tasks and components that do not follow naming conventions as defined in Jamie Thomson's Suggested Best Practices and Naming Conventions.

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works