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)

PeopleSoft JDBC Driver Path

FDPSOFT_JDBC_DRIVER_PATH

Yes

Classpath for locating the JDBC Driver ( For example, /u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc6.jar).

PeopleSoft JDBC URL

FDPSOFT_JDBC_URL

Yes

The JDBC URL of the database.

Connecting to Oracle Autonomous Database

You will need client credential zip file (wallet) to connect with Oracle Autonomous Database on Oracle cloud. You can download wallet zip file from Oracle Cloud, you will need admin userid and password to perform this download.See Download Client Credentials (Wallets) for more details on how to download wallet file.

You must make sure that only authorized users have access to these wallet files. Unzip the client credentials zip file (wallet_databasename.zip) on endpoint where it will be used, which most likely will be FlexDeploy server as we generally use localhost endpoint for JDBC. For example, /home/flexdeploy/.wallets/<wallet_databasename> is folder where specific wallet file was unzipped. Make sure to secure this folder to FlexDeploy and/or Endpoint user, so that it is not readable by all users.

• Database URL Syntax : jdbc:oracle:thin:@service_high?TNS_ADMIN=/home/flexdeploy/.wallets/<wallet_databasename>

  • service_high is one of the entries in the tnsnames.ora file where client credentials zip file was unzipped. See Predefined Database Service Names for Autonomous Database for details on services.

  • TNS_ADMIN value in URL points to the location of the unzipped client credentials zip file.

• Database URL Long Connection String Format Syntax : jdbc:oracle:thin:@(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=<hostname>))(connect_data=(service_name=<serice_name>))(security=(ssl_server_cert_dn="CN=<hostname>,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))

  • Examples for the same can be found here

PeopleSoft JDBC User

FDPSOFT_JDBC_USER

No

The username that will be used to connect with.

PeopleSoft JDBC Password

FDPSOFT_JDBC_PASSWORD

No

The password for JDBC User.

Data Mover Executable Path

FDPSOFT_DATAMOVER_EXE

Yes

The path to the Data Mover executable.

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.