Dataedo enables importing (updating) descriptions to existing database documentation from Excel template.
What is it for
You can use it if you have descriptions for tables, views or columns in an Excel spreadsheet and don't want to copy & paste it into Dataedo editor.
- Excel 2007 or later,
- Direct access to repository database to run generated SQL statements.
Excel import works only with a server repository.
How it works
Excel template generates SQL update statements that need to be run in the repository database (SQL Server).
- Download the template (link below).
- Remove the sample data.
- Paste the table and column details in Type, Schema, Table/View and Column fields.
- Paste documentation title in the Documentation column (all rows).
- Paste descriptions in a Description column.
- Documentation - Title of the documentation (top level element in Dataedo repository) that will be updated. Must be unique.
- Type - Type of object, table or view: TABLE/VIEW.
- Schema - Table schema name.
- Table/View - Table or view name.
- Column - Column name.
- Description - Column description that will be updated in the repository.
- SQL - This field is autogenerated, please do not edit it.
- Copy SQL statements from SQL column (you can copy entire column). Perform it separately for tables/views and columns.
- Connect to your SQL Server repository database as a user with table update permissions (e.g. the user that created the repository).
- Execute the copied SQL statements.
Your descriptions have been updated. Run Dataedo and connect to your repository (or hit Refresh view) to view updated descriptions.
- This will overwrite descriptions that already exist in your documentation repository.
- Make sure the title of your documentation is unique.
- Tables and views are identified by Documentation, Type, Schema and Table/View fields. Those must be populated.
- Columns are identified by Documentation, Type, Schema, Table/View and Column columns. Those must be populated.
- The spreadsheet doesn't support new lines in descriptions.