Skip to main content Skip to complementary content

Exporting data profiling items

You can export data profiling items including analyses, database connections, patterns, and indicators, etc. from the current instance of the Studio to the root directory of another Studio or to archive files.

Information noteNote: The export operation from the Profiling perspective will only export the data profiling items listed in the DQ Repository tree view including analyses, reports, connection metadata and the patterns used by analyses for example. You can export Jobs with data quality components listed in the Repository tree view via an export operation done from the Integration perspective. When you export these Jobs, their dependencies are exported as well such as the patterns used by the data quality components and the connection metadata.

Before you begin

At least, one data profiling item has been created in the Profiling perspective.

Procedure

  1. Complete one of the following steps:
    • Right-click anywhere in the DQ Repository tree view and select Export Items; or
    • click the icon on the toolbar and select Export Items.
    The Export Item wizard is displayed.
  2. Select the root directory or archive file option and then click Browse... and browse to the directory/archive where you want to export the data profiling items.
  3. Select the check boxes of the data profiling items you want to export or use the Select All or Deselect All tabs.
    When you select and export items, specific behaviors are applied:
    Action Effects Further information
    Selecting an analysis check box All analysis dependencies including the metadata connection, the contexts and any patterns or indicators used in this analysis are selected by default. If you have an error message on top of the dialog box that indicates any missing dependencies, click the Include dependencies button. It automatically selects the check boxes of all items necessary to the selected data profiling analysis.
    Exporting analyses from a reference project All their items will be exported.
    Selecting items from a main project Items from the reference projects are available. Select them to export them. For example, when an analysis from a main project depends on a connection in the reference project, the connection is not selected in the Export item wizard. You must select it. Clicking the Include dependencies button has no effects in this case.
    For further information about reference projects, see Working with referenced projects.
  4. If required, select the Browse check box to have in the export list only the selected data profiling items.
  5. Click Finish to validate the operation.
    A progress bar is displayed to indicate the progress of the export operation and the data profiling items are exported in the defined place.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here