Command Reference > infacmd ipc 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.