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

• Maximize the value of data from any typical enterprise report or data dump
• Load reports, spreadsheets and data tables without manipulating the source, or writing a single line of code
• Develop solutions quickly and easily using a unique wizard-driven interface
• Increase enterprise productivity by using systems that are designed for maximum re-use across multiple projects

Key Features

Nested multi-paged data sources Automatic report header discovery Flexible fact region definitions Freeform dimension attribute modeling Regular-expression-based attribute stream extractions Cross-tab/cross-axis attribute stream modeling Multi-report loading (the same extraction schema could be applied to multiple input records) Automatic surrogate key generation 64-bit platform support Extract information from: Microsoft Excel 97-2003 and Microsoft Excel 2007 workbooks (low level file access - no Microsoft Excel installation required) Raw text files Microsoft SQL Server 2005 / Microsoft SQL Server 2000 / Microsoft SQL Server 7 Oracle 8/9/10 Any ODBC data source

Please visit the official DataDefractor website for more information, including the opportunity to try it for free