Best practices for Data Lineage

Dataedo allows you to document the lineage of your data manually for various elements of your systems that were not imported automatically (such as tables or stored procedures). You can use manual objects to represent different elements of your information systems - application forms, APIs, files, sensors, etc. In this article, I will show you how you can document a web/application form as input of data into a table.

Create form object

First, we need to create a manual object that will represent a form:

1. Create manual documentation that will represent your application/website.
2. Create a manual procedure of the "Form" type.
3. Define its fields as parameters (data type is optional).
4. Save the new object.

Define Lineage and field mapping

Now that you have a form in your catalog, you can define its data lineage.

1. Go to the Data Lineage tab.
2. Add this form as Inflow of the Default process.
3. Add the table that the form is writing to as Outflow (use the search option to find your table).
4. In the Columns form, define field/column mapping (this step is optional).