DataDefractor - convert complex Excel spreadsheets into structured data ready to be loaded or imported into any data warehouse through SSIS or any other ETL tool

Monday, February 08, 2010

You are here : Home

Home

Screenshots

Downloads

Documentation

Support

Purchase

About Us

Highlights

» Loading complex Excel spreadsheets into SAP NetWeaver BI

Step-by-step tutorial using DataDefractor Solo in conjunction with SAP BI to transform complex semistructured spreadsheets into SAP BI InfoCubes.

» Structuring the Unstructured

Read this white paper to learn about the architectural concepts behind DataDefractor.

Are you working on a data warehouse project? Never handcode another Excel or CSV extraction again!

DataDefractor

$DataDefractor - unlocking the value of your data$ 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.

» More about DataDefractor

Products

$DataDefractor SSIS$

DataDefractor SSIS Extend your SQL Server Integration Services (SSIS) with this add-in to convert complex spreadsheets directly into structured SSIS data flow output.
Learn more \| Download	$View DataDefractor SSIS demo$

$DataDefractor Solo$

DataDefractor Solo Use this ETL-independent edition of DataDefractor to transform your business spreadsheets and reports into structured flat-file data marts.
Learn more \| Download	$View DataDefractor Solo demo$

» Compare DataDefractor Editions

Announcements

Released DataDefractor 1.1 SR12

Stability release. See Solo and SSIS release notes.

Released DataDefractor 1.1 SR11

Stability release. See Solo and SSIS release notes.

Released DataDefractor 1.1 SR10

Support for SQL Server 2008 and Windows Server 2008. See Solo and SSIS release notes.

Testimonials

Crispin Proctor, MVP, Business Intelligence Developer
"It is a menial task to extract data from Excel. Without DataDefractor, reams of custom code would be needed."
» Read more

David Waterworth, Senior Quantitative Analyst
"DataDefractor allowed us to replace complex and hard to maintain SSIS scripts in a matter of hours."
» Read more