Introduction to PeopleSoft Data Mover

PeopleSoft Data Mover Scripts is a utility can be used to migrate data from one PeopleSoft database to another, or to move data between PeopleSoft environments, such as from a development environment to a production environment. Data Mover scripts help to automate the process of migrating data.

Data Mover processes the text files that contain a series of commands that the Data Mover utility will execute to perform a specific task, such as copying data from one table to another or exporting data to a file.

Sample PeopleSoft Data Mover Script

Here is a sample PeopleSoft Data Mover script that demonstrates how to export data from a PeopleSoft table and import it into another PeopleSoft database.
/* Export data from PS_JOB to a file */

/*You must specify a name of the file for the SET LOG statement or else a log file is not created */
SET LOG C:\TEMP\JOB_TBL.LOG; 

SET OUTPUT C:\TEMP\JOB_TBL.DAT; 

EXPORT PS_JOB ;

/* Import data from the export file into the target database */

SET LOG C:\TEMP\JOB_TBL.LOG; 
SET INPUT C:\TEMP\JOB_TBL.DAT; 
SET NO SPACE; /*Prevents tablespaces from being created.*/
SET NO RECORD; 
SET NO INDEX; 
IMPORT *; /* Insert data into tables using the information in an export file */
/* Verify that the import was successful */ 

SELECT COUNT() FROM PS_JOB;

In this example, the script first exports data from the PS_JOB table to a file located at /temp/ps_job_export.txt. The script then imports the data from the export file into the target database. Finally, the script selects the number of rows in the PS_JOB table to verify that the import was successful.

When running this script, it is important to ensure that the PeopleSoft database is set up correctly and that the appropriate Data Mover environment variables are set. These variables define the connection information for the source and target databases, as well as other important configuration settings.

Demo example

Navigation : Go > Data Mover and the below window will open

Data Mover Peopesoft
Data mover script
Data Mover Peopesoft
Data mover Script in source instance
Data Mover Peopesoft
The Data mover in target instance

Conclusion

PeopleSoft Data Mover scripts are an essential tool for managing and transferring data between PeopleSoft databases. With the help of Data Mover scripts, you can automate the process of migrating data, saving time and reducing the risk of errors. The sample script above demonstrates how to export data from a PeopleSoft table and import it into another PeopleSoft database.

Click here to learn about sending an email using generic template.

By admin

One thought on “How to use Data Mover Script in peoplesoft”

Leave a Reply

Your email address will not be published. Required fields are marked *