ETL Generation using BETL

Contents

  • What is ETL generation
  • BETL
    • Architecture
    • Simple demo AdventureWorks
    • Advanced demo Datavault 
    • Advanced features
  • Questions

What is ETL Generation

Text

Text

Text

ETL Example using SSIS

BETL

- Open source (GNU GPL)

- 100% T-SQL

- Simple

- https://github.com/basvdberg/BETL

- http://www.biblog.nl

BETL Architecture

Demo AdventureWorks

needed

  • target schema
  • ETL template

Demo AdventureWorks

needed

- target schema

   

   exec betl.def.set_target_schema

            '[AdventureWorks2014]'

           , '[My_Staging].[dbo]'

 

- ETL template

 

   exec betl.def.setp 'template_id', 1, '[AdventureWorks2014]'

Demo Datavault

Advanced features

  • Logging
    • batch, transfer, transfer_log, error
  • Guessing

Questions

BETL: the simple ETL generation engine

By Bas van den Berg

BETL: the simple ETL generation engine

BETL is an ETL generation engine made in Transact SQL (MS SQL Server)

  • 391
Loading comments...