buildProject(PeopleSoft)

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

Target Properties

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

Database Type

FDPSOFT_DATABASE_TYPE

Yes

The type of source database to which to connect to. (e.g. ORACLE, SYBASE, etc.)

Database Name

FDPSOFT_DATABASE_NAME

Yes

The name of the source database to which you are connecting.

PeopleSoft User

FDPSOFT_USER_ID

Yes

The user ID to use to sign into the source database. 

PeopleSoft Password

FDPSOFT_PASSWORD

Yes

The password for the specified user ID for the source database.

PeopleSoft Connect Id

FDPSOFT_CONNECT_ID

No

The ID that is used to connect to the database.

PeopleSoft Connect Password

FDPSOFT_CONNECT_PASSWORD

No

The password for the specified connect ID.

PeopleTools Executable Path

FDPSOFT_PEOPLETOOLS_EXE

Yes

The path to the PeopleTools executable. (pside.exe)

Build Configuration File

FDPSOFT_BUILD_CONFIG_FILE

No

The 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. You can see an example RDM Build Config File in our Special Considerations below.

Project Properties

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

PeopleSoft Project Name

FDPSOFT_PROJECT_NAME

No

The name of the PeopleSoft project. If not provided, defaults to FD_PROJECT_NAME.

Inputs

Input Name

Input Code

Required

Description

Input Name

Input Code

Required

Description

Output Directory

FDPSOFT_INP_OUTPUT_DIR

No

Directory to output generated SQL file to. If no value is provided the temp directory will be used.

Execute SQL

FDPSOFT_INP_EXECUTE_SQL

No

If true the generated SQL files will automatically be executed against the target database.

Additional Parameters

FDPSOFT_INP_ADDITIONAL_PARAMETERS

No

Additional parameters to be added to the PeopleTools command.

Outputs

Output Name

Description

Output Name

Description

FDPSOFT_OUT_SQL_FILES

A comma separated string of all the generated SQL files.

FDPSOFT_OUT_EXECUTE_SQL

Whether or not the SQL files were automatically executed.

Artifacts

This operation doesn’t consume or produce any artifacts.

Endpoint Selection 

This operation will select all available endpoints associated to the Target.

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.

;===================================================================
; RDM Build Settings Information
;===================================================================
;Build Options
;==============
; CreateTables 0 = No, 1 = Yes
; CreateIndexes 0 = No, 1 = Yes
; CreateViews 0 = No, 1 = Yes
; AlterTables 0 = No, 1 = Yes
; CreateTrigger 0 = No, 1 = Yes
;
;Build Execute Options
;======================
; ExecuteOption
; 1 = Execute SQL now
; 2 = Build script file
; 3 = Execute and build script
;
;Build Settings Create
;=======================
; TableOption
; 1 = Recreate table if it already exists
; 2 = Skip table if it already exists
;
; ViewOption
; 1 = Recreate view if it already exists
; 2 = Skip view if it already exists
;
; IndexOption
; 1 = Recreate index if it already exists
; 3 = Recreate index only if modified
;
;Build Settings Alter
;======================
; Drop Column Options
; AlterDropOption
; 1 = Drop column if data present
; 2 = Skip record if data present
;
; Change Column Length Options
; AlterTruncateOption
; 1 = Truncate data if field too short
; 2 = Skip record if field too short
;
; Alter table in Memory
; IMDBAlterOption
; 0 = Alter Table In Memory (No)
; 1 = Alter Table In Memory (Yes)
;
; Alter Any
; Adds AlterAdds 0 = No, 1 = Yes
; Changes AlterChanges 0 = No, 1 = Yes
; Renames AlterRenames 0 = No, 1 = Yes
; Deletes AlterDeletes 0 = No, 1 = Yes
;
; Alter even if no changes
; ForceAlterOption
; 0 = No AlterByTableRename = 0 or 1
; 1 = Yes AlterByTableRename = 1
;
; Alter table Options
; AlterByTableRename
; 0 = Alter in Place
; 1 = Alter by Table Rename
;
;Build Settings Logging
;======================
; Logging Level
; LogErrors
; 1 = Information (Fatal errors, warnings and informational messages)
; 2 = Warnings (Fatal errors and warnings)
; 3 = Fatal (Fatal errors only)
;
; Logging Output
; Log to output window LogToWindow 0 = No, 1 = Yes
; Log settings LogSettings 0 = No, 1 = Yes
; Log to file LogToScript 0 = No, 1 = Yes
; Log file name LogFilename=
;
;Build Settings Scripts
;======================
; Comments
; Write Alter comments to script
; LogComments 0 = No, 1 = Yes
;
; Script Files
; Save as Unicode
; UnicodeScript 0 = No, 1 = Yes
;
; File Overwrite Options
; AlwaysOverwrite
; 1 = Always overwrite
; 0 = Prompt for each overwrite
;
; Script File Options
; OutputToSingleFile
; 1 = Output to single files
; 0 = Output to seperate files
;
; Script File Names
; OutputToSingleFilename=
; CreateTableFilename=
; CreateIndexFilename=
; CreateTriggerFilename=
; CreateViewFilename=
; AlterTableFilename=
; On Unix, export TEMP=<temp path for .sql,.log file>
;
;
;===================================================================
; RDM Build Settings
;===================================================================
[RDM Build Settings]
CreateTables=1
CreateIndexes=1
CreateViews=1
AlterTables=1
CreateTrigger=1
ExecuteOption=3
TableOption=2
ViewOption=1
IndexOption=3
AlterDropOption=2
AlterTruncateOption=2
IMDBAlterOption=0
AlterAdds=1
AlterChanges=1
AlterRenames=1
AlterDeletes=1
ForceAlterOption=0
AlterByTableRename=1
PreserveStorageParms=1
LogErrors=2
LogToWindow=1
LogSettings=0
LogToScript=1
LogFilename=C:\Users\flexagon\AppData\Local\Temp\PSBUILD.LOG
LogComments=0
UnicodeScript=1
AlwaysOverwrite=1
OutputToSingleFile=1
OutputToSingleFilename=C:\Users\flexagon\AppData\Local\Temp\PSBUILD.SQL
CreateTableFilename=C:\Users\flexagon\AppData\Local\Temp\PSTABLE.SQL
CreateIndexFilename=C:\Users\flexagon\AppData\Local\Temp\PSINDEX.SQL
CreateViewFilename=C:\Users\flexagon\AppData\Local\Temp\PSTRIGGER.SQL
AlterTableFilename=C:\Users\flexagon\AppData\Local\Temp\PSTRIGGER.SQL
CreateTriggerFilename=C:\Users\flexagon\AppData\Local\Temp\PSTRIGGER.SQL

The following macros are not currently supported in the footer:
  • style