DSharp.fi
  • Home
  • Solutions
    • DSharp PathFinder
    • DSharp Studio
    • DSharp Studio Modeler
    • Pricing and Licenses
  • Services
    • Professional services
    • DSharp Training Program and Certifications
    • Developer Support
  • Customers
    • Our Customers
    • Customer Success Stories
      • Pirte’s Data Platform Modernization Boosts Data-Driven Healthcare
      • A City Expanded Its Data Warehouse with Library Data
      • Varha – a wellbeing services county – built a data-driven management system
      • From Double Checks to Smooth Automation – DSharp Studio Simplified Early Childhood Education Data Management
      • Productivity Leap improved Metsähallitus’ data management with DSharp Studio
  • Partners
    • Our Partners
    • Partner Stories
    • Become a Partner
  • Resources
  • Articles
    • Data warehousing
      • Data Warehouse concepts and data models
      • DSharp Studio Release: Extended Data Catalog and New Find Command
    • Reporting automation
      • Automate data pipelines
      • Making Data Management Easier with Automation
      • Metsähallitus enhanced its data management with DSharp’s data platform tool
    • Data modeling and mapping
      • Data Warehouse concepts and data models
      • Data vs Business Driven Modeling
  • About
    • About us
    • Contact us
    • Recruiting
  • Book a Demo
  • Start a Trial
  • Menu Menu
  • Features
    • DSharp Studio Features
    • DSharp Studio Modeler Features
    • Command Reference
    • Release Notes
    • Installation Guide
  • Modeling
    • Design Considerations
      • Data vs Business Driven Modeling
      • The Business Key
    • Basics
      • Model Types
      • Archetypes
      • Datatypes
    • Raw Model
      • Source Mappings
      • Metadata
    • Business Model
      • Metadata
  • Course Material
    • DSharp Studio Professional Course
    • DSharp Studio Expert Course
  • Legacy
    • DSharp Engine Features
      • Mapping Source Data in DSharp Engine
    • DSharp Engine Command Reference
    • DSharp Engine Installation Guide
    • 3rd Party Modeling Tools
      • Visual Paradigm
        • Modeling With Visual Paradigm
        • Configuring Data Vault 2.0 And Servers
        • Implementing Mappings
        • Setting Up
          • Import Stereotypes
          • Configure UI
      • Ellie
        • Modeling With Ellie
        • Ellie Metadata
    • Course Material
      • Intro Course
      • Advanced Course
  • Community
  • FAQ

Instructions how to get the model to the point where it can be read by D# Engine.

Watch the video here.

Task Description
Open the Ellie Metadata reference
  1. Open the “Ellie metadata cheat sheet” and keep it available.
Start Ellie
  1. Log in to your Ellie account.
Create new Model for Person and Gender
  1. Click the + sign in the Models section of Ellie to create a new model.
  2. Name the model PersMaster person register (RM) and click Create.
Create class Person
  1. Add a new entity to the model using the Glossary search function: write the name of the entity to be added (Person) and click Create Person. The Person entity will then appear in the list below.
  2. Drag the Person entity to the model / diagram canvas.
  3. Right-click on the Person entity and set its Entity type to Master.
Add Person attributes
  1. Double-click the Person entity.
  2. Activate the Attributes tab.
  3. Click Edit.
  4. On the line labeled +New attribute, write Person Id and press tab (or click to the right of the field) so that the value registers and the entire edit row becomes visible.
  5. In the Data Type field, write hetu.
  6. Similarly, add the following attributes / data types
    1. Last name / lastname
    2. First names / firstnames
    3. Nickname / firstname
    4. Date of birth / birthdate
  7. Set Date of birth’s Rate of change to Never by adding the line Rate of change=Never; to the Notes field of the attribute. The parameter value can also be copied from the Ellie Metadata reference, from the Property Metadata Values section.
Set Person metadata
  1. Click the Metadata tab.
  2. Copy the entity template metadata for Master entities into the metadata text field.
  3. Set Implement to true.
  4. Set Key to Person Id.
  5. In the Ellie title bar, click on the model name to return to the diagram.
Create class Gender
  1. Write Gender in the Glossary search box, then click Create Gender.
  2. Drag the newly created Gender entity to the model.
  3. Right-click on the Gender entity and set its Entity type to Reference.
Add Gender attributes
  1. Double-click the Gender entity.
  2. Click the Attributes tab.
  3. Click Edit.
  4. Add the following attributes / data types
    1. Code / code
    2. Name / name
Set Gender metadata
  1. Click the Metadata tab
  2. Copy the entity template metadata for Reference entities into the metadata text field.
  3. Set Implement to true.
  4. Set Key to Code.
  5. In the Ellie title bar, click on the model name to return to the diagram.
