Preface
Command Line Programs and Utilities
- Command Line Programs and Utilities Overview
Installing and Configuring Command Line Utilities
- Installing and Configuring Command Line Utilities Overview
- Installing the Command Line Utilities
  - Installation Directories
- Configuring the Command Line Utilities
- Security Configuration for Informatica Utilities
Using the Command Line Programs
- Using the Command Line Programs Overview
- Entering Options and Arguments
- Syntax Notation
- Running Commands in a Secure Domain
- Running Commands on UNIX with Kerberos Authentication
  - Running Commands on UNIX with Single Sign-On
    - Setting the Kerberos Environment Variables
    - Generating the Credentials Cache File
  - Running Commands on UNIX Without Single Sign-On
- Running Commands on Windows with Kerberos Authentication
Environment Variables for Command Line Programs
- Environment Variables for Command Line Programs Overview
- ICMD_JAVA_OPTS
  - Configuring ICMD_JAVA_OPTS on UNIX
  - Configuring ICMD_JAVA_OPTS on Windows
- INFA_CLIENT_RESILIENCE_TIMEOUT
  - Configuring INFA_CLIENT_RESILIENCE_TIMEOUT on UNIX
  - Configuring INFA_CLIENT_RESILIENCE_TIMEOUT on Windows
- INFA_CODEPAGENAME
  - Configuring INFA_CODEPAGENAME on UNIX
  - Configuring INFA_CODEPAGENAME on Windows
- INFA_DEFAULT_DATABASE_PASSWORD
  - Configuring INFA_DEFAULT_DATABASE_PASSWORD on UNIX
  - Configuring INFA_DEFAULT_DATABASE_PASSWORD on Windows
- INFA_DEFAULT_DB_TRUSTSTORE_PASSWORD
  - Configuring INFA_DEFAULT_DB_TRUSTSTORE_PASSWORD on UNIX
  - Configuring INFA_DEFAULT_DB_TRUSTSTORE_PASSWORD on Windows
- INFA_DEFAULT_DOMAIN
  - Configuring INFA_DEFAULT_DOMAIN on UNIX
  - Configuring INFA_DEFAULT_DOMAIN on Windows
- INFA_DEFAULT_DOMAIN_PASSWORD
  - Configuring INFA_DEFAULT_DOMAIN_PASSWORD on UNIX
  - Configuring INFA_DEFAULT_DOMAIN_PASSWORD on Windows
- INFA_DEFAULT_DOMAIN_USER
  - Configuring INFA_DEFAULT_DOMAIN_USER on UNIX
  - Configuring INFA_DEFAULT_DOMAIN_USER on Windows
- INFA_DEFAULT_PWX_OSEPASSWORD
  - Configuring INFA_DEFAULT_PWX_OSEPASSWORD on UNIX
  - Configuring INFA_DEFAULT_PWX_OSEPASSWORD on Windows
- INFA_DEFAULT_PWX_OSPASSWORD
  - Configuring INFA_DEFAULT_PWX_OSPASSWORD on UNIX
  - Configuring INFA_DEFAULT_PWX_OSPASSWORD on Windows
- INFA_DEFAULT_SECURITY_DOMAIN
  - Configuring INFA_DEFAULT_SECURITY_DOMAIN on UNIX
  - Configuring INFA_DEFAULT_SECURITY_DOMAIN on Windows
- INFA_JAVA_CMD_OPTS
  - Configuring INFA_JAVA_CMD_OPTS on UNIX
  - Configuring INFA_JAVA_CMD_OPTS on Windows
- INFA_PASSWORD
  - Configuring INFA_PASSWORD on UNIX
  - Configuring INFA_PASSWORD on Windows
- INFA_NODE_KEYSTORE_PASSWORD
  - Configuring INFA_NODE_KEYSTORE_PASSWORD on UNIX
  - Configuring INFA_NODE_KEYSTORE_PASSWORD on Windows
- INFA_NODE_TRUSTSTORE_PASSWORD
  - Configuring INFA_NODE_TRUSTSTORE_PASSWORD on UNIX
  - Configuring INFA_NODE_TRUSTSTORE_PASSWORD on Windows
