Importing descriptions manually

Applies to: Dataedo 23.x (current) versions, Article available also for: 10.x

Dataedo Desktop has an import functionality that enables you to import description, title and custom fields into existing data dictionary.

To launch the feature right click on the database in repository explorer and choose Import descriptions.

Image title

There are two modes of import:

  • Importing table descriptions
  • Importing column descriptions

Importing table descriptions

To import table descriptions, choose Table objects.

Image title

Now select which fields you would like to import.

Image title

Click Copy headers button to copy template to text editor or spreadsheet.

Image title

Now, populate fields that you want to import. Schema and Table name columns will identify table you want to import into.

Image title

Image title

Copy table into clipboard and click Paste in the import wizard.

Image title

Data will be added to the grid. Dataedo will perform initial data validation:

  1. Were all the tables found?
  2. Are all the values valid?

If all the rows are green, click Next.

Image title

Dataedo will check current and new values and present them in a summary report that lists each field that might be updated and a checkbox to select if value should be imported:

  • New - field is empty and new value will be imported
  • Update? - there is an existing value in the field and new value will be updated (if checkbox is selected)
  • Erase? - there is an existing value in the field and import will erase value

Image title

By default, Update and Erase are not selected. To overwrite values, select the checkbox next to the field. You can also use Update all and Erase all options as shown below.

Image title

Importing column descriptions

Importing descriptions for columns works exactly like importing descriptions for tables, with the difference, that you have to include column name in the dataset.

Image title

To launch importing columns select Columns on the initial screen.

Image title

Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.