Create relation between Person and Gender
  1. Move the mouse near the middle of the edge of the Gender entity, and when a circle is shown, press the left mouse button, drag towards the middle of the edge of the Person entity and release when a circle appears.
  2. Adjust the relation type of the Gender side of the relation so that it signifies a mandatory singular relation (a single short line crossing the association line). Do this by right-clicking the end of the relation.
Set the Person.Gender association end’s Rate of change to Never. This feature is not yet supported by Ellie.
Create a report for exporting the model
  1. Go to the Ellie home page by clicking either the company name or the Ellie logo in the Ellie toolbar.
  2. Click View all reports.
  3. Click Create report.
  4. Name the report DemoDW export.
  5. Under the Which models should be part of this report? prompt, write PersMaster and select the newly created model from the list that appears.
  6. Click Create report.
Export the model.
  1. Click Export.
  2. From the popup menu, select Export entities.
  3. Repeat for Export attributes and Export relations.
  4. Each export results in a ellie-report-DemoDW-Export*.csv file containing the partial model export. Copy or move these to your working directory. After this, D# Engine will read them when opened the next time.
  5. Remove any previous copies of the export files from your working directory.

  • Developer Content
    • No Access
    • Model Types
    • Archetypes
    • Datatypes
    • Source Mappings
    • Metadata
    • Metadata
    • Data vs Business Driven Modeling
    • The Business Key
    • DSharp Studio Professional Course
      • Tutorial 01: Person Tutorial
      • Tutorial 02: Add Attributes
      • Tutorial 03: Project Tutorial
      • Tutorial 04: Hash Error Handling
      • Tutorial 05: Simple Hierarchy
      • Tutorial 06: Transactions
      • Tutorial 07: Filtering Data
      • Tutorial 08: Loading Multiple Classes From One Source
      • Tutorial 09: Handling Legitimate Duplicates
      • Tutorial 10: Multiple Attribute Values
    • Intro Course
      • Intro Course – Before You Begin
      • Tutorial 01 – Visual Paradigm
      • Tutorial 01 – Ellie
      • Tutorial 01: Person Tutorial
      • Tutorial 02: Add Attributes
      • Tutorial 03: Project Tutorial
      • Tutorial 04: Hash Error Handling
      • Tutorial 05: Simple Hierarchy
      • Tutorial 06: Transactions
      • Tutorial 07: Changing Load Behaviour
      • Tutorial 08: Loading Multiple Classes From One Source
      • Tutorial 09: Handling Legitimate Duplicates
      • Tutorial 10: Multiple Attribute Values
    • Advanced BDP Developer Course
      • Tutorial 01: Key Groups
      • Tutorial 02: Implementing the Participation Design Pattern
      • Tutorial 03: Versioned Source Data
      • Tutorial 04: Advanced State Handling
      • Tutorial 05: Hierarchy Alternatives
      • Tutorial 06: Hierarchy Depth Changes
      • Tutorial 07: Partial Load Deletion Detection
      • Tutorial 08: Merge Hashes Non-Destructively
      • Tutorial 09: Implementing Business Objects
      • Tutorial 10: Custom Value Transformations
    • DSharp Studio Expert Course
      • Tutorial 01: Key Groups
      • Tutorial 02: Implementing the Participation Design Pattern
      • Tutorial 03: Versioned Source Data
      • Tutorial 04: Advanced State Handling
      • Tutorial 05: Hierarchy Alternatives
      • Tutorial 06: Hierarchy Depth Changes
      • Tutorial 07: Partial Load Deletion Detection
      • Tutorial 08: Merge Hashes Non-Destructively
      • Tutorial 09: Derived Classes
    • Mapping Source Data
    • Command Reference
    • Release Notes And Downloads
    • DSharp Studio Command Reference
    • DSharp Studio Command Reference
    • DSharp Studio Features
    • DSharp Studio Modeler Features
    • DSharp Studio Modeler Installation Guide
    • Installation Guide
    • Configuring Data Vault 2.0 And Servers
    • Modeling With Visual Paradigm
    • Implementing Mappings
    • Import Stereotypes
    • Configure Visual Paradigm UI
    • Modeling With Ellie
    • Ellie Metadata
  • Frequently Asked Questions

Finland
Yliopistonkatu 31, 20100, Turku
Bertel Jungin aukio 5, 02600 Espoo

Germany
Podbielskistrasse 333,
5th floor, 30659, Hannover

Solutions

  • DSharp Studio
  • DSharp Studio Modeler
  • Pricing and Licenses

FAQ

  • About us
  • Contact us
  • Recruiting

Legal

  • Privacy policy
  • DSharp Studio License Subscription Agreement

Contact us!

    © Copyright DSharp Oy
    • Link to LinkedIn
    • Link to Mail
    Scroll to top Scroll to top Scroll to top