DataDefractor™ is a custom Microsoft SQL Server 2005 Integration Services (SSIS) data flow source component, which extracts fact data and dimensional metadata from various unstructured and semi-structured data sources and feeds it into the SSIS pipeline.

Typical use-case scenarios for DataDefractor include extracting fact and dimensional data from unstructured enterprise Excel worksheet reports, Excel PivotTable reports, flat files, text files and CSV files and feeding it into an enterprise data warehouse, a data mart, directly into a Microsoft SQL Server Analysis Services OLAP cube or any destination or transformation supported by SQL Server 2005 Integration Services.