SQL Access & Visual Query Builder
RCM Desktop Ultimate Edition provides full SQL access to all the tables in the RCM database.
This is intended for expert users who require the ability to run complex queries in order to view and/or export any of their raw RCM data for whatever reason (such as exporting a list of failure modes to a CMMS). Any standard SQL query can be executed provided it does not attempt to update any data or amend any data definitions. A visual query builder is provided which permits building complex SQL queries via an intuitive visual query building interface. To work with the Query Builder you need basic knowledge of SQL concepts. The Query Builder will help you to write correct SQL code, hiding technical details, but an understanding of SQL principles is still required to achieve the desired results. SQL queries can be saved for re-use. Query output can be printed or exported to disk in XML, HTML, XLS and plain text formats. |