Administrator Guide

10.5
- 10.4.1
- 10.4.0

Back Next

Import and Export Utility

Use the import and export utility to export objects from the

Data Integration Hub

repository to an XML file and import the objects from the XML file back to the

Data Integration Hub

repository. You can also use the utility to manage private keys that are used for authentication in SSH FTP connections.

For example:

Export objects from a test environment and then import them to the production environment.

Export object metadata for temporary backup.

Create, update, and delete private keys.

When you export objects with the utility, you create an export specification file to define the objects to export from

Data Integration Hub

. When you import objects with the utility, you create an import specification file to specify the objects to import and the conflict resolution for duplicate objects.

Consider the following information before you import or export files.

You cannot import files that were exported from versions of

Data Integration Hub

that are earlier than

Data Integration Hub

10.2.1 into later versions of

Data Integration Hub

You cannot import and export publications between different database types. For example, you cannot export a publication from a Microsoft SQL server repository and then import the publication into an Oracle server repository.

To import publications and subscriptions, the structure of the associated topic must be identical to the structure of the topic in the target system. When you import a publication or a subscription with an updated structure, you must apply the overwrite option to both the updated publication or subscription and to the associated topic, so that

Data Integration Hub

updates the topic structure accordingly.

To import an HDFS connection, the distribution version must be supported in the current release. You can update the distribution version in the export file before you import the connection.

To run the import and export utility, you must have the following permissions and privileges:

Read and write permissions for all objects.

Export privileges to run the export process and import privileges to run the import process.

To export and manage private keys, you must be logged in as an Administrator and must have the Use Key Aliases privilege.

If you do not have the required permissions and privileges,

Data Integration Hub

aborts the import or the export process, or the action that you try to perform on private keys.

You can export and import all objects or choose the export/import objects in a specification XML file. The utility exports or imports objects based on the information in the specification file. If you export objects with dependent objects, the export process exports the dependent objects to the export XML file.

Before you import a topic, verify that the storage location of the topic exists on the

Data Integration Hub

publication repository. On a Microsoft SQL Server database, the file group must exist. On an Oracle database, the table space must exist.

You can find the import and export utility in the following directory:

<Data Integration Hub Installation Directory>\dx-tools\

The directory also contains the export-all and import-all batch scripts. Use the scripts to export or import all objects. If you use the scripts, you do not need to create a specification file.

You can find sample specification files in the following directory:

<Data Integration Hub Installation Directory>\dx-tools\samples

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Import and Export Utility

Import and Export Utility