SQL Server Management Software - SSIS tool

Price starting at

$199

Buy Now Free Trial Download Compare Editions

BI xPress

Audit, Notify, Deploy and Manage SSIS Packages

Creates a robust auditing and notification framework for SSIS
Speed BI development with SSAS calculations and SSIS Package Builder
Make configuration and deployment of your SSIS environment a breeze

Speed up Microsoft business intelligence development and administration with BI xPress. BI xPress is a SQL Server Software 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. Product FAQs

Product Help Page Product Datasheet

	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.
	Read More

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

	BI Compare BI Compare will show users the differences between two SSIS packages and show details on each object.
	Read 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.
	Read 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 Schema Surf
	Read 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.
	Read 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).
	Read 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.
	Read 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.
	Read 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.
	Read 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.
	Read 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.
	Read 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.
	Read 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.
	Read More

	Pragmatic Workbench The Pragmatic Workbench is the common user interface for Pragmatic Works tools and offers several usability features.
	Read 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.
	Read 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.
	Read 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.
	Read 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.
	Read 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.
	Read 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.
	Read 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).
	Read 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.
	Read 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.
	Read 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).
	Read 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.
	Read More

Some Of Our Clients