x

Manage Your Database and BI Metadata and Documentation Quickly and Efficiently

DOC xPress offers complete documentation for SQL databases and BI tools, while also enabling business and technical users to edit and annotate their technical metadata.

Watch 2 Minute Intro Video

Key Features and Benefits


Helpful Links

Priced From $395-$3995

Lineage and Impact Analysis

Easily discover where data comes from, how it’s being used and how changes to one object in your environment can impact other areas.

Learn more

Metadata Discovery Management

Automated scanning of metadata allows documents to be kept up-to-date with little to no interaction by users.

Learn more

Metadata Version Comparison

Easily capture and compare what environments look before and after their changes.

Learn more

Documentation

DOC xPress allows users to generate documentation in a variety of formats. Documentation can be created for SQL Server, SSAS, SSIS, SSRS, Excel, Oracle, Hive and much more!

Learn more

Server Edition

Brings the metadata capabilities of the desktop application to a web application that you host, make it much easier to share documentation, lineage and data dictionary information in your organization.

Learn more
Feature Standard$395 - Per User Pro$1,295 - Per User Pro + ServerMust Have Pro to Run Server
Lineage and Impact Analysis
Impact Analysis
Impact Analysis allows developers to save countless hours trying to assess how a change to one part of their environment will impact others by enabling them to explore the dependencies in their environments with ease.
Object Lineage
Data Object Lineage allows developers and DBA's to answer the question “Where did this data come from?” A huge time-drain for all types of developers and DBA's, whether focused on BI or not, is tracing the source of data within a system. Object Lineage enables users to explore the dependencies in their environment. Learn More
Metadata Discovery and Management
Data Dictionary
Data Dictionary gives users the ability to add extra information throughout the documentation that would be useful to business users.
Data Dictionary Import/Export
Data Dictionary Import/Export allows you to import and export to and from CSV files.
Metadata Viewer
DOC xPress will let you view metadata for any object in its documentation database. View this metadata in trees or sub-trees from the solution window or snapshot management window.
Role-Based Output
DOC xPress can generate documentation targeted toward a specific audience, such as developers or business analysts, or be customized for your needs.
Metadata Version Comparsion
Snapshot Comparison
Snapshot comparison allows developers to look at two snapshots taken by DOC xPress at different points in time and see what was different.
Snapshot Command Line Scheduler
The snapshot and documentation schedulers will provide a file that can be executed through a command line script that can be scheduled or used in third party integration.
Snapshot Management
Snapshot Management gives users an easy way to keep track of and maintain snapshots in the DOC xPress repository.
Snapshot Process
Snapshot Process takes a solution configuration and reads all sources, updating the stored snapshot and maintaining a version history chain. This includes SQL Server, Integration Services, and Analysis Services in the initial version.
Documentation
Document Generation Process
Document Generation Process allows users to generate documentation in a variety of formats. Documentation can be generated from the most current snapshot, or from any snapshot taken in the past. The generated documentation can even be customized for a variety of audiences.
Document Image Support
Documentation Image Support allows users to insert both pre-defined images generated by DOC xPress as well as custom images provided with the templates.
Import External Sources
DOC xPress gathers data using built in providers. In addition, users can develop their own providers for unsupported platforms such as Access or DB2.
Multiple Format Support
DOC xPress gives you five different choices for exporting your documentation: RTF, DOCX, HTML, HTML Frameset and CHM. Learn More
Solution Wizard
To simplify the creation of documentation, DOC xPress provides an easy wizard to walk users through creation of both snapshots and documentation.
Tableau Provider
Gives you the ability to snapshot and document Tableau Servers.
Technologies Supported
DOC xPress currently supports multiple technologies for documentation including SQL Server (DB/SSIS/SSAS/SSRS), Oracle, Hive, and Excel. Learn More
Server Only Features
In-Line Data Dictionary Edits
Visual Studio/SQL Server Data Tools Integration
Web-Based Client Access

Contact us to schedule Live Product Demos

(904) 413-1911

Send Email

FAQs

View All FAQs In Support

How are LegiTest and LegiTest Server licensed?

LegiTest is licensed per user, per machine where it is used. LegiTest Server is licensed per server instance, with unlimited client access licenses. Please contact sales@pragmaticworks.com for more information.

How is DTS xChange licensed?

DTS xChange is licensed per package conversion. Please contact sales@pragmaticworks.com for more information.

How is DBA xPress licensed?

DBA xPress is licensed per user, per machine where it is used. Please contact sales@pragmaticworks.com for more information.

How are BI xPress and BI xPress Server licensed?

BI xPress is licensed per user, per machine where it is used. BI xPress Server is licensed per server instance with 5 client access licenses included. A client access license is assigned to a single user. Additional client access licenses can be purchased. Please contact sales@pragmaticworks.com for more information.

How is Task Factory licensed?

Task Factory is licensed per server instance. There is no license necessary to use Task Factory in the Integration Services development environment (Visual Studio, SQL Server Data Tools, or Business Intelligence Developer Studio). Please contact sales@pragmaticworks.com for more information.

