An operation to generate SQL scrip to migrate a PeopleSoft project.

Environment/Instance Properties

Property NameProperty CodeRequiredDescription
Database TypeFDPSOFT_DATABASE_TYPEYesThe type of source database to which to connect to. (e.g. ORACLE, SYBASE, etc.)
Database NameFDPSOFT_DATABASE_NAMEYesThe name of the source database to which you are connecting.
PeopleSoft UserFDPSOFT_USER_IDYesThe user ID to use to sign in to the source database. 
PeopleSoft PasswordFDPSOFT_PASSWORDYesThe password for the specified user ID for the source database.
PeopleSoft Connect IdFDPSOFT_CONNECT_IDNoThe ID that is used to connect to the database.
PeopleSoft Connect PasswordFDPSOFT_CONNECT_PASSWORDNoThe password for the specified connect ID.
PeopleTools Executable PathFDPSOFT_PEOPLETOOLS_EXEYesThe path to the PeopleTools executable. (pside.exe)
Build Configuration FileFDPSOFT_BUILD_CONFIG_FILENoThe path to the RDM Build Config File. The build operation will use the settings defined in this file when generating SQL files. If provided the output directory will be ignored.

Project Properties

Property NameProperty CodeRequiredDescription
PeopleSoft Project NameFDPSOFT_PROJECT_NAMEYesThe name of the PeopleSoft project.


Input NameInput CodeRequiredDescription
Output DirectoryFDPSOFT_INP_OUTPUT_DIRNoDirectory to output generated SQL file to. If no value is provided the temp directory will be used.
Execute SQLFDPSOFT_INP_EXECUTE_SQLNoIf true the generated SQL files will automatically be executed against the target database.
Additional ParametersFDPSOFT_INP_ADDITIONAL_PARAMETERSNoAdditional parameters to be added to the PeopleTools command.


Output NameDescription
FDPSOFT_OUT_SQL_FILESA comma separated string of all the generated SQL files.
FDPSOFT_OUT_EXECUTE_SQLWhether or not the SQL files were automatically executed.


This operation doesn’t consume or produce any artifacts.

Endpoint Selection 

This operation will select all available endpoints associated to the environment/instance.

Endpoint Execution

This operation will execute on any one of the selected endpoints and will be random in the determination of which one.

Special Considerations

This operation will generate SQL files and store them in the output directory. The directories provided in the configuration file will be used. If no configuration file is provided the temp directory will be used.