D# Engine’s relevant functionality will be presented in tutorials. Different tutorials highlight different aspects of D# Engine. Main focus is on Data Vault 2.0 features, but also other productivity features will be covered when they are a natural step within a tutorial.
The tutorials are written with no particular modeling tool in mind, and model screenshots are from D# Engine, unless otherwise noted.
Quick Links
Tutorial Info
| Page | Content |
|---|---|
| Before You Begin | Preparations and general tips. |
Modeling
| Page | Content |
|---|---|
| Archetypes | Describes the Archetypes that should be assigned to all classes in the model. |
| Datatypes | Description of datatypes for use with the attributes. |
| Source data mappings | Describes the columns of the mapping files. |
| Metadata | Describes the class and property metadata parameters that quide the automation process when generating database tables and procedures. |
Ellie
| Page | Content |
|---|---|
| Getting Started With Ellie | Description of Ellie’s most relevant features. |
| Ellie Metadata | Describes how to apply metadata to the Ellie elements. |
| Tutorial 01 using Ellie |
Step-by-step instructions how to build the first tutorial’s model using Ellie (also video). |
| Tutorial 01 using Ellie (video) | Step-by-step instructions how to build the first tutorial’s model using Ellie. |
Visual Paradigm
| Page | Content |
|---|---|
| Getting Started With Visual Paradigm | Description of Visual Paradigm’s most relevant features. |
| Import Stereotypes | Describes how to set up Visual Paradigm for modeling by importing the necessary stereotypes. |
| Import Stereotypes – video | Video showing how to import the stereotypes. |
| Set Classic UI Mode – video | Video showing how to set the Classic UI for Visual Paradigm. Tutorial videos and VP instructions assume the Classic UI is in use. |
| Configure Panes – video | Video showing how to configure the Panes in the VP UI in a working layout. |
| Tutorial 01 using Visual Paradigm |
Step-by-step instructions how to build the first tutorial’s model using Visual Paradigm. |
| Tutorial 01 using Visual Paradigm – video | The Visual Paradigm-part of the tutorial as a video. |
Tutorial List
| Tutorial | What We Learn |
|---|---|
| 01. Person Tutorial | Basic hub / satellite functionality, and the difference between green Party-Place-Thing- and blue Description-classes. We see how satellites and PiT-tables behave and how the view layer handles multiple sources and history data. |
| 02. Add Attributes | Deploying new content that extends an existing class with new attributes. |
| 03. Project Tutorial | Deploying new content that extends the model, but does not add elements to existing objects. How yellow Role classes are converted to standalone links, how state tracking works for previously loaded data that does not exist in the source anymore, as well as how soft deletion can be implemented in the view layer. |
| 04. Hash Error Handling | Handling hash errors so that they do not crash the target table load process. |
| 05. Simple Hierarchy | How self-referencing hierarchical structures behave in different situations. |
| 06. Transactions | How transaction-type data translates to a non-historized link table. Also how to perform custom or ad hoc transformations during load. |
| 07. Changing Load Behaviour | How to change load behaviour by changing script code. |
| 08. Loading Multiple Classes From One Source | How to split source data into several classes. |
| 09. Handling Legitimate Duplicates | How to handle data sets that contain legitimate duplicates. |
| 10. Multiple Attribute Values | How to handle the case where an attribute has several values. |
