expressor communicator

expressor communicator is a reporting database that provides visibility into application projects and operations. It works with JDBC-based or ODBC-based off-the-shelf reporting tools and interfaces, and allows users to build custom reports for impact analysis, dependency tracking, dictionary and artifact usage, and operational statistics. For example, users can even leverage Microsoft Excel to swiftly create reports by running queries against expressor communicator.

expressor communicator consists of a read-only database optimized for report writing that mirrors the information in the expressor repositor database, allowing organizations to benefit from a separate reporting database. It exposes information stored in expressor repositor so that administrators can easily create queries to determine project status without degrading performance.

expressor communicator also provides a number of sample SQL report queries that cover a wide range of common reporting tasks and act as templates for developing custom reports. It currently includes 20 pre-written queries that simplify and automate reporting, such as “who created one of these items”, “who changed one of the items”, “report when a drawing was run”, and “list all the images defined in a project.”