Example Running Data Mover PeopleSoft

PeopleSoft Financials and Supply Chain Management  (FSCM 9.2) Directory:

FSCM_HOME=/home/oracle/peoplesoft/PT9.2
export $FSCM_HOME

Syntax of Data Mover Scripts:

Usage: psdmtx [-CT DB2|DB2ODBC|DB2UNIX|INFORMIX|MICROSFT|ORACLE|SYBASE]
[-CS server name]
[-CD database name]
[-CO user id]
[-CP user pswd]
[-CI connect id]
[-CW connect id pswd]
[-I  process instance]
[-FP filename]
 or
psdmtx [parmfile]

Example:
[oracle@ptud1 PT8.54]$ $PS_HOME/bin/psdmtx -CT ORACLE -CS ptudvtg149 -CD FIN92DMO -CO SYSADM -CP SYSADM -CI people -CW people -FP /home/oracle/peoplesoft/PT9.2/scripts/fin92dmoora.dms

PeopleTools 8.54 - Data Mover
Copyright (c) 2015 PeopleSoft, Inc.
All Rights Reserved

Started:  Tue Jul 14 17:09:40 2015
Data Mover Release: 8.54
Database: FIN92DMO (ENG)
Input file: /home/oracle/peoplesoft/PT9.2/data/epzhsa.db (ENG

-CT ORACLE : The type of database to connect to.
-CS ptudvtg149 : Server name
-CD FIN92DMO :  database name
-CO SYSADM : user id
-CP SYSADM : user id password
-CI people : connect id
-CW people : connect id password
-FP /home/oracle/peoplesoft/PT9.2/scripts/fin92dmoora.dms  The filename for the Data Mover import script (DMS) to run. < $FSCM_HOME/scripts/ora.dms>

Share this

Vtgdb