What's new in CHEF 4.0?

  • Define Catalog with multiple ETL Processes and their precedence of execution, queue the Catalog to execute all the ETL Processes in it with one go.
  • Assign same precedence for the multiple processes to execute them in Parallel with in the Catalog
  • While queuing choose the Processes and their precedence of Execution in the Catalog with XML based Process Options parameter
  • Also you can exclude steps or run a specific step with in ETL Process with XML based Process Options parameter
  • Turn Logging ON/OFF
  • Email Notification Configuration

CHEF - Common Hosted ETL Framework

  • CHEF is a metadata driven ETL Framework which generates dynamic SSIS package to support disparate data loading processes
  • Creates SSIS package dynamically for 100s of tables/queries from metadata, which otherwise required repetitive addition of SSIS tasks  
  • Supports bidirectional Data Transfer between SQL Azure, Windows Azure Table Storage and SQL Server Databases
  • CHEF gives out of box features like parallelism, lineage, data traceability, logging, scheduling and event handling
  • Automated and metadata driven, hence easy on development, maintenance and support
  • Built on SQL Server Integration Services and support for most commonly used SSIS task
  • Built-in minimum logging that provide snapshot of Data Loading
  • Ease to configure, maintain and use. Metadata update meets the need most of the time

CHEF-Value Proposition

  • Support enterprise application features like parallelism, data lineage, traceability,logging, scheduling and event handling
  • Reduce on-going maintenance overhead for disparate data loading processes
  • One Click Metadata driven ETL Tool
  • Absolute data traceability
  • Framework with out of box Logging and Error handling
  • Easy to on-board comes with installer
  • Adding new feeds is just a metadata change

CHEF Features

  • Parallelism, data traceability
  • SharePoint List Support
  • SQL 2012 support
  • Integration Services Catalogs
  • SQL Azure
  • Azure Windows Table Storage
  • Pre and Post Logging
  • Custom Variables i.e. runtime variable support
    • Multiple result set support
  • Error and Event Handing
  • Preserving auto generated packages in SSIS Catalogs with versioning
  • Maintain the Sequence of Task while creating the runtime SSIS packages
  • Data Flow Task
    • Source Column Data truncation for flat file sources
    • Parallel and Sequential Dataflow
    • Error Output records redirect to Flat File
  • Execute SQL Task
    • Parallel and sequential SQL Task
  • Execute Package Task
  • Email Task
  • DataFlowSet, SQLTaskSet
  • Source Column Data truncation for flat file sources.

Last edited Mar 25, 2014 at 10:07 AM by gmbabu, version 18