DMS Viewer

Upload, inspect, and extract data from PeopleSoft Data Mover (.dat) export files.
Categories:
Tags:

What It Is

PeopleSoft Data Mover is commonly used to export data from tables to proprietary .dat binary files for backup, migration, or archiving.

The DMS Viewer in psLens allows you to upload and inspect these binary Data Mover .dat files directly in your web browser. You can inspect table counts, view schema columns, browse exported rows, and generate SQL INSERT statements for individual rows without launching Data Mover or running an import.

Uploading a DMS File

URL: /dms-viewer

To parse a DMS file:

  1. Go to the DMS Viewer page.
  2. Select or drag-and-drop your .dat file (up to 50MB) into the upload area.
  3. The server will parse the binary file structure and display its metadata.

File View

After parsing, the DMS file metadata is shown:

  • DMS File Metadata: Source database name, Data Mover export version, base language, export start timestamp, table count, and total row count.
  • Tables list: An index showing all tables exported in the .dat file along with the number of rows exported for each table. Clicking any table name opens its detail view.

Table detail and Row Browser

Inside a table’s view, you can browse its columns and rows:

  • Columns list: Shows the fields/columns defined for the table in the export.
  • Row Grid: Displays the exported rows in a paginated table (100 rows per page).
  • SQL INSERT Generator: Click the Generate SQL action on any row. psLens will reconstruct a standard SQL INSERT statement for that specific row’s data and display it in a copyable text area. Use this to grab a single config row out of a DAT file without running a full import.