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.
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.
Prerequisite(s): At least, one data profiling item has been created in the Profiling perspective of the studio.
To export data profiling items, do the following:
Right-click anywhere in the DQ Repository tree view and select Export Items.
Click the icon on the toolbar and select Export Items.
The [Export Item] wizard is displayed.
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.
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 an analysis check box, all analysis dependencies including the metadata connection and any patterns or indicators used in this analysis are selected by default. Otherwise, if you have an error message on top of the dialog box that indicates any missing dependencies, click the Include dependencies tab to automatically select the check boxes of all items necessary to the selected data profiling analysis.
However, when you export analyses from a reference project, only the analyses are exported without their items. For example, metadata connections are not exported with them and you must set the connection manually after exporting the analyses to make them work correctly. For further information about reference projects, see Working with referenced projects.
If required, select the Browse check box to have in the export list only the selected data profiling items.
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.