DataDefractor SSIS

Description

It helps import complex business Excel and CSV spreadsheets into the SSIS pipeline. It converts the input spreadsheets into structured normalized data output which is pumped directly into the SSIS data flow pipeline. DataDefractor SSIS integrates with SQL Server Business Intelligence Studio.View DataDefractor SSIS demo The following diagram demonstrates the execution workflow of an SSIS package which uses the DataDefractor SSIS data flow component:DataDefractor - How it works 1. DataDefractor SSIS uses a standard SSIS connection manager to connect to one or more sample spreadsheets. 2. In design-time, the SSIS developre uses DataDefractor Mapping Wizard to define a dimensional model and a data mapping schema based on the sample set of worksheets. During run-time DataDefractor SSIS uses this schema to parse and convert the input spreadsheets into a structured data model which is pumped directly into the SSIS output pipeline in the form of a star schema. At this point, the output can be transformed, mapped to existing data structures, used to create new data marts or be appended to existing data warehouse schemas using standard SSIS data flow transformation and destination components.Additional DataDefractor SSIS features include: * 64-bit platform support Unlike the standard Excel SSIS source, DataDefractor SSIS was specifically designed to support the 64-bit edition of SSIS. * Support for the new Excel 2007 format DataDefractor SSIS extracts data from the new Excel 2007 OpenXML format by using direct XML-package access. * Support for Excel 2000-2003 binary format DataDefractor SSIS performs low level BIFF read to access the bynary Excel file format. It does not need legacy ISAM drivers or Excel components to be installed on the target machine. * Advanced Excel formatting options DataDefractor SSIS provides a wide variety of options to interpret Excel formatting. It resolves the formatting issues associated with the standard SSIS Excel data flow source.. 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. 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.

Datadefractor - Excel - Sql Server - Sql Server 2005 - Sql Server Data Transformation Services - Sql Server 2005 Integration Services - Sql Dts - Ssis - Data Flow Source Component - Convert Excel - Excel Data Import - Excel Table - Excel Worksheet - Excel Workbook - Excel Pivottable - Csv - Convert Csv - Pivot - Data Extract - File Format - Data Format - Format Report - Etl - Data Warehouse - Business Intelligence

Published By:Interactive Edge

License Type:Freeware

Date Added:07 April, 2011

Version:1.1 SR-7

Price:Free

Downloads:40

Size:4.7 MB

Platform: Win Vista/2000/2003/XP

What people say
- required fields
     
Related Downloads

A-PDF AutoCAD to PDF is a fast, affordable way to batch convert AutoCAD Drawings into professional-quality documents in the popular PDF file format. Its easy-to-use interface allows you to batch create PDF files even support monitor hot directory.

DateSep 25, 2014

AuthorA-PDF.com

Size:3.9 MB

LicenseShareware

Price:$39.00

PlatformWinNT 4.x, WinXP, Windows 2000, Windows 2003

CategoryOffice Suites & Tools

A-PDF AutoCAD to PDF

A-PDF Content Splitter is an utility that lets you split Acrobat files into smaller pdf files base on location and text information within the files.

DateSep 25, 2014

AuthorA-PDF.com

Size:2.8 MB

LicenseShareware

Price:$59.00

PlatformWinNT 4.x, WinXP, Windows 2000

CategoryOffice Suites & Tools

A-PDF Content Splitter

A-PDF Creator is a PDF virtual printer for Windows that allows you to create PDF files easily.

DateSep 25, 2014

AuthorA-PDF.com

Size:3.5 MB

LicenseShareware

Price:$27.00

PlatformWinNT 4.x, WinXP, Windows 2000, Windows 2003

CategoryOffice Suites & Tools

A-PDF Creator

A-PDF Deskew provides a quick way to correct the skew scanned image in Acrobat PDF documents or TIFF files directly. It detects tilt images and straightens them automatically.

DateSep 25, 2014

AuthorA-PDF.com

Size:2.1 MB

LicenseShareware

Price:$27.00

PlatformWindows, Win98, WinME, WinNT 4.x

CategoryOffice Suites & Tools

A-PDF Deskew

A-PDF DjVu to PDF is a fast, affordable way to batch convert DjVu documents into professional-quality documents in the popular PDF file format. Its easy-to-use interface allows you to batch create PDF files even support monitor hot directory.

DateSep 25, 2014

AuthorA-PDF.com

Size:3.0 MB

LicenseShareware

Price:$39.00

PlatformWinNT 4.x, WinXP, Windows 2000, Windows 2003

CategoryOffice Suites & Tools

A-PDF DJVU to PDF