How are DOC xPress and DOC xPress Server licensed?

DOC xPress is licensed per user, per machine where it is used. DOC xPress Server is licensed per server instance with 5 client access licenses included. A client access license is assigned to a single user. Additional client access licenses can be purchased. Please contact sales@pragmaticworks.com for more information.

Does DOC xPress support encrypted packages and passwords?

Yes, DOC xPress supports SSIS projects and ISPAC that encrypt passwords. It also supports encrypted SSIS packages.

Does Task Factory support Salesforce TLS 1.2?

Yes, but in order to continue using the Salesforce features, you must upgrade to the latest version of Task Factory.  Click here for more information on Salesforce's upgrade to TLS 1.2.

What versions of Visual Studio is LegiTest compatible with?

LegiTest is only compatible with Visual Studio 2012 or 2013. If you are running on an older version, you will need to upgrade.

I already have testing software in place. Why do I need LegiTest?

Most testing software only tests certain aspects of data-centric development. LegiTest allows testing across all aspects of your development lifecycle, providing validation at each stage of development

Will LegiTest work with the systems I already have in place?

Yes. LegiTest easily integrates with existing systems. It can be incorporated into build processes such as MSBuild, TFS, TeamCity and much more.

Why should I care about testing?

Testing your data ensures you catch bugs early, reduce delivery time, reduce the cost of testing and provides provable assurances of the validity of the data. But most of all, testing just works. Testing ensures accurate code, and more importantly accurate data.

What versions of SSIS does DTS xChange work with?

DTS xChange only does conversions for SSIS 2005 or 2008.

Does DTS xChange do full conversions?

In many cases it can, however it is dependent upon the contents of the existing DTS package.

How can DTS xChange save time and money?

DTS xChange uses proprietary rule based engine to migrate DTS Packages to SSIS by applying best practices of SSIS. So by using DTS xChange you not only get higher migration success rate but you also get new features supported by SSIS (e.g. Event Handlers, Logging, XML Configuration Files etc.)

What are the system requirements for DBA xPress?
  • SQL Server Integration Services 2008, 2008 R2, 2012, 2014 or 2016
  • BIDS 2005, 2008, 2008 R2 (Business Intelligence Development Studio), or SSDT 2010, 2012 (SQL Server Data Tools)
  • Microsoft ® .NET 3.5 with Service Pack 1
  • Microsoft ® .NET 4.0
  • Microsoft ® Report Viewer 2005
  • Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86
What is the difference between BI xPress and DBA xPress? (DBA xPress is included in the Pro version of BI xPress)

DBA xPress is a suite of tools designed to aid the DBA with the management of their SQL Servers and data. BI xPress Pro includes DBA xPress with it.

Can I view a sample document?

You can! Click here to download a sample document. Having trouble viewing CHM files? Click here for instructions on how to view them.

What are the differences between DOC xPress Pro and Server?

DOC xPress Server makes it easier to share and explore documentation across the enterprise. It eliminates the need to install DOC xPress Pro to view documentation, do lineage analysis, and update data dictionaries.

What are the system requirements for DOC xPress?
  • SQL Server Integration Services 2008, 2008 R2, 2012, 2014 or 2016
  • BIDS 2005, 2008, 2008 R2 (Business Intelligence Development Studio), or SSDT 2010, 2012 (SQL Server Data Tools)
  • Microsoft ® .NET 3.5 with Service Pack 1
  • Microsoft ® .NET 4.0
  • Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86
Can I customize the way my documentation works?

The DOC xPress and DOC xPress Server templates are used to lend form and reason to the output. They are fully customizable and control what information is included in the documentation. For more information, click here.

What are the system requirements for Task Factory?
  • SQL Server Integration Services 2008, 2012, 2014 or 2016
  • BIDS 2005 or 2008 (Business Intelligence Development Studio) or SQL Server Data Tools (2012 or 2014)
  • Windows XP or later
  • Windows Server 2000 or later
What functions are available with Task Factory?

There are a number of functions available with Task Factory. Click here to view a complete list.

Can Task Factory be used with Azure?

Yes, Task Factory components can be used with Azure databases.

Can I get just one feature of BI xPress and not purchase the entire product?

BI xPress comes bundled and there is no way to only sell one feature of the product.

Can I make custom templates for the Notification Framework?

Yes, you can designate the reason for the message to go out and make your own custom message that you can share with others.

What are the system requirements for BI xPress?
  • SQL Server Integration Services 2008, 2008 R2, 2012, 2014 or 2016
  • BIDS 2005, 2008, 2008 R2 (Business Intelligence Development Studio), or SSDT 2010, 2012 (SQL Server Data Tools)
  • Microsoft ® .NET 3.5 with Service Pack 1
  • Microsoft ® .NET 4.0
  • Microsoft ® Report Viewer 2005
  • Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86
What are the differences between BI xPress Pro and Server?

BI xPress Server provides the ability to monitor SSIS package execution as well as Reporting Services, making it easier to provide access to this information without the need to install the full BI xPress Pro software.