Advertisement

The Biml Book

Business Intelligence and Data Warehouse Automation

  • Andy Leonard
  • Scott Currie
  • Jacob Alley
  • Martin Andersson
  • Peter Avenant
  • Bill Fellows
  • Simon Peck
  • Reeves Smith
  • Raymond Sondak
  • Benjamin Weissman
  • Cathrine Wilhelmsen

Table of contents

  1. Front Matter
    Pages i-xxxvii
  2. Learning Biml

    1. Front Matter
      Pages 1-1
    2. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 3-26
    3. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 27-56
    4. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 57-92
    5. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 93-118
    6. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 119-137
  3. Biml Frameworks

    1. Front Matter
      Pages 139-139
    2. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 141-198
    3. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 199-220
    4. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 221-238
    5. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 239-263
    6. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 265-274
  4. Biml Topics

    1. Front Matter
      Pages 275-275
    2. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 277-311
    3. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 313-330
    4. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 331-351
    5. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 353-371
    6. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 373-387
  5. Appendices

    1. Front Matter
      Pages 389-389
    2. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 391-412
    3. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 413-418
    4. Andy Leonard, Scott Currie, Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows et al.
      Pages 419-477
  6. Back Matter
    Pages 479-484

About this book

Introduction

Learn Business Intelligence Markup Language (Biml) for automating much of the repetitive, manual labor involved in data integration. We teach you how to build frameworks and use advanced Biml features to get more out of SQL Server Integration Services (SSIS), Transact-SQL (T-SQL), and SQL Server Analysis Services (SSAS) than you ever thought possible.

The first part of the book starts with the basics—getting your development environment configured, Biml syntax, and scripting essentials.

Whether a beginner or a seasoned Biml expert, the next part of the book guides you through the process of using Biml to build a framework that captures both your design patterns and execution management. Design patterns are reusable code blocks that standardize the approach you use to perform certain types of data integration, logging, and other key data functions. Design patterns solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, design patterns improve your efficiency as a Biml developer.

In addition to leveraging design patterns in your framework, you will learn how to build a robust metadata store and how to package your framework into Biml bundles for deployment within your enterprise.

In the last part of the book, we teach you more advanced Biml features and capabilities, such as SSAS development, T-SQL recipes, documentation autogeneration, and Biml troubleshooting.

What You'll Learn:
  • Master the basics of Business Intelligence Markup Language (Biml)
  • Study patterns for automating SSIS package generation
  • Build a Biml Framework
  • Import and transform database schemas
  • Automate generation of scripts and projects

Keywords

Business Intelligence Markup Language SSIS SQL Server Integration Services Cubes Data Integration Lifecycle Management DILM

Authors and affiliations

  • Andy Leonard
    • 1
  • Scott Currie
    • 2
  • Jacob Alley
    • 3
  • Martin Andersson
    • 4
  • Peter Avenant
    • 5
  • Bill Fellows
    • 6
  • Simon Peck
    • 7
  • Reeves Smith
    • 8
  • Raymond Sondak
    • 9
  • Benjamin Weissman
    • 10
  • Cathrine Wilhelmsen
    • 11
  1. 1.FarmvilleUSA
  2. 2.GreerUSA
  3. 3.SimpsonvilleUSA
  4. 4.BillebergaSweden
  5. 5.ErinaAustralia
  6. 6.Kansas CityUSA
  7. 7.ChristchurchNew Zealand
  8. 8.HIGHLANDS RANCHUSA
  9. 9.VoorburgThe Netherlands
  10. 10.NuernbergGermany
  11. 11.HaganNorway

Bibliographic information