The following diagram demonstrates a typical DataDefractor Solo usage scenario:
- During the first phase, also known as "the design 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.
- In the second "processing" 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. 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.
- The output generated by DataDefractor Solo is "loading friendly". It can be consumed by any data warehouse or business intelligence system including, but not limited to:
- SAP NetWeaver BI
- Microsoft SQL Server*
- Business Objects
- IBM DB2 BI
- Tableau Software
- Oracle BI