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.