Importing and exporting data translations

You can import and export data translations for mapped source and target columns.

About this task

It may be necessary to export a data translation when you know of multiple column mappings that require the same translation. Instead of manually specifying the translation for each column mapping, you can import the data translation and apply it for each column mapping.

When you import a data translation into Management Console, any existing translations are replaced with the imported translations.

To import a data translation

Procedure

  1. Click Configuration > Subscriptions.
  2. Select the subscription.
  3. Click the Table Mappings view and select the table mapping from the Source Table column.
  4. Right-click and select Open Details....
  5. Click the Translation tab.
  6. Select a mapped source and target column.
  7. Ensure that you have exported a data translation for this mapping.
  8. Click Import.
  9. Locate the CSV file and click OK.

To export a data translation

Procedure

  1. Click Configuration > Subscriptions.
  2. Select the subscription.
  3. Click the Table Mappings view and select the table mapping from the Source Table column.
  4. Right-click and select Open Details....
  5. Click the Translation tab.
  6. Select a mapped source and target column.
  7. Ensure that you have added a data translation for this mapping.
  8. Click Export.
  9. Save the data translation as a CSV file and click OK.