Design and connect data

With just a few clicks you can draw data from other locations, quickly enabling you to link datasets and extract and load information into a FastStats data analysis and visualisation system. You can also link data tables and specify join relationships.

Extract even more value from the data you collect by transforming it into a structure most useful for marketing purposes. By combining data from multiple sources you can create a single view, allowing accurate and in-depth marketing analysis and reporting – all at speed.

Attach to standard data sources with ADO.Net providers, OLE DB, or ODBC databases, delimited, and fixed column files. FastStats Designer also auto detects the name, size, data type, and content of variables.

Delta updates improve the build speed and reduce the load on your data sources by only extracting and applying changes, instead of rebuilding entire tables for every build – perfect for large databases. FastStats Designer manages the extract process and applies updates, deletes and appends as necessary to produce a valid and consistent FastStats system.

FastStats Designer supports the Salesforce Bulk Query API V2. Metadata is retrieved via the Salesforce APIs and used in the build definition. Salesforce data types are mapped to FastStats types and heuristics are applied to create a sensible default folder structure. Delta updates and download compression are supported, minimising data retrieval size and time.