<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Pragmatic Workbench

The server version of Pragmatic Workbench contains DOC xPress Server, which gives you all the power of DOC xPress, through a web browser. It brings the metadata capabilities of the desktop application to a web application that you host, making it much easier to share documentation, lineage and data dictionary information in your organization.

In this post I’d like to give a quick walk through of the key features of DOC xPress: Data Dictionary, the Documentation Tool, Lineage Analysis and Snapshot Comparison.

    • We’ll start off on the main page of the DOC xPress Server. From a list of my solutions, I’ll use the one called Higher Ed for this example.
    • You’ll see I have several different documentation types that I’ve created using the Workbench tool, and I also have Solution Details such as the date it was created, the last snapshot and the last refresh.
    • First, let’s look at the Data Dictionary. Notice that the solution items have icons next to them, marking whether it has a data dictionary category, if there are edits pending or if there’s an edit that has yet to go through.
    • From here I can click on an item that has a data dictionary entry attached to it and fill in the value, hit Save Entry and it’s instantly added to my data dictionary inside of my DOC xPress repository.
    • Next up, the Documentation Toolset. When I go in here, any of the role-based documentation types I’ve created will be available.
    • I can easily go in and generate new documentation or simply utilize ones I’ve already created. For this instance, I already have some HTML framesets ones to use.
    • Some things I can do here is go in and dive through the hyperlinks or go into any of the different items inside the SQL stack and more, if I’ve done any kind of custom metadata import.
    • And the great thing about the Server is if I have any data dictionary entries available, I can scroll down to them inside the tool itself and easily add them.
    • Now let’s look at the Lineage Tool. Everything that’s available in DOC xPress is there like being able to change between low, medium and high level of detail to allow a high level of granularity in our search.
    • You can also choose to see all items based on the data lineage or the key and object dependencies and relationships, as well as see items with an inbound, outbound or bi-directional, in terms of the direction of focal objects.
    • And we can choose how we want the items to be spread out and how we want them to flow.
    • With the Server edition, another great feature with the Data Lineage tool is I can right click on anything and I can jump immediately to that documentation.
    • Finally, we have our Comparison tool. If we’ve been keeping a regimented schedule of our snapshots, we can see what has changed over time, such as the connection manager being altered, or new users have been added to a repository.

So, this was a very brief look at DOC xPress Server. DOC xPress Server gives you the ability to crowd source your documentation and data dictionary, as well as give your users an easy way to view the documentation that scales to thousands of company users. If you’d like to learn more about this Server version, or to download a free trial, visit our website or click the link below.

Try Workbench

Join Our Blog

Join thousands of other SQL Server, BI and cloud pros by subscribing to our blog.

Leave a comment

Posts by Topic

see all

Recent Articles

Popular Articles