Table of Contents

Search

  1. Preface
  2. Introduction to Data Integration Hub
  3. Security
  4. Events
  5. User Policies
  6. Operation Console Management
  7. System Properties
  8. Connections
  9. Connectivity to Informatica Intelligent Cloud Services
  10. Integration of Data Integration Hub with Enterprise Data Catalog
  11. Document Management
  12. Entity Management
  13. Export and Import
  14. Data Integration Hub Utilities
  15. Dashboard and Reports Management

Administrator Guide

Administrator Guide

Import and Export Utility Command Syntax

Import and Export Utility Command Syntax

Use the import and export utility command syntax to define the scope, location, and permissions for the import or export process and for the management of private keys that are used for authentication in SSH FTP connections.
The import and export utility uses a different syntax for the import or export process and for the management of private keys.
Import and export command syntax
importexport <-c|--command> command <-f|--file> exportfile <-s|--specification> specfile <-u|--user> userID <-p|--password> user password [--server "hostname:port"] [--test]
For example:
importexport import -f "C:\Users\Administrator\DIH_backup\exported_entities.xml" –s C:/dx-tools/samples/import-all-specification-sample.xml -u Administrator -p Administrator
Private key management command syntax
importexport <-c|--command> command <-f|--file> exportfile <-p|--password> user password <-u|--user> userID [--server "hostname:port"] [--action] key alias action [--alias] alias of the private key
For example:
importexport managekeys -f "C:\Users\Administrator\Private_keys\PrivateKey.store" -u Administrator -p Administrator –action create –alias root
The following list describes parameters and arguments for the import and export utility commands.
-c or --command
Argument: command
The command to run. Specify one of the following commands:
  • export. Exports specific objects from the
    Data Integration Hub
    repository based on the export specification file you create. The utility saves the exported objects in an XML file that you can import back into the
    Data Integration Hub
    repository.
  • import. Imports specific objects from the export XML file into the
    Data Integration Hub
    repository based on the import specification file you create.
  • managekeys. Manages private keys. You can create, update, and delete private keys.
-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 run the
managekeys
command, this is the location of the private keys.
-s or --specification
Argument: SpecFile
Required
for the import or export process. Not applicable for the management of private keys
. Absolute path and file name of the import or export specification file.
-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
--action
Arguments: create, update, or delete.
Optional for the management of private keys. Not applicable for the import or export process. Manage key action.
--alias
Argument: Alias of the private key.
Optional for the management of private keys. Not applicable for the import or export process. Manage key action.

0 COMMENTS

We’d like to hear from you!