Datamover Export and Import PeopleSoft

There are quite a few techniques available in PeopleSoft to export and import the table from the database, one of which is Datamover.
Data Mover Export
set log C:\EXPORT.log;                                                  — Place where log file is maintained
set output C:\QC146tabdmp.dat;                             — This is the place where the exported data is stored.
export FO_CSF_FIELD;                                                —  Table that needs to be exported.
export RS_ASSIGNMENT;
export RS_SO_HDR;
export CA_BI_DRIVER4;
Data Mover Import
set log C:\IMPORT.log;                                              — Place where log file is maintained
set input C:\QC146tabdmp.dat;                             — This is the place where the exported data is retrieved.
import FO_CSF_FIELD;                                             —  Table that needs to be imported from the .dat file.
import RS_ASSIGNMENT;
import RS_SO_HDR;
import CA_BI_DRIVER;
Note: PeopleSoft DataMover stores the exported file in as encrypted binary file and it cannot be reused in any other way, you can only use Datamover to export and import the dat file which the DataMover generates.
Advertisements

About Dinesh
PeopleSoft Consultant at fugoconsulting

One Response to Datamover Export and Import PeopleSoft

  1. Cheryl says:

    Great script. Thank you. Thank you. Thank you Dinesh!!!!! 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: