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 tutorial model file
  1. Open Visual Paradigm and run the File -> Open Project command
  2. Navigate to and open the tutorial model [D# Engine installation folder]\Workspace\ExternalModels\Training\Tutorial\DemoDW\DemoDW.vpp.
Create subfolder (UML Package) for PersMaster
  1. Right-click on the Source models folder in Visual Paradigm
  2. Select Model Element -> Package from the pop-up menu, and a new Package will be created.
  3. Write the name of the package in the Package Specification window that pops open, for example PersMaster person register
  4. Click OK.
Create new Class Diagram for Person and Gender
  1. Right-click on the newly created folder, select Sub Diagrams -> New Diagram… from the pop-up menu and a diagram creation dialog pops up.
  2. In the search box, start writing class diagram, until the Class Diagram item becomes selected in the diagram type list.
  3. Double-click on the Class Diagram item.
  4. On the next page that opens, double-click the Blank template to create the diagram.
  5. Adjust the diagram’s name in the last step and click OK to create the diagram.
  6. Once the diagram is visible, click on it to exit the diagram name editor.
Create class Person
  1. From the palette on left side of the diagram window, drag a Class element onto the diagram.
  2. Release the mouse, and the class is created in edit mode.
  3. Write the class name “Person”
  4. Press return.
Create associated class Gender
  1. Grab the association tool above the right-side corner of the class in the diagram, and drag it to the right.The tool becomes visible when the mouse pointer is above the class.
  2. Release the mouse button while inside the diagram area.
  3. From the association type selector that opens, select association type Association -> Class (fourth from the left, top row), and a new class is created in edit mode, connected to the Person class.
  4. Call the class “Gender”.

The selected association type will from this point on be visible in the default section of the association type selector (upper left corner of the box).

Add Person attributes
  1. Right-click on the Person class and from the context menu select Add -> Attribute, or press alt-shift-A.
  2. In the attribute editor, press the delete key twice, deleting the dash-sign (“-“) before the attribute name.
  3. Write a plus-sign and then proceed to write the attribute name, Person Id followed by a colon and the name of the datatype to assign to this attribute, hetu.
  4. Press return. The attribute should look like +Person Id : hetu
  5. Repeat the process for these attributes (note that the + -sign will now be the default):
    1. Last name : lastname
    2. First names : firstnames
    3. Nickname : firstname
    4. Date of birth : birthdate
  6. Having pressed return after the last attribute, you are in edit mode, ready to write a new attribute. At this point press Esc to exit the attribute editor.
  7. Click the mouse on the diagram, outside the class.
Add Gender attributes Similarly to the last step, add the following attributes to the Gender class:

  1. Code : code
  2. Name : name
Set multiplicities
  1. Right-click near the end of the association line between Person and Gender.
  2. From the pop-up menu, select
    • Multiplicity -> 1 for the Gender end of the association.
    • Multiplicity -> 0..* for the Person end of the association.
Set both classes’ Implement metadata parameter to True
  1. Click on the Person class in the diagram. In the Property pane, you should see the UML Tagged values assigned to the class.
  2. Locate the Implement Tagged value.
  3. From its dropdown box, select True.
  4. Do the same for the Gender class.
Set Person.Person Id as Business key.
  1. Right-click inside the Person class, on top of the Person Id attribute so that it gets selected (black background).
  2. From the pop-up menu, select Stereotypes -> Business key.
Set the Person.Date of birth attribute’s Rate of change to Never.
  1. Right-click the Person.Date of birth attribute.
  2. From the pop-up menu, select Stereotypes -> DV20. Now that attribute will be assigned a number of Tagged values.
  3. Click outside the class box to deactivate the attribute selection.
  4. Right-click the Person.Date of birth attribute to re-select it. The newly assigned Tagged values are now visible in the Property Pane.
  5. From the Rate of Change dropdown box, select Never.
Set the Person.Gender association end’s Rate of change to Never.
  1. Right-click the association between the Person and Gender classes.
  2. In the Propery Pane, locate the role B / Gender subtree.
  3. Locat e the Stereotypes item under the Gender subtree (not hierarchically under the Gender subtree).
  4. Click on the button with three dots next to the Stereotypes label.
  5. From the Stereotype selection box, tick the DV20 Stereotype.
  6. Click OK to close the Stereotype selection box.
  7. Click on the diagram background to deactivate the selection.
  8. Right-click the association between the Person and Gender classes, and locate the Tagged value off Gender. You will now see the Rate of change dropdown box.
  9. From the Rate of Change dropdown box, select Never.
Set Gender.Code as Business key.
  1. Right-click inside the Gender class, on top of the Code attribute so that it gets selected (black background).
  2. From the pop-up menu, select Stereotypes -> Business key.
Export the model.
  1. Select File -> Export… -> XML…
  2. In the dialog, select Simple XML Structure and check Export Project.
  3. For the  Output path, navigate to your Working Directory (unless there already by default).
  4. Press OK to export the project.

  • 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