- INFA_REPCNX_INFO
  - Configuring INFA_REPCNX_INFO on UNIX
  - Configuring INFA_REPCNX_INFO on Windows
- INFA_REPOSITORY_PASSWORD
  - Configuring INFA_REPOSITORY_PASSWORD on UNIX
  - Configuring INFA_REPOSITORY_PASSWORD on Windows
- INFATOOL_DATEFORMAT
  - Configuring INFATOOL_DATEFORMAT on UNIX
  - Configuring INFATOOL_DATEFORMAT on Windows
- Encrypting Passwords
  - Using a Password as an Environment Variable
    - Configuring a Password as an Environment Variable on UNIX
    - Configuring a Password as an Environment Variable on Windows
- Setting the User Name
  - Configuring a User Name as an Environment Variable on UNIX
  - Configuring a User Name as an Environment Variable on Windows
Using infacmd
- Using infacmd Overview
- infacmd ListPlugins
- Running Commands
- infacmd Return Codes
infacmd as Command Reference
- CreateExceptionAuditTables
- CreateService
- DeleteExceptionAuditTables
- ListServiceOptions
- ListServiceProcessOptions
- UpdateServiceOptions
- UpdateServiceProcessOptions
infacmd aud Command Reference
- getDomainObjectPermissions
- getPrivilegeAssociation
- getUserGroupAssociation
- getUserGroupAssociationForRoles
- getUsersPersonalInfo
infacmd autotune Command Reference
- Autotune
Infacmd bg Command Reference
- upgradeRepository
- listGlossary
- exportGlossary
- importGlossary
infacmd ccps Command Reference
- deleteClusters
- listClusters
- updateADLSCertificate
infacmd cluster Command Reference
- createConfiguration
- createConfigurationWithParams
- deleteConfiguration
- clearConfigurationProperties
- exportConfiguration
- listAssociatedConnections
- listConfigurationGroupPermissions
- listConfigurationSets
- listConfigurationProperties
- listConfigurations
- listConfigurationUserPermissions
- refreshConfiguration
- setConfigurationPermissions
- setConfigurationProperties
- updateConfiguration
infacmd cms Command Reference
- CreateAuditTables
- CreateService
- DeleteAuditTables
- ListServiceOptions
- ListServiceProcessOptions
- Purge
- RemoveService
- ResyncData
- UpdateServiceOptions
- UpdateServiceProcessOptions
- Upgrade
infacmd dis Command Reference
- AddParameterSetEntries
- BackupApplication
- CancelDataObjectCacheRefresh
- CreateService
- DeleteParameterSetEntries
- DeployApplication
- disableMappingValidationEnvironment
- enableMappingValidationEnvironment
- ListApplicationObjectPermissions
- ListApplicationObjects
- ListApplicationOptions
- ListApplicationPermissions
- ListApplications
- ListComputeOptions
- ListDataObjectOptions
- ListMappingEngines
- ListParameterSetEntries
- ListParameterSetObjects
- ListParameterSets
- ListSequenceObjectProperties
- ListSequenceObjects
- ListServiceOptions
- ListServiceProcessOptions
- PurgeDataObjectCache
- PurgeResultSetCache
- RefreshDataObjectCache
- RenameApplication
- replaceMappingHadoopRuntimeConnections
- RestoreApplication
- SetApplicationPermissions
- SetApplicationObjectPermissions
- setMappingExecutionEnvironment
- SetSequenceState
- StartApplication
- StopApplication
- stopBlazeService
- UndeployApplication
- UpdateApplication
- UpdateApplicationOptions
- UpdateComputeOptions
- UpdateDataObjectOptions
  - Data Object Options
- UpdateParameterSetEntries
- UpdateServiceOptions
  - Data Integration Service Options
- UpdateServiceProcessOptions
  - Data Integration Service Process Options
