Copy&paste import

When to use copy&paste import

If your data source does not have a native metadata scanner and you either can export the metadata to a file or have preexisting documentation, consider pasting the metadata directly to Dataedo. Then our import will import this data.

Dataedo supports two ways of adding this data:

• Interface Tables
• copy&paste import.

Use Interface Tables when:

• it's more convenient for you to input data directly into the datatabase
• you don't intend to use and maintain the excel file
• you want to have ability to import the same database multiple times

Use copy&paste when:

• it's more convenient for you to use UI
• you have the data handy in excel
• in order to import the same database multiple times, you need to paste the data each time

Find copy&paste import

Start by adding New connection to your repository.

Paste Metadata can be found within the generic connector group.

Choose specific copy&paste connector

Use Paste Metadata for importing :

• tables
• procedures or functions

Use Paste Metadata Reporting for importing :

• reports
• datasets

Both connectors support:

• columns
• parameters
• linked sources
• triggers
• foreign keys
• unique keys
• data lineage
• data lineage processes

Copy headers to clipboard

Every tab has a own Copy template button.

Prepare your data

Paste the template into your spreadsheet and populate the cells.

Paste data into Dataedo

Each tab has its own Paste data button.

Correct your data if it fails validation

Every row needs to be valid to proceed with the import. Ensure data is correct by clicking Validate buttton or pasting data into tab. You can check for errors in the tooltip.

We recommend correcting the data in the Excel file first. Then, you can remove all rows by selecting all rows in Dataedo, pressing Ctrl + A, and then clicking the delete button. After that, paste the data again.

Import

Metadata will be uploaded to Interface Tables, and the import process will continue as usual. You can select additional import options or keep clicking the "Next" button.

Import changes

When importing changes to an existing database created by pasting. You must paste all the data again. Otherwise, objects existing in the documentation but not pasted will be marked as deleted.