Verifying PO data transfer to PME

After a PO to PME ETL job runs successfully, you can check the database to verify that the data transfer occurred for a PO source device.

Prerequisites

  • You need to know the SourceID of the PME source in question. You can find this information in the ION_Data database. SeeVerifying PO sources in PME for details on how to obtain this value.

To verify PO data transfer to PME:

  1. In Microsoft SQL Server Management Studio, click New Query.
  2. Select a device whose data you want to verify by obtaining its SourceID.
  3. Enter and execute the following query:

    SELECT * FROM ION_Data.dbo.DataLog2 WHERE SourceID = DeviceSourceID

    The query returns all data for all quantities under that SourceID.