Data Entity exports do not show field data types, lengths and attributes. It also does not show a logical relationship for the related tables/entities. We have been asked by almost every client to provide these details up front so they can map their source data without trial and error. What we found is that once an initial export is completed this data is populated in the table
you can access this with a specific environment at using this url template.
We were able to extract the necessary details from this table manually in SQL. Using this data, we created the attached sample workbook. We would like to add a feature to automatically generate this workbook from the Data Management Workspace without manual intervention. That would include:
1) Summary Workflow Sheet
2) Logical Data View - Context Diagram
3) Data Model with field data types, lengths, descriptions, help text, etc from the example
4) Sample data extract tab
DM - 006 - Customers-Example