DataDefractor™ is a data processing component designed to extract and dimensionalize semi-structured data sources such as Microsoft Excel® or CSV reports and spreadsheets and convert them into standard Kimball-style dimensional star schemas. Once the data is extracted, DataDefractor feeds it into a collection of normalized CSV files ready to be loaded into any data warehouse or Business Intelligence system. Additionally, DataDefractor includes a special edition which is specifically integrated with SQL Server 2005 Integration Services and pumps its output directly into the SSIS pipeline.
Typical use-case scenarios for DataDefractor include extracting and dimensionalizing fact and dimensional data stored in complex semi-structured enterprise Excel® spreadsheet 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 typical ETL destination or transformation.