Techniques for schema production and transformation are presented. Enterprise data from a plurality of data sources is analyzed to produce patterns to types of enterprise data. Merging rules group patterns together with entries across multiple schemas. Each schema associated with one of the data sources. A single entry is then produced within a single generic schema for each group of patterns. The generic schema can then be used to suggest changes to enterprise data policy and to make the enterprise data interoperable across the enterprise in an automated fashion.