Visual Data Mapping and Processing

DataDefractor™ is a visual data mapping and processing tool designed to automate the transformation of complex Excel and CSV spreadsheets into structured data delivered in a form suitable for loading into any data visualization application, data warehouse, OLAP cube or any Business Intelligence system.

DataDefractor SSIS™ is a custom SQL Server 2005/2008 Integration Services (SSIS) data flow source component designed specifically for Microsoft Business Intelligence developers. It helps import complex business Excel and CSV spreadsheets into the SSIS pipeline. It converts the input spreadsheets into structured normalized data output which is pumped directly into the SSIS data flow pipeline. DataDefractor SSIS integrates with SQL Server Business Intelligence Studio. DataDefractor SSIS is available in a Developer as well as an Enterprise Edition.

DataDefractor Solo™ is the ETL-independent edition of DataDefractor. Unlike DataDefractor SSIS, DataDefractor Solo runs as a standalone Windows application which converts complex business spreadsheets into structured data marts stored in the form of portable flat-file CSV files. DataDefractor Solo targets Business Intelligence developers working with a wide variety of BI, data warehouse and ETL platforms.

“As an insurance company we often have a requirement to extract key data from Excel spreadsheets for use in other applications. The variety in source files we encounter means that it is not possible to use the default SSIS adapters without extensive additional work. What we needed was a simple solution that allows us to extract the data required in as uncomplicated and easy to maintain manner as possible – this is where DataDefractor comes in.”