The Data Retriever is a PMDB utility that enables you to communicate with the database. You can create queries, send them to the PMDB, and receive the answers. The Data Retriever processes data structured in XML. To retrieve data, you must run the psin_http_requestor utility.
How to Retrieve Data from the PMDB
- Make sure a Precise Listener is installed on the server to which you want to retrieve data.
- Prepare an XML file in the retrieve request format containing all the required columns.
- Run the following command from the
<i3_root>directory:- Windows:
infra\bin\psin_http_requestor.exe -dp -x pw-data-retrieve PW < <file with retriever request> - UNIX:
./infra/bin/psin_http_requestor -dp -x pw-data-retrieve PW < <file with retriever>
- Windows:
The results are sent to the standard output. If you want to redirect the results to a file, use the > command.
Combining Data with Precise Data
To combine gathered data with Precise data, use the Report Manager’s customized reports, which provide Microsoft Excel output for your queries.
For information on how to integrate the newly created PMDB tables in customized reports and on how to retrieve the combined data, see the technical note Importing, exporting, and copying Customized Reports in Precise Report Manager and the Report Manager User’s Guide.