HP Structured Records Management Solution Tutorial, August 2011

50 Chapter 7: Querying the archive
Record Query Server (RQS) in HP TRIM provides you with direct query access to
your data without reloading it into a relational database. Using RQS, you can
access your data using standard SQL reporting and development tools on
Windows and UNIX. You can even join your archived data with existing data in a
database.
• Creating user collections (page 50)
• Querying your collection in Microsoft Office Excel (page 51)
Creating user collections
An archive data collection is file system or backend locations of archived XML
and XSD files. Creating the collection enables the Record Query Server to view
the files. You create a collection from HP TRIM.
To create a user collection:
1 In HP TRIM, locate the folder that contains the XML documents generated by
your cartridge.
2 Right click the folder and choose Send To > Prepare for RQS. The RQS login
dialog box displays.
3 The default username and password is install and OA, respectively.
TIP HP TRIM will attempt to connect to the Record Query Server on the host
and port specified in srmsTRIMAddIn.xml (RQSHost and RQSPort).
4 The first time you perform this process, select NONE for Extent.
TIP For subsequent collections, you can choose SCHEMA or ALL. SCHEMA
drops your previously created collection before creating the new one. ALL
drops all previously created schemas before creating the new one.