| Feature |
Community Edition
FREE! |
Reporting Edition
$199 |
Standard Edition
$995 |
Professional Edition
$1495 |
| Free Live Demo! |
|
|
 |
|
 Best Practice Analyzer |
|
|
|
|
- The Best Practices Analyzer inspects SSIS packages and displays recommendations based on best practices.
|
|
|
|
|
 SSRS Reporting Performance Monitor |
|
|
|
|
- Monitor SQL Server Reporting Services (SSRS) Report execution history, data size, memory usage, threshold indicators and more via simple clickable charts.
|
|
|
|
|
 SSRS Report Deployment Tool |
|
|
|
|
- Easily copy SSRS Reports from one instance to another (in the same domain) simply by dragging-and-dropping reports. Quickly displays any warnings or errors, and even allow users to overwrite existing reports.
|
|
|
|
|
 MDX Calculation Builder Wizard |
|
|
|
|
- Create complex SSAS MDX Calculations in few clicks from any predefined MDX Calculation templates
|
|
|
|
|
 Secure Configuration Manager |
|
|
|
|
- Encrypt password/sensitive properties in XML or SQL Configuration Learn more
|
|
|
|
|
- SmartRename Refactoring to create shared configurations across hundreds of packages in few clicks.
|
|
|
|
|
- Create configurations for multiple packages at once
|
|
|
|
|
- Easy configuration value editor with bulk edit/search/filter functionality
|
|
|
|
|
 Package Builder Wizard |
|
|
|
|
- Create new SSIS packages from out of the box SSIS templates
|
|
|
|
|
- More than 90 predefined templates (e.g. FTP-SFTP, Email, Looping, Data Cleansing* and more)
|
|
|
|
|
- Share package templates with team using template libraries
|
|
|
|
|
- Create new template from existing SSIS package
|
|
|
|
|
- Modify existing ssis packages from controlflow selection
|
|
|
|
|
- Create new ssis package template from controlflow selection
|
|
|
|
|
- Modify existing ssis packages from existing template
|
|
|
|
|
- Modify existing ssis package templates
|
|
|
|
|
 SSIS Auditing Framework and Reporting |
|
|
|
|
- Modify SSIS package for Auditing Framework
|
|
|
|
|
|
|
|
|
|
|
- Scan packages for framework detection
|
|
|
|
|
- Log connection attributes (i.e.server,filepath,userid,database)
|
|
|
|
|
- Log SQL Query, Filename, Tablename used as source/target
|
|
|
|
|
- Variable Logging, Connection Manager Logging and Custom Logging
|
|
|
|
|
- Apply auditing framework to multiple packages
|
|
|
|
|
 SSIS Monitoring and Reporting |
|
|
|
|
- Report - Recent Execution
|
|
|
|
|
- Report - Running Packages
|
|
|
|
|
- Realtime Monitoring - ControlFlow and DataFlow Executions Learn more
|
|
|
|
|
- Report - Extract/Load Detail
|
|
|
|
|
- Report - Extract/Load trend by day, week, month and year
|
|
|
|
|
- Report - Package and task execution trend by day, week, month and year
|
|
|
|
|
- Report - SSIS Activity Dashboard
|
|
|
|
|
- Report - SSIS Package and Task level performance graphs Learn more
|
|
|
|
|
- Report - Errors and Warnings
|
|
|
|
|
|
|
|
|
|
|
 SSIS Package Deployment |
|
|
|
|
- Single click deployment of SSIS package to file system, SSIS Package Store or SQL Server (MSDB)
|
|
|
|
|
- Deploy SSIS package files, folders, project or solution
|
|
|
|
|
- Allow Bi-Directional deployment
|
|
|
|
|
- Allow configuration file deployment along with ssis packages
|
|
|
|
|
- Allow multi package selection for deployment
|
|
|
|
|
- Allow configuration file path change during deployment
|
|
|
|
|
- Allow checkpoint file path change during deployment
|
|
|
|
|
- Allow script compilation if binary code missing (Script Task/Script Component)
|
|
|
|
|
- Change package protection during deployment
|
|
|
|
|
|
|
|
|
|
|
 SSIS Notification Framework |
|
|
|
|
- Notify via Email on ssis package success, failure or completion
|
|
|
|
|
- Notify via SMS on ssis package success, failure or completion
|
|
|
|
|
- Notify via Log File on ssis package success, failure or completion
|
|
|
|
|
- Notify via Event Log on success, failure or completion
|
|
|
|
|
|
|
|
|
|
|
- Apply notification framework to multiple packages
|
|
|
|
|
 Development Productivity Tools |
|
|
|
|
- Sort packages in SSIS project by Name,Creation Date, Size and Last Modified Date
|
|
|
|
|
- Move/copy variables from one scope to another scope anywhere in the project (same or different package)
|
|
|
|
|
- Edit variable value or expression in single click (Multiline value is allowed)
|
|
|
|
|
- Highlight expression (object icon is changed with red dot)
|
|
|
|
|
- Highlight configuration (object icon is changed with blue dot)
|
|
|
|
|
- List objects with expression
|
|
|
|
|
- Advanced expression editor with snippet library (more than 25 expression snippets)
|
|
|
|
|
- Full screen (Ctrl + Enter)
|
|
|
|
|
- Compile all script tasks/Script components (package or entire project) in single click
|
|
|
|
|
- Quick Deploy Wizard - Single Click Deployment to predefined Target Location from BIDS Learn more
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 Script Snippet Library |
|
|
|
|
|
|
|
|
|
|
- File-Folder-Drive operations snippets
|
|
|
|
|
- Internet operation snippets
|
|
|
|
|
- Compress / Uncompress snippets
|
|
|
|
|
|
|
|
|
|
|
- Share script snippets with team using snippet libraries
|
|
|
|
|
 DBA xPress |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 Support Options |
|
|
|
|
- One year free upgrade to new features/bug fixes
|
|
|
|
|
- Priority support via webmeeting, phone, and email
|
|
|
|
|