Table of Contents

Search

  1. Preface
  2. Command Line Programs and Utilities
  3. Installing and Configuring Command Line Utilities
  4. Using the Command Line Programs
  5. Environment Variables for Command Line Programs
  6. Using infacmd
  7. infacmd as Command Reference
  8. infacmd aud Command Reference
  9. infacmd autotune Command Reference
  10. Infacmd bg Command Reference
  11. infacmd ccps Command Reference
  12. infacmd cluster Command Reference
  13. infacmd cms Command Reference
  14. infacmd dis Command Reference
  15. infacmd idp Command Reference
  16. infacmd edp Command Reference
  17. Infacmd es Command Reference
  18. infacmd ihs Command Reference
  19. infacmd ipc Command Reference
  20. infacmd isp Command Reference
  21. infacmd ldm Command Reference
  22. infacmd mas Command Reference
  23. infacmd mi Command Reference
  24. infacmd mrs Command Reference
  25. infacmd ms Command Reference
  26. infacmd oie Command Reference
  27. infacmd ps Command Reference
  28. infacmd pwx Command Reference
  29. infacmd roh Command Reference
  30. infacmd rms Command Reference
  31. infacmd rtm Command Reference
  32. infacmd sch Command Reference
  33. infacmd search Command Reference
  34. infacmd sql Command Reference
  35. infacmd tdm Command Reference
  36. infacmd tools Command Reference
  37. infacmd wfs Command Reference
  38. infacmd ws Command Reference
  39. infacmd xrf Command Reference
  40. infacmd Control Files
  41. infasetup Command Reference
  42. pmcmd Command Reference
  43. pmrep Command Reference
  44. Working with pmrep Files

exportObjects

exportObjects

Exports objects from a project in the Model repository to an XML file.
If you do not want to export all objects in the project, use an infacmd export control file to filter the Model repository objects that you want to export.
If the project being exported contains reference tables, you must run the command from the Informatica services installation directory. The command exports the reference table metadata from the Model repository to the XML file. The command exports the reference table data to a zip file. When you run the command, specify the path and file name of both the XML and zip files to be created.
The command does not export empty folders.
If the command fails with a Java memory error, increase the system memory available for infacmd. To increase system memory, set the -Xmx value in the ICMD_JAVA_OPTS environment variable.
The infacmd tools exportObjects command uses the following syntax:
exportObjects <-DomainName|-dn> Domain name <-UserName|-un> User name <-Password|-pd> Password [<-SecurityDomain|-sdn> Security domain] <-ProjectName|-pn> Project name <-RepositoryService|-rs> Model Repository Service name <-ExportFilePath|-fp> Path of file to export to [<-OverwriteExportFile|-ow> Set to "true" to overwrite export file if it exists.] [<-ControlFilePath|-cp> Path of export control file] [<-OtherOptions|-oo>]
The following table describes infacmd tools exportObjects options and arguments:
Option
Argument
Description
-DomainName
-dn
Domain name
Required. Name of the Informatica domain. You can set the domain name with the -dn option or the environment variable INFA_DEFAULT_DOMAIN. If you set a domain name with both methods, the -dn option takes precedence.
-UserName
-un
User name
Required if the domain uses Native or LDAP authentication. User name to connect to the domain. You can set the user name with the -un option or the environment variable INFA_DEFAULT_DOMAIN_USER. If you set a user name with both methods, the -un option takes precedence.
Optional if the domain uses Kerberos authentication. To run the command with single sign-on, do not set the user name. If you set the user name, the command runs without single sign-on.
-Password
-pd
Password
Required if you specify the user name. Password for the user name. The password is case sensitive. You can set a password with the -pd option or the environment variable INFA_DEFAULT_DOMAIN_PASSWORD. If you set a password with both methods, the password set with the -pd option takes precedence.
-SecurityDomain
-sdn
Security domain
Required if the domain uses LDAP authentication. Optional if the domain uses native authentication or Kerberos authentication. Name of the security domain to which the domain user belongs. You can set a security domain with the -sdn option or the environment variable INFA_DEFAULT_SECURITY_DOMAIN. If you set a security domain name with both methods, the -sdn option takes precedence. The security domain name is case sensitive.
If the domain uses native or LDAP authentication, the default is Native. If the domain uses Kerberos authentication, the default is the LDAP security domain created during installation. The name of the security domain is the same as the user realm specified during installation.
-ProjectName
-pn
Project name
Required. Name of the project from which you export the objects.
-RepositoryService
-rs
Model Repository Service name
Required. Model Repository Service name.
-ExportFilePath
-fp
Path of file to export to
Required. Path and XML file name of the export file to be created. You can specify an absolute path or a relative path to the file name.Use an easily distinguishable name for the file. For example, use the following suggested naming convention:
exp_<project_name>
The command appends the .xml file extension to the output file.
-OverwriteExportFile
-ow
Set to "true" to overwrite export file if it exists.
Optional. Set to true to overwrite an existing export file. If an export file exists and this option is set to false, the export fails. Default is false.
-ControlFilePath
-cp
Path of export control file
Optional. Path and file name of the export control file that filters the objects that are exported. You can specify an absolute path or a relative path to the file name.
-OtherOptions
-oo
-
Required if the project being exported contains reference tables. Additional options to export reference table data to a zip file. Enter options using the following format:
rtm:<option_name>=<value>,<option_name>=<value>
Required option names include:
  • disName. Name of the Data Integration Service.
  • codePage. Code page of the reference data.
  • refDataFile. Path and file name of the zip file where you want to export the reference table data.
For example:
rtm:disName=ds,codePage=UTF-8,refDataFile=/folder1/data.zip

0 COMMENTS

We’d like to hear from you!