The Create Data Vault Design wizard enables you to create a model from your source data to be used for generating a data vault.
To create a data vault design...

  1. Click on a Model Version and select Create data vault design from the Workflow pane.
    The Create data vault design - Category configuration dialog is displayed.

    This dialog is ONLY displayed when creating a data vault for the first time. Refer to Default Category Naming Standards for details.
  2. On this dialog you will configure naming standards for entity types in the category that you are creating. Any naming standings you specify on this screen will used for any new categories that are created. Select an  Entity type , click to configure the Prefix and Suffix and click Next.
    The Create data vault design- Model definition dialog is displayed.
  3. Select a Category or a Model, enter a Name and Version for the new model and click Create.

    If you select a Model then you only need to enter a Version.

    The Create data vault design- Manage attribute types dialog is displayed.
  4. On the Create data vault design- Manage attribute types dialog, click to create additional attribute types to be assigned to an attribute for splitting entities into different satellites and click Next. Refer to Manage attribute types for details.
    The Create data vault design- Create hub structures dialog is displayed. On this dialog you can create the business attributes that define the core business entity of a hub.

    From the Create data vault design- Create hub structures dialog, you can:

    • Either create a Hub entity and continue through the wizard (step 5 and onwards).
      OR
    • Click Skip to complete the wizard and then follow instructions to design a basic data vault.

  5. On the Create data vault design- Create hub structures dialog:
  6. Click Next.
    The Create data vault design- Create link structures dialog is displayed. On this screen you can create the entities that defines the core business relationship between multiple hub entities.

    The wizard will design the link's business attributes based on the hub's business attributes. This includes names and sources.


  7. On the Create data vault design- Create link structures dialog
  8. Click Next.
    The Create data vault design- Add source mappings to hub entities dialog is displayed.
  9. On the Create data vault design- Add source mappings to hub entities dialog, define sources for the hub entities' business keys. For example; select an entity in the Hub entities pane, expand a source in the source pane and select a source attribute. Click Next after you have chosen the source attributes for each business attribute.
    The Create data vault design- Add link dependent children dialog is displayed.
  10. On the Create data vault design- Add link dependent children dialog, you will select extra attributes that are not part of any business key attributes of a Hub, but define the business relationship or to form non-historized links. Select the checkbox for the necessary source attributes and click Next.
    The Create data vault design- Add satellite attributes dialog is displayed.
  11. On the Create data vault design- Add satellite attributes dialog, you will define satellites for your sources. Select any additional source attributes to be categorized to separate satellites and click Next.
    A model is created and the Create data vault design- Define assigning definition, dialog is displayed.
  12. At this point the model has already created business keys, link business keys and links between the children. On the Create data vault design- Define assigning definition dialog...
  13. Review the information and click Next.
    The Create data vault design- Review attribute type dialog is displayed.
  14. Select an entity to review their attribute types. Adjust any attribute types if needed.

    You can navigate to step 12 to adjust the matching definition.

  15. Click Assign.
    The model is displayed. All attributes types have been assigned and all relationships have been created.