Reporting > Querying the repository with 3rd-party tools > Flattener (Normalized Table Builder)
  
Flattener (Normalized Table Builder)
Normalized Table Builder transforms a System Architect encyclopedia into a normalized relational database table structure that can be queried using standard structured query language (SQL). Normalized Table Builder provides an environment that the user can query using standard SQL with a response time that is not hindered by the parsing activity of the System Architect “memo” field
Normalized Table Builder is accessed by using SAEM (System Architect Encyclopedia Manager). It maps the System Architect repository to a flattened form, enabling you to run SQL queries against this static copy of the encyclopedia in SAEM or using third-party tools such as Crystal Reports.
See also
What the normalized table builder does
Using the normalized table builder
Example SQL queries
Performance
Querying the repository with 3rd-party tools