infacmd idp Command Reference
- createRepository
- createService
- updateService
- upgradeRepository
infacmd edp Command Reference
- createService
- purgeauditevents
- updateService
- upgradeService
Infacmd es Command Reference
- ListServiceOptions
- UpdateServiceOptions
- UpdateSMTPOptions
infacmd ihs Command Reference
- cleanCluster
- createservice
- ListServiceOptions
- ListServiceProcessOptions
- UpdateServiceOptions
- UpdateServiceProcessOptions
- UpgradeClusterService
infacmd ipc Command Reference
- ImportFromPC
- genReuseReportFromPC
infacmd isp Command Reference
- AddAlertUser
- AddConnectionPermissions
- AddDomainLink
- AddDomainNode
- AddGroupPrivilege
- AddLicense
- AddNamespace
- AddNodeResource
- AddRolePrivilege
- AddServiceLevel
- AddUserPrivilege
- AddUserToGroup
- AssignDefaultOSProfile
- AssignedToLicense
- AssignGroupPermission
- AssignISToMMService
- AssignLicense
- AssignRoleToGroup
- AssignRoleToUser
- AssignRSToWSHubService
- AssignUserPermission
- ConvertLogFile
- convertUserActivityLogFile
- CreateConnection
  - Adabas Connection Options
  - Amazon Kinesis Connection Options
  - Amazon Redshift Connection Options
  - Amazon S3 Connection Options
  - Cassandra Connection Options
  - Databricks Connection Options
  - DataSift Connection Options
  - DB2 for i5/OS Connection Options
  - DB2 for z/OS Connection Options
  - Facebook Connection Options
  - Greenplum Connection Options
  - Google Analytics Connection Options
  - Google BigQuery Connection Options
  - Google Cloud Spanner Connection Options
  - Google Cloud Storage Connection Options
  - Hadoop Connection Options
  - HBase Connection Options
  - HDFS Connection Options
  - Hive Connection Options
  - IBM DB2 Connection Options
  - IMS Connection Options
  - JDBC Connection Options
  - JD Edwards EnterpriseOne Connection Options
  - Kafka Connection Options
  - LDAP Connection Options
  - LinkedIn Connection Options
  - MapR-DB Connection Options
  - Microsoft Azure Blob Storage Connection Options
  - Microsoft Azure Data Lake Store Connection Options
  - Microsoft Azure SQL Data Warehouse Connection Options
  - Microsoft SQL Server Connection Options
  - Microsoft Dynamics CRM Connection Options
  - Netezza Connection Options
  - OData Connection Options
  - ODBC Connection Options
  - Oracle Connection Options
  - Salesforce Connection Options
  - SAP Connection Options
  - Sequential Connection Options
  - Snowflake Connection Options
  - Tableau Connection Options
  - Tableau V3 Connection Options
  - Teradata Parallel Transporter Connection Options
  - Twitter Connection Options
  - Twitter Streaming Connection Options
  - VSAM Connection Options
  - Web Content-Kapow Katalyst Connection Options
- CreateFolder
- CreateGrid
- CreateGroup
- CreateIntegrationService
  - Integration Service Options
  - Integration Service Process Options
- CreateMMService
  - Metadata Manager Service Options
- CreateOSProfile
  - Data Integration Service Process Options for Operating System Profiles
  - PowerCenter Integration Service Process Options for Operating System Profiles
- CreateRepositoryService
- CreateRole
- CreateSAPBWService
  - SAP BW Service Options
  - SAP BW Service Process Option
- CreateUser
- CreateWSHubService
  - Web Services Hub Options
