Frakture's process of pulling data from remote systems (such as your CRM or advertising platform), then re-shaping it into our standard outputs, and finally storing it in your data warehouse is known in the industry as Extract, Transform, Load, or ETL for short.

ETL does just what it sounds like:

• Extracts the data from your source system
• Transforms it into a standardized shape, ready for automated handling
• Loads it into the target database warehouse

In fact, Frakture proceeds yet another step beyond the ETL stack. Once your warehouse data is all loaded in, Frakture

• Analyzes the data with its source code engine, building out powerful new cross-channel information that's only attainable in the warehouse

Schemas

Documentation on the standard database schema, with standardized fields is available here.