Helping Customers Track Data Origin
Published On: March 27, 2019
Categories: Data Lineage, DOC xPress, Database Documentation, DevOps 0
Knowing the source of business data is critical in an era of increasing data privacy regulations. With the number of data sources rapidly and continually expanding for most companies, the challenges of establishing the source of data—and potential repercussions of data source changes—isn’t likely to ease up any time soon.
You can provide your customers with significant value, saving them time and money, by offering an easy way to fully document a database, including data lineage. Understanding the source of data, and how the source of data has changed over time, is critical to ensuring compliance with data privacy regulations such as GDPR, HIPAA, and CASL, as well as executing on established business rules.
Data lineage—tracing specific data back to its point of origin—provides a wealth of information for your customers, including:
- The original source of the data
- How the data relates to and interacts with other data (data dependencies)
- Information needed to support regulatory compliance
- Information needed to help diagnose broken SSIS packages or reports
- How the data source and structure has transformed over time
A clear view of data lineage means a clearer view of data sources and destinations. For many businesses—particularly large organizations that have many different data sources—finding the source of specific data and tracking data lineage changes can be time-consuming and frustrating. However, having clear visibility of where personally identifiable information (PII) is stored and used is crucial for complying with data privacy regulations such as GDPR, HIPAA, and CASL.
As diverse data sources and systems become bound together over time, working your way through the resulting maze of data can feel futile. Some companies even give up and simply create new data, a waste of resources and a source of added expense.
Difficulty tracing data lineage can even negatively affect your own business as a provider of technology solutions. Data is a crucial decision-making tool for every organization today. Frustrations caused by an inability to access requested data—say, broken reports that delay the sales forecasts or overly complex data structures that make it hard to comply with data privacy regulations—can fuel dissatisfaction with the company’s data-related products and services. And that can affect your bottom line.
Your customers’ DevOps and IT teams also depend on data lineage when launching new software development efforts. A clear view of the origin and transformation of data is especially important when so many technological innovations and revenue streams are based on new types of and uses for data.
Proper data lineage isn’t just about looking back. It's also about understanding what happens if an object is deleted, moved, or modified. How will that change affect other data? Will it break something else up or down the line?
The ability to trace dependencies in both directions can save developers and DBAs countless hours. And this approach encourages better data handling practices, which equate to happier customers in the future, too.
SentryOne DOC xPress simplifies the database documentation and data lineage process for your customers. With DOC xPress, they can easily determine where data originates, how it’s used, and the future impact of proposed changes.
The Object Lineage feature enables users to view lineage details throughout the path of an object. For example, they can explore a report field to determine the database in which it originates, the SSIS package that populated the column in that database, and so on. In this way, they can view the flow of data, right down to the column or component level. The feature provides both visual and textual views.
Another DOC xPress component, Impact Analysis, helps your customers look at the potential repercussions of changes they might be considering.
This feature enables dependency tracing in both directions so that users can determine both what an object depends on and which other objects depend on it. Users can more easily evaluate the impact of changes to database objects, SSIS packages, SSAS dimensions and cubes, and SSRS reports.
Want to dig deeper into automated documentation and data lineage and how DOC xPress can make the process faster and easier? Check out our free on-demand webinar, “Data Lineage and Documentation: How Changes Affect Your Environment.”
Nick (@nicharsh) is the Senior Vice President of Cloud Alliances for SentryOne and is responsible for leading the SentryOne relationships with Microsoft, Amazon Web Services, and other cloud providers. Prior to joining SentryOne, Nick was Vice President of National & Strategic Accounts for Dictaphone - Healthcare Division. Previous experience includes sales management positions with Computer Associates, NEC Computer USA, Tegra Varityper, and Heath/Zenith Computer Systems. Nick holds a BA degree in Economics from University of Dayton in Dayton, OH.