- DeleteNamespace
- DisableNodeResource
- DisableService
- DisableServiceProcess
- DisableUser
- EditUser
- EnableNodeResource
- EnableService
- EnableServiceProcess
- EnableUser
- ExportDomainObjects
- ExportUsersAndGroups
- GetFolderInfo
- GetLastError
- GetLog
- GetNodeName
- GetPasswordComplexityConfig
- getDomainSamlConfig
- GetServiceOption
- GetServiceProcessOption
- GetServiceProcessStatus
- GetServiceStatus
- GetSessionLog
- GetSystemLogDirectory
- getUserActivityLog
- GetWorkflowLog
- Help
- ImportDomainObjects
- ImportUsersAndGroups
- ListAlertUsers
- ListAllGroups
- ListAllRoles
- ListAllUsers
- ListConnectionOptions
- ListConnectionPermissions
- ListConnectionPermissionsByGroup
- ListConnectionPermissionsByUser
- ListConnections
- ListConnectionOptions
- ListDefaultOSProfiles
- ListDomainCiphers
- ListDomainLinks
- ListDomainOptions
- ListFolders
- ListGridNodes
- ListGroupPermissions
- ListGroupPrivileges
- ListGroupsForUser
- ListLDAPConnectivity
- ListLicenses
- ListMonitoringOptions
- ListNodeOptions
- ListNodeResources
- ListNodeRoles
- ListNodes
- ListOSProfiles
- ListRepositoryLDAPConfiguration
- ListRolePrivileges
- ListSecurityDomains
- ListServiceLevels
- ListServiceNodes
- ListServicePrivileges
- ListServices
- ListSMTPOptions
- ListUserPermissions
- ListUserPrivileges
- infacmd ListWeakPasswordUsers
- migrateUsers
- MoveFolder
- MoveObject
- Ping
- PingDomain
- PrintSPNAndKeytabNames
- PurgeLog
- PurgeMonitoringData
- RemoveAlertUser
- RemoveConnection
- RemoveConnectionPermissions
- RemoveDomainLink
- RemoveFolder
- RemoveGrid
- RemoveGroup
- RemoveGroupPermission
- RemoveGroupPrivilege
- RemoveLicense
- RemoveNode
- RemoveNodeResource
- RemoveOSProfile
- RemoveRole
- RemoveRolePrivilege
- RemoveService
- RemoveServiceLevel
- RemoveUser
- RemoveUserFromGroup
- RemoveUserPermission
- RemoveUserPrivilege
- RenameConnection
- ResetPassword
- RunCPUProfile
- SetConnectionPermissions
- SetLDAPConnectivity
- SetRepositoryLDAPConfiguration
- ShowLicense
- ShutdownNode
- SwitchToGatewayNode
- SwitchToWorkerNode
- SyncSecurityDomains
- UnassignDefaultOSProfile
- UnassignISMMService
- UnassignLicense
- UnassignRoleFromGroup
- UnassignRoleFromUser
- UnassignRSWSHubService
- UnassociateDomainNode
- UpdateConnection
- UpdateDomainOptions
- UpdateFolder
- UpdateGatewayInfo
- UpdateGrid
- UpdateIntegrationService
- UpdateLicense
- UpdateMMService
- UpdateMonitoringOptions
- UpdateNamespace
- UpdateNodeOptions
- UpdateNodeRole
- UpdateOSProfile
- UpdateRepositoryService
- UpdateSAPBWService
- UpdateServiceLevel
- UpdateServiceProcess
- UpdateSMTPOptions
- UpdateWSHubService
- validateFeature
- Version
infacmd ldm Command Reference
- BackupContents
- CreateService
- collectAppLogs
- ListServiceOptions
- ListServiceProcessOptions
- publishArchive
- restoreContents
- removesnapshot
- UpdateServiceOptions
- UpdateServiceProcessOptions
- upgrade
infacmd mas Command Reference
- CreateService
- ListServiceOptions
- ListServiceProcessOptions
- UpdateServiceOptions
  - Metadata Access Service Options
- UpdateServiceProcessOptions
  - Metadata Access Service Process Options
infacmd mi Command Reference
- abortRun
- createService
- deploySpec
- exportSpec
- extendedRunStats
- getSpecRunStats
- listSpecRuns
- listSpecs
- restartMapping
- runSpec
infacmd mrs Command Reference
- BackupContents
- CheckInObject
- CreateContents
- CreateFolder
- CreateProject
- CreateService
- DeleteContents
- DeleteFolder
- DeleteProject
- disableMappingValidationEnvironment
- enableMappingValidationEnvironment
- ListBackupFiles
- ListCheckedOutObjects
- listFolders
- ListLockedObjects
- listMappingEngines
- listPermissionOnProject
- ListProjects
- ListServiceOptions
- ListServiceProcessOptions
- ManageGroupPermissionOnProject
- ManageUserPermissionOnProject
- PopulateVCS
- ReassignCheckedOutObject
- rebuildDependencyGraph
- RenameFolder
- replaceMappingHadoopRuntimeConnections
- RestoreContents
- UndoCheckout
- setMappingExecutionEnvironment
- UndoCheckout
- UnlockObject
- UpdateServiceOptions
  - Model Repository Service Options
