expressor constructor

expressor constructor is a Windows spreadsheet-based desktop application targeted at data stewards and data analysts tasked to define semantic definitions and describe simple business rules based on these definitions. It has an interface integrated with Microsoft Excel that allows users to easily add metadata and business rules. For convenience, expressor constructor has both a spreadsheet interface and a wizard interface.

For example, a user can add or import field names and the wizard will suggest rationalized names. Once the rationalized names are selected, the user can write business rules. This architecture provides a virtualization layer so data analysts can concentrate on creating and validating the business rules without being distracted by the complexities of the external data structures. It allows data analysts to define target-centric business rules that can be checked-into expressor repositor and shared across projects. These rules are then automatically suggested to the ETL developer in expressor illustrator.