One of the biggest obstacles in managing a database environment is continuously maintaining accurate, up-to-date documentation. Current documentation, including a clear understanding of the data's origin, is critical to ensure adherence to business rules.
Challenges data teams face in maintaining documentation include:
Significant time investment in maintaining up-to-date documentation, particularly in constantly changing environments
Difficulties tracking data lineage, a crucial step in ensuring compliance with data privacy regulations such as GDPR, CASL, and others
Frustrations with analyzing metadata to track how data has changed over time—and who has touched the data
SentryOne DOC xPress helps you efficiently and accurately document your entire Microsoft Data Platform environment, ensuring that your data systems support business rules and facilitate compliance with data regulations.
With DOC xPress, you can generate metadata dictionaries with detailed business annotations that help the organization better understand the source of data changes. The data lineage analysis feature helps you track data origin and understand the impact of changes across tables, databases, servers, packages, cubes, and reports. DOC xPress also includes a snapshot feature that helps you compare database versions over time.
Easily discover where data comes from, how it’s being used, and how changes to one object in your environment can impact other areas. With DOC xPress, you can visualize data dependencies, pinpoint the source of data in reports. Understanding data origin helps you ensure compliance with data privacy regulations such as GDPR, CASL, and others.
Streamline the process of collecting metadata from across your data estate. Automated scanning of metadata allows documents to be kept up-to-date with little to no interaction by users. With DOC xPress, you can capture important business information such as data timeliness and other attributes, add business definitions to items in the documentation, and create custom fields in the data dictionary.
Easily capture metadata snapshots so you can compare environments before and after changes. The metadata version comparison capability in DOC xPress records solution configuration, including information about sources, and maintains a version history chain. You can generate documentation based on a specific point in time, and track environment changes over time.
With DOC xPress, you can generate documentation in a variety of formats for SQL Server, SSAS, SSIS, SSRS, Excel, Hive and many more data sources. The Solution Wizard guides you through configuring the documentation, and you can document environments instantly, without waiting for sources to load. You can use built-in providers to import data or create your own custom providers.
Note: As of July 1, 2019, DOC xPress pricing is based on licensing by the targeted number of documentation sources (such as SQL Server, SSAS, Power BI, etc.) to reflect common buying scenarios. A hosted, cloud-based version will be available for preview in fall 2019.
The on-premises edition of DOC xPress is licensed by documentation source (such as SQL Server, SSAS, or Power BI instance), and covers up to 10 documentation target sources. To license more than 10 sources, contact email@example.com for an enterprise license quote. SentryOne Document, our cloud solution for documenting databases and analyzing data lineage, was introduced in Fall 2019.
You can! Click here to see a sample document.
The DOC xPress templates are used to lend form and reason to the output. They are fully customizable and control what information is included in the documentation.