- UpdateServiceProcessOptions
- UpdateStatistics
- UpgradeContents
- UpgradeExportedObjects
infacmd ms Command Reference
- abortAllJobs
- getMappingStatus
- getRequestLog
- listMappingParams
  - listMappingParams Output
- listMappings
- ListMappingOptions
- UpdateMappingOptions
- UpdateOptimizationLevel
- purgeDatabaseWorkTables
- runMapping
- upgradeMappingParameterFile
infacmd oie Command Reference
infacmd ps Command Reference
- cancelProfileExecution
- CreateWH
- detectOrphanResults
- DropWH
- Execute
- executeProfile
- getExecutionStatus
- getProfileExecutionStatus
- List
- ListAllProfiles
- migrateProfileResults
- migrateScorecards
- Purge
- purgeOrphanResults
- restoreProfilesAndScorecards
- synchronizeProfile
infacmd pwx Command Reference
- CloseForceListener
- CloseListener
- CondenseLogger
- createdatamaps
- CreateListenerService
- CreateLoggerService
- DisplayAllLogger
- DisplayCPULogger
- DisplayEventsLogger
- DisplayMemoryLogger
- DisplayRecordsLogger
- displayStatsListener
- DisplayStatusLogger
- FileSwitchLogger
- ListTaskListener
- ShutDownLogger
- StopTaskListener
- UpgradeModels
- UpdateListenerService
- UpdateLoggerService
infacmd roh Command Reference
- listROHProperties
- updateROHService
infacmd rms Command Reference
- ListComputeNodeAttributes
- ListServiceOptions
- SetComputeNodeAttributes
- UpdateServiceOptions
  - Resource Manager Service Options
infacmd rtm Command Reference
- DeployImport
- Export
- Import
infacmd sch Command Reference
- CreateSchedule
  - Valid Time Zone Parameters
- DeleteSchedule
- ListSchedule
- ListServiceOptions
- ListServiceProcessOptions
- PauseAll
- PauseSchedule
- ResumeAll
- ResumeSchedule
- UpdateSchedule
- UpdateServiceOptions
  - Scheduler Service Options
- UpdateServiceProcessOptions
  - Scheduler Service Process Options
- Upgrade
infacmd search Command Reference
- CreateService
- ListServiceOptions
- ListServiceProcessOptions
- UpdateServiceOptions
- UpdateServiceProcessOptions
infacmd sql Command Reference
- ExecuteSQL
- ListColumnOptions
- ListColumnPermissions
- ListSQLDataServiceOptions
- ListSQLDataServicePermissions
- ListSQLDataServices
- ListStoredProcedurePermissions
- ListTableOptions
- ListTablePermissions
- PurgeTableCache
- RefreshTableCache
- RenameSQLDataService
- SetColumnPermissions
- SetSQLDataServicePermissions
- SetStoredProcedurePermissions
- SetTablePermissions
- StartSQLDataService
- StopSQLDataService
- UpdateColumnOptions
  - Column Options
- UpdateSQLDataServiceOptions
  - SQL Data Service Options
- UpdateTableOptions
  - Virtual Table Options
infacmd tdm Command Reference
- CreateService
- CreateContents
- EnableService
- DisableService
infacmd tools Command Reference
- deployApplication
- exportObjects
- exportResources
- importObjects
- patchApplication
infacmd wfs Command Reference
- abortWorkflow
- bulkComplete
- cancelWorkflow
- completeTask
- createTables
- delegateTask
- dropTables
- listActiveWorkflowInstances
- listMappingPersistedOutputs
- listTasks
- listWorkflowParams
  - listWorkflowParams Output
- listWorkflows
- pruneOldInstances
- recoverWorkflow
- releaseTask
- setMappingPersistedOutputs
- startTask
- startWorkflow
- upgradeWorkflowParameterFile
infacmd ws Command Reference
- ListOperationOptions
- ListOperationPermissions
- ListWebServiceOptions
- ListWebServicePermissions
- ListWebServices
- RenameWebService
- SetOperationPermissions
- SetWebServicePermissions
- StartWebService
- StopWebService
- UpdateOperationOptions
  - Operation Options
