DataDefractor.com offers tools to work with complex Excel spreadsheets
Title
DataDefractor - extract and dimensionalize data from semi-structured Excel/CSV spreadsheets and load it into any data warehouse or RDBMS: SQL Server, Oralce, IBM DB2, SAP BW, etc.
Description
DataDefractor is a data processing tool designed to dimensionalize and extract data from semi-structured data sources such as Microsoft Excel or CSV reports and spreadsheets. With the help of its wizard-driven user interface you can map-out the rules that define the dimensional models captured in a your semi-structured spreadsheets and convert them into structured Kiball-style star-schema dimensional models.
DataDefractor can be used as a standalone application to generate portable star-schemas or can be integrated with SQL Server Integration Services (SSIS) to generate the star-schemas directly on the SSIS pipeline.
Typical use-case scenarios for DataDefractor include extracting and normalizing fact and dimensional data from semi-structured enterprise Excel spreadsheet reports, Excel PivotTable reports, flat files, text files and CSV files and feeding it into an enterprise data warehouse, a data mart or an OLAP cube.
Logos
External Links
- 2005
- Business Intelligence
- CSV
- Component
- Convert CSV
- Convert Excel
- DNN
- Data
- DataDefractor
- Data Extract
- Data Flow Source Component
- Data Format
- Data Source
- Data Warehouse
- Dimension Data
- DotNetNuke
- ETL
- Excel
- Excel Data Import
- Excel PivotTable
- Excel Table
- Excel Workbook
- Excel Worksheet
- Fact Data
- Fact Table
- File Format
- Format Report
- Integration
- Interactive Edge
- Multidimensional Data
- NET
- OLAP
- Pivot
- SQL
- SQL DTS
- SQL Server
- SQL Server 2005
- SSIS
- Server
- Services
- Transformation