Microsoft Dynamics 365 - Automatic Data Lineage

Wojtek Bialek - Dataedo Team Wojtek Bialek 17th July, 2024

What to expect

Views

Dataedo analyzes SQL of Dynamics 365 views with built in SQL Parser and builds column-level lineage from tables/views queried by view to the view.

Column-level lineage

Known Limitations

  1. Check the limitations for views lineage from SQL parser

Troubleshooting

I don't see data lineage for views

  1. Make sure you have selected right SQL dialect - in this case Transact-SQL (SQL Dialect field at Data Source level).
  2. Rerun import of the source - maybe schema was imported in older version or configuration was incorrect.