- UpdateWebServiceOptions
  - Web Service Options
infacmd xrf Command Reference
- generateReadableViewXML
- updateExportXML
infacmd Control Files
- infacmd Control Files Overview
- Control File Configuration
  - Control File Naming Conventions
- Export Control Files
  - Export Control File Parameters for Domain Objects
    - Export Control File Sample for Domain Objects
  - Export Control File Parameters for Model Repository Objects
    - Export Control File Sample for Model Repository Objects
- Import Control Files
  - Import Control File Parameters for Domain Objects
    - Import Control File Sample for Domain Objects
  - Import Control File Parameters for Model Repository Objects
    - Import Control File Sample for Model Repository Objects
- Rules and Guidelines for Control Files
- Control File Examples for Domain Objects
- Control File Examples for Model Repository Objects
infasetup Command Reference
- Using infasetup
  - Running Commands
  - Command Options
  - infasetup Return Codes
  - Using Database Connection Strings
- BackupDomain
- DefineDomain
- DefineGatewayNode
- DefineWorkerNode
- DeleteDomain
- GenerateEncryptionKey
- Help
- ListDomainCiphers
- MigrateEncryptionKey
- RestoreDomain
- restoreMitKerberosLinkage
- SwitchToKerberosMode
- UpdateDomainCiphers
- updateDomainName
- UpdateGatewayNode
- UpdateKerberosAdminUser
- UpdateKerberosConfig
- updateMitKerberosLinkage
- UpdatePasswordComplexityConfig
- updateDomainSamlConfig
- UpdateWorkerNode
- UnlockUser
- ValidateandRegisterFeature
pmcmd Command Reference
- Using pmcmd
  - Running Commands in Command Line Mode
    - pmcmd Return Codes
  - Running Commands in Interactive Mode
    - Setting Defaults
  - Running in Wait Mode
  - Scripting pmcmd Commands
  - Entering Command Options
- aborttask
- abortworkflow
- Connect
- Disconnect
- Exit
- getrunningsessionsdetails
- GetServiceDetails
- getserviceproperties
- getsessionstatistics
- gettaskdetails
- getworkflowdetails
- help
- pingservice
- recoverworkflow
- scheduleworkflow
- SetFolder
- SetNoWait
- SetWait
- ShowSettings
- StartTask
  - Using Parameter Files with starttask
- StartWorkflow
  - Using Parameter Files with startworkflow
- StopTask
- StopWorkflow
- UnscheduleWorkflow
- UnsetFolder
- Version
- WaitTask
- WaitWorkflow
pmrep Command Reference
- Using pmrep
  - Running Commands in Command Line Mode
  - Running Commands in Interactive Mode
  - Running Commands in Normal Mode and Exclusive Mode
  - pmrep Return Codes
  - Using Native Connect Strings
  - Scripting pmrep Commands
    - Tips for Scripting pmrep Commands
  - Connection Subtypes
- AddToDeploymentGroup
- ApplyLabel
- AssignIntegrationService
- AssignPermission
  - Example
- BackUp
- ChangeOwner
- CheckIn
- CleanUp
- ClearDeploymentGroup
- Connect
- Create
- CreateConnection
  - Specifying the Database Code Page
- CreateDeploymentGroup
- CreateFolder
  - Assigning Permissions
- CreateLabel
- CreateQuery
- Delete
- DeleteConnection
- DeleteDeploymentGroup
- DeleteFolder
- DeleteLabel
- DeleteObject
- DeleteQuery
- DeployDeploymentGroup
- DeployFolder
- ExecuteQuery
- Exit
- FindCheckout
- GetConnectionDetails
- GenerateAbapProgramToFile
- Help
- InstallAbapProgram
- KillUserConnection
- ListConnections
- ListObjectDependencies
- ListObjects
  - Listing Object Types
  - Listing Folders
  - Listing Objects
- ListTablesBySess
- ListUserConnections
- MassUpdate
  - Session Property Types
  - Rules and Guidelines for MassUpdate
  - Sample Log File
- ModifyFolder
- Notify
- ObjectExport
  - Examples
