Administrator Guide

10.5
- 10.4.1
- 10.4.0

Back Next

Export-All and Import-All Batch Scripts

Use the export-all and import-all batch scripts to export and import all objects in the

Data Integration Hub

repository. You do not need a specification file to export or import all objects.

By default, the export-all batch script does not export private keys that are associated with SSH FTP connections where the authentication type is

Authenticate with private key from key alias

. To export the private keys you must uncomment the element with the

keyalias

object in the export-all script.

You can find the batch scripts in the following directory:

<DIHInstallationDir>\dx-tools\

The following list describes the batch scripts.

export-all: Exports all objects from the
Data Integration Hub
repository to an export XML file. The script sets the import specification file to:
samples/export-all-specification-sample.xml
import-all: Imports all objects from the export XML file into the
Data Integration Hub
repository. The script sets the import specification file to:
samples/import-all-specification-sample.xml

The following list describes parameters and arguments for the export-all and import-all batch scripts.

-f or --file
: Argument: ImportFile or ExportFile

Required. Absolute path and file name of the object import file or export file. If you run the import command, this is the file from which to import objects. If you run the export command, this is the file to which to export objects.

If you uncomment the element with the
keyalias
object in the export-all script, this is the location of the private keys.
-u or --user: Argument: UserID
Optional. Identifier of the
Data Integration Hub
user account to use when the import and export utility accesses the
Data Integration Hub
repository.

The user account must have the following privileges:
Data Access permissions to all the data in the repository. The user must be a member of a user group for which the permission option
Grant read and write permissions to all categories
is selected.
Export Data. Required when you export objects.
Import Data. Required when you import objects.

If you use Informatica domain authentication or Informatica domain with Kerberos authentication, enter the full user ID in the following format:
user@domain
-U: Argument: Environment variable.
Optional. Environment variable that contains a user name.

User name of an Operation Console user account with Manage Data privileges to run the import or export command. To run the import command, the user account must have the Import Data privilege. To run the export command, the user account must have the Export Data privilege.

If you use Informatica domain authentication or Informatica domain with Kerberos authentication, the user name must specify the Informatica security domain, separated by the @ symbol. For example:
Administrator@SecurityDomain

You must specify at least one of the user name options, -u or -U.
-p or --password: Argument: password.
Optional. Password of the
Data Integration Hub
user account to use when the import and export utility accesses the
Data Integration Hub
repository.
-P: Argument: Environment variable.
Optional. Environment variable that contains a password.

Password for the Operation Console user that runs the import or the export command. The password must be encrypted. Use
dxencrypt
for the encrypted value.

You must specify at least one of the password options, -p or -P.
--server: Argument: “hostname:port”
Optional. Host name and port number of the
Data Integration Hub
server. If you do not enter an argument, the import and export utility connects to the localhost server with the default port 18095. You must enclose the argument in quotation marks. For example:

--server “localhost:18095”
--test: Optional
for the import or export process. Not applicable for the management of private keys
. Runs the import or export command and generates a report with a list of objects to export or import without exporting or importing the objects. Use this parameter to test the import or export specification file.
The import and export utility creates the report in the same directory as the specification file. The name of the report file is the same as the name of the specification file with a log suffix in the following format:

<SpecFileName>.log.xml

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Export-All and Import-All Batch Scripts

Export-All and Import-All Batch Scripts