1 / 28

Biml en Data Vault

Biml en Data Vault. Sander van der Hoeff. Microsoft BI Specialist Zelfstandig (trail)Runner The Future Group = Maatschap van ZZP'ers. Wat is Data Vault. Data Vault. Architectuur voor Datawarehouse laag Schaalbaar Parallellisme wordt aangemoedigd

zhen
Download Presentation

Biml en Data Vault

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Bimlen Data Vault

  2. Sander van der Hoeff • Microsoft BI Specialist • Zelfstandig • (trail)Runner • The Future Group =Maatschap van ZZP'ers

  3. Wat is Data Vault

  4. Data Vault Architectuur voor Datawarehouse laag Schaalbaar Parallellisme wordt aangemoedigd Kan nieuwe domeinen absorberen

  5. Core Components Data Vault • Hub = Business Key • Link = Verbinding Business Keys • Satellites = Attribute information

  6. Wat is Biml Business Intelligence Markup Language From Wikipedia, the free encyclopedia Business Intelligence Markup Language (Biml) is a domain-specific XML dialect for defining business intelligence (BI) assets. Biml authored BI assets can currently be used by the BIDS Helper add-on for Microsoft SQL ServerBusiness Intelligence Development Studio(BIDS) and the Varigence Mist integrated development environment; both tools translate Biml metadata into SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) assets for the Microsoft SQL Server platform. However, emitters can be created to compile Biml for any desired BI platform. While Biml’s declarative design is sufficient to author BI assets, BimlScript extends the language by enabling authors to embed C# orVB.NET code within Biml, similar to how ASP.NET includes .NET code within static HTML markup.[3] BimlScript is used to merge changes into existing Biml assets, automatically generate Biml code, and apply changes across multiple Biml files during compilation.

  7. Waarom Generen Veel Tabellen Veel Packages Minder fouten Standaard Tabellen HULPMIDDEL, kan ook zonder

  8. Waarom Genereren Data Vault Veel en Standaard Tabellen

  9. Sounds Familiar? DMT DMT Project Project Project DMT Project Project Project Project Project Project Project Project Project Project Project Project SRC DWH

  10. Opties tot genereren TSQL MIST (Varigence) BiXPress (Pragmatic Works) Quipu DWHDeck Others

  11. SSIS vs tSQL Standaard Logging Standaard Monitoring Standaard Fout Afhandeling

  12. Tables tSQL Metadata tabellen Ontstaan vanuit Templates

  13. Waarom Biml Gebruikt SSIS XML Based Exception Driven Open Source Geen Api kennis vereist Kennis van SSIS noodzakelijk BIDSHelper

  14. Exception based

  15. Bronlaag (Navision) Per Bedrijf (1000+) een set van 3500 tabellen Meerdere databases? Partieel laden?

  16. Hubs Meervoudige keys concateneren Naamgeving uniform door Views Een package voor alle hubs Serieel laden (niet Data Vaultstandaard)

  17. Hubs meerdere bronnen Alles varchar Select key from order Select key1_key2 from Orderregel Onderhouds issue Een package of package per Hub?

  18. Links Naamgeving standaardiseren door views Een package voor alle links Niet parallel

  19. Satellites • Verschilvergelijking dmv Hashbytes • In de package met een task of in een stored procedure? • Iedere satellite is verschillend • Package per satellite • Package is standaard op Attribuutvelden na

  20. Datamart Transformatie tot Bussines logic Copy Paste View laag op DWH, een op een transfer van data naar Datamart laag

  21. DatamartPackageBiml Logging en config management ontbreken

  22. Logging en Packageconfig toevoegen

  23. Meer Lezen http://bimlscript.com/ http://biml101.blogspot.nl/ http://varigence.com/

More Related