ETL Generation using BETL

Contents

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

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

https://github.com/basvdberg/BETL

 

www.biblog.nl