- ObjectImport
- PurgeVersion
  - Examples
- Register
- RegisterPlugin
  - Registering a Security Module
  - Example
- Restore
  - Example
- RollbackDeployment
  - Example
- Run
- ShowConnectionInfo
- SwitchConnection
- TruncateLog
- UndoCheckout
- Unregister
- UnregisterPlugin
  - Unregistering an External Security Module
  - Example
- UpdateConnection
- UpdateEmailAddr
- UpdateSeqGenVals
- UpdateSrcPrefix
- UpdateStatistics
- UpdateTargPrefix
- Upgrade
- UninstallAbapProgram
- Validate
- Version
Working with pmrep Files
- Working with pmrep Files Overview
- Using the Persistent Input File
  - Creating a Persistent Input File with pmrep
    - Example
  - Creating a Persistent Input File Manually
    - Example
- Using the Object Import Control File
  - Object Import Control File Parameters
- Object Import Control File Examples
- Using the Deployment Control File
  - Deployment Control File Parameters
    - Persisted Mapping Variables
- Deployment Control File Examples
- Tips for Working with pmrep Files

Command Reference

10.2.2 HotFix 1
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 Service Pack 1
- 10.2.2
- 10.2.1

Back Next

Connection Subtypes

When you list or update a connection, you can specify the connection subtypes based on the associated connection type. Based on the repository plugins, the pmrep command lists the connection subtypes in the repository, by default.

The following table shows the list of connection subtypes for the associated type of connection:

Type of Connection	Connection Subtype
Relational	Sybase
Relational	Informix (Obsolete)
Relational	Microsoft SQL Server
Relational	DB2
Relational	ODBC
Relational	Teradata
Relational	Netezza
Relational	Vertica
Relational	PowerChannel for DB2
Relational	PowerChannel for Oracle
Relational	PowerChannel for MS SQL Server
Relational	PowerChannel for ODBC
Relational	PWX DB2zOS
Relational	PWX DB2i5OS
Relational	PWX DB2LUW
Relational	PWX Oracle
Relational	PWX MSSQLServer
Relational	PWX NRDB Lookup
Relational	Teradata PT Connection
Application	SAP BW
Application	SAP R3
Application	PeopleSoft Oracle
Application	PeopleSoft Sybase
Application	PeopleSoft Informix
Application	PeopleSoft MsSqlserver
Application	PeopleSoft Db2
Application	Siebel Oracle
Application	Siebel Sybase
Application	Siebel Informix
Application	Siebel MsSqlserver
Application	Siebel Db2
Application	SAP_ALE_IDoc_Reader
Application	SAP Type A
Application	SAP_BWOHS_READER
Application	SAP_ALE_IDoc_Writer
Application	SAP RFC/BAPI Interface
Application	JNDI Connection
Application	JMS Connection
Application	webMethods Broker
Application	webMethods Integration Server
Application	Web Services Consumer
Application	PWX NRDB Batch
Application	PWX NRDB CDC Change
Application	PWX NRDB CDC Real Time
Application	PWX DB2zOS CDC Change
Application	PWX DB2zOS CDC Real Time
Application	PWX DB2i5OS CDC Change
Application	PWX DB2i5OS CDC Real Time
Application	Http Transformation
Application	PWX Oracle CDC Change
Application	PWX Oracle CDC Real Time
Application	LMAPITarget
Application	Teradata FastExport Connection
Application	PWX MSSQL CDC Change
Application	PWX MSSQL CDC Real Time
Application	PWX DB2LUW CDC Change
Application	PWX DB2LUW CDC Real Time
Application	Salesforce Connection
Application	Hadoop HDFS Connection
FTP	FTP
External Loader	Teradata Mload External Loader
External Loader	Teradata Tpump External Loader
External Loader	DB2 EE External Loader
External Loader	DB2 EEE External Loader
External Loader	Teradata FastLoad External Loader
External Loader	Teradata Warehouse Builder External Loader
External Loader	HP NeoView Java Transporter
Queue	Message Queue
Queue	MSMQ

Rename Saved Search

Table of Contents

Command Reference

Command Reference

Connection Subtypes

Connection Subtypes