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

Getting Started With Modeling

D♯ Engine has been tested to work with Visual Paradigm versions up to 16.2, but will most likely also work with newer versions.

Before building your first VP model, import the relevant Stereotypes as described here. You may also want to switch the UI mode to match the images in this documentation.

Here are some tips to get you up & running with Visual Paradigm as required by the tutorials:

  • use the provided [D♯ Engine installation folder]\Workspace\ExternalModels\Training\Tutorial\DemoDW\DemoDW.vpp template file as your starting point
  • put all your raw model content in the Source models -folder
  • name each subfolder as the source system you are importing
  • make additional subfolders as needed, splitting the source system model into coherent parts
  • for shared classes, keep the class in its original folder, in the source where it was first accountered
  • make readable diagrams by dividing and conquering the model: one diagram should be readable when printed on paper
  • datatypes to be used for attributes can be found by running the D♯ Engine UI command Show Datatypes, which generates a HTML document describing the current known datatypes.

Source system specific subfolders are located directly under the Source models folder.

Metadata

Class Metadata

Class metadata will become available once you assign the correct Archetype to the class using UML’s Stereotype mechanism. Select the class in the diagram, and right-click it for the pop-up menu, and select the appropriate stereotype from the list. If it is not visible in the list, you can open the Stereotypes dialog and assign it there, after which it also becomes available in the popup menu.

The metadata values can then be edited after clicking the class either in a diagram or in the Model explorer tree. See the Archetype-specific metadata explanations here. You may need to de-select and re-select the class before the Tagged Values appear.

Attribute Metadata

With the exception of the attribute being the Business key (which can be assigned directly, see below), the attribute specific metadata can be edited once the attribute has been assigned the DV20 Stereotype. Do this by selecting the attribute and then the DV20-Stereotype from the pop-up menu.

The metadata values can then be edited after clicking the attribute inside the class view in a diagram or in the Model explorer tree. See the metadata explanations here. You may need to de-select and re-select the attribute before the Tagged Values appear.

Association End Metadata

The association end specific metadata can be edited once the association end has been assigned the DV20 Stereotype. Do this by selecting the association and selecting the Stereotype in the Property pane, after which the parameters will become available under the Tagged Values item in the Property pane.

You may need to de-select and re-select the association before the Tagged Values appear.

Exporting the Model

In order to make the model available for D♯ Engine, you need to export it to the working directory as an XML file. In Visual Paradigm, select the File -> Export -> XML command to open the export dialog:

Select your working directory as your output path by navigating to it using the … -button next to the file path dropdown, then select Simple XML structure and check Export project, and finally click the Export button. The export file will always be saved as project.xml. This is the file you should open with D♯ Engine.

  • 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