ETL Independent Visual Data Mapping – DataDefractor Solo

1

Design

In the first phase one or more sample spreadsheets are passed on the input of DataDefractor Solo. With the help of DataDefractor Mapping Wizard, the user defines a dimensional model and a data mapping schema based on the sample set of worksheets.
2

Process

In the second  phase the previously designed mapping schema is used by DataDefractor Normalization Engine to parse and convert unlimited number of similar input spreadsheets into structured data models. 
3

Output

The output of  DataDefractor is either a flattened recordset CSV file or a set of CSV files in the form of a standard star schema.

Load

The output generated by DataDefractor Solo is “loading friendly”. It can be consumed by any data warehouse or business intelligence system.
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 including, but not limited to:

  • SAP NetWeaver
  • Informatica
  • SalesForce.com
  • Microsoft SQL Server*
  • Business Objects
  • Cognos
  • Microstrategy
  • IBM DB2 BI
  • Tableau Software
  • Oracle BI
  • Hyperion
  • and more

*See DataDefractor SSIS for more information about loading complex spreadsheets into SQL Server 2005/2008.

DataDefractor Solo User Guide
Compare DataDefractor Editions
DataDefractor Screenshots
Watch DataDefractor Solo Demo