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 dps Command Reference
  16. infacmd edl 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 rms Command Reference
  30. infacmd rtm Command Reference
  31. infacmd sch Command Reference
  32. infacmd search Command Reference
  33. infacmd sql Command Reference
  34. infacmd tdm Command Reference
  35. infacmd wfs Command Reference
  36. infacmd ws Command Reference
  37. infacmd xrf Command Reference
  38. infacmd Control Files
  39. infasetup Command Reference
  40. pmcmd Command Reference
  41. pmrep Command Reference
  42. Working with pmrep Files

Command Reference

Command Reference

ExportToPC

ExportToPC

Exports objects from the Model repository or an export file and converts them to PowerCenter objects.
The ExportToPC command converts objects from the Model repository or from an XML file that you exported from the Model repository. You must choose either a Model repository or a source file for export. If you choose both options, the source file option takes precedence. Run ExportToPC command to create an XML file that you can import into PowerCenter with the pmrep program.
The infacmd ipc ExportToPC command uses the following syntax:
ExportToPC

<-Release|-rel> release_number

[<-SourceFile|-sf> source_file]

[<-SourceRepository|-sr> source_repository]

[<-SourceFolders|-f> folder1 folder2|<-SourceObjects|-so> object1 object2]

[<-Recursive|-r>]

[<-TargetLocation|-tl> target_location]

[<-TargetFolder|-tf> target_folder_name] 

[<-CodePage|-cp> target_code_page]

[<-Check|-c>]

[<-ReferenceDataLocation|-rdl> reference_data_output_location]

[<-ConvertMappletTargets|-cmt>]

[<-ConvertMappingsToMapplets|-cmm>]

[<-NoValidation|-nv>]

[<-DSTErrorFormat|-def>]
The following table describes infacmd ipc ExportToPC command options and arguments:
Option
Argument
Description
-Release
-rel
release_number
Required. The PowerCenter release number.
-SourceFile
-sf
source_file
Optional. The full path to an XML file containing source objects that you exported with the Developer tool.
-SourceRepository
-sr
source_repository
Optional. The Model repository that contains the objects to export to PowerCenter.
To specify the gateway host and port to connect to the Model Repository Service, use the following command syntax in a non-Kerberos domain:
<Model repository name>@<host>:<port>#<projectname>
?user=<username>[&namespace=<namespace>]&password=<password>
To specify the domain name when you have multiple gateway nodes, use the following command syntax to establish a resilient connection to the Model Repository Service in a non-Kerberos domain:
<Model repository name>@<domainname>#<projectname>
?user=<username>[&namespace=<namespace>]&password=<password>
To specify the domain name with the logged-in credentials, use the following command syntax to run the command with single sign on:
<Model repository name>@<domainname>#<projectname>
?isloggedinuser=true[&namespace=<namespace>]
To specify the gateway host and port with the logged-in credentials, use the following command syntax to run the command with single sign on:
<Model repository name>@<host>:<port>#<projectname>
?isloggedinuser=true[&namespace=<namespace>]
To specify the gateway host and port with the user credentials you specify instead of the logged-in credentials, use the following command syntax in a Kerberos domain:
<Model repository name>@<host>:<port>#<projectname>
?iskerberos=true&user=<username>[&namespace=<namespace>]&password=<password> &Kerberosrealm=<kerberosrealm>
To specify the domain name with the user credentials you specify instead of the logged-in credentials, use the following command syntax in a Kerberos domain:
<Model repository name>@<domainname>#<projectname>
?iskerberos=true&user=<username>[&namespace=<namespace>]&password=<password> &Kerberosrealm=<kerberosrealm>
The port parameter is the HTTP port. The &namespace parameter is optional. The default namespace is native.
-SourceFolders
-f
source_folders
If you use -sr, you must use -f or -so.
List of source folders that you want to export from the Model repository. You can export mapplets, mappings, and logical data object models from the source folders to PowerCenter. If you export more than one object, you must separate each object in the list with a space.
SourceObjects
-so
source_objects
If you use -sr, you must use -f or -so.
List of source objects that you want to export from the Model repository. You can export mapplets, mappings, and logical data object models to PowerCenter. You can describe the object as a name.
Use the following syntax:
name=/<path>/<objectname>[&type=<typename>]
You must include the full path of the object. If you export more than one object, you must separate each object in the list with a space.
You can enter the following types:
  • Mapping. Use to export mapping and mapplets.
  • DataObjectModel. Use to export logical data object models.
The type is not case sensitive. Default is Mapping.
-Recursive
-r
-
Optional. Exports all mappings and logical data object models from the source folders. Exports each subfolder below the objects, and any subfolders below that.
-TargetLocation
-tl
target_location
Optional. The full path to the target XML file.
-TargetFolder
-tf
target_folder_name
Optional. The PowerCenter folder to export the objects to. The ExportToPC command places the folder name in the target XML file. If you do not configure a folder name, the ExportToPC command creates a folder name.
-CodePage
-cp
target_code_page
Optional. Code page of the PowerCenter repository. Default is UTF-8.
-Check
-c
-
Optional. Tests the conversion without creating a target file.
-ReferenceDataLocation
-rdl
reference_data_output_location
Optional. Location where you want to save reference table data. The ExportToPC command saves the reference table data as one or more dictionary .dic files.
-ConvertMappletTargets
-cmt
-
Optional. Converts targets in mapplets to output transformations in the PowerCenter mapplet.
PowerCenter mapplets cannot contain targets. If the export includes a mapplet that contains a target and you do not select this option, the export fails.
-ConvertMappingstoMapplets
-cmm
-
Optional. Converts Developer tool mappings to PowerCenter mapplets. The Developer tool converts sources and targets in the mappings to Input and Output transformations in a PowerCenter mapplet.
-NoValidation
-nv
-
Optional. The ExportToPC command does not validate source objects before converting them.
-DSTErrorFormat
-def
-
Optional. The error messages appear in a format that the Developer tool can parse. The full path of each object displays in the error messages. Default is to display errors in a user-friendly format.


Updated April 22, 2019