...
| 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 in to the source database. |
| PeopleSoft Password | FDPSOFT_PASSWORD | Yes | The password for the specified user ID for the source database. |
| 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. |
Project Properties
| Property Name | Property Code | Required | Description |
|---|---|---|---|
| PeopleSoft Project Name | FDPSOFT_PROJECT_NAME | Yes | The name of the PeopleSoft project. |
...
| 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. |
...
| Output Name | Description |
|---|---|
| FDPSOFT_OUT_SQL_FILES | A comma separated string of all the generated SQL files. in the output directory. |
| FDPSOFT_OUT_EXECUTE_SQL | Whether or not the SQL files were automatically executed. |
Artifacts
This operation doesn’t consume or produce any artifacts.
...