Tutorial Scenario Resolution - Part 2: Simple Model with Link & Satellites

For this second part of the tutorial, we will use the case explained here Tutorial Scenario, but we will focus on the model for the source HR System, with 2 Hubs, 1 Link and 2 Satellites.

In order to reproduce this model,

1. Integrate the new table from the source

2. Create a new Hub

3. Create a new Link

4. Adapt the mapping to add hubs, links and satellite

5. Deploy a new version

6. Load new data into the data vault

Resolution:

1. Create a new data package named “Shops” and create the related staging table “hr_shops” from the Excel file HR.

   1. Go to Source Management

   2. Create a Data Package in the HR source

   3. Name it “shops”

   4. Click on the “Save” button
      

      

      You should see this wizard appear to confirm the creation:

      

   5. Create a new staging table

   6. Select the “Create a new table” option

   7. Select “Import a file (CSV, Excel)”

   8. Click on the “Next” button to continue
      

      

   9. Name the table “hr_shops”

   10. Click on the “Browse” button to retrieve the hr_extract file

   11. Set the sheet name as “shop” (the file tab)

   12. Click on the “Save” button to finish
       

       

       You should see this wizard appear to confirm the creation:

       

       
       Your source structure should look like this

       

       
       

2. Create a new hub “Shop” (We will use the Network Graph section this time)

   1. Go to Modelization > Network Graph

   2. Click on the “+Add Hub” button to create a draft hub

   3. Name it “Shop”

   4. Click on the “Save” button
      

      

      You will be able to drop the draft hub into the scheme area, it will then look like below, implying that it’s still a draft

      

      
      Click on the draft hub, a option menu will appear, then select “Create” to effectivelly create the hub

      

   5. Set the name as “Shop”

   6. Define a key length of 255

   7. Click on Save

      

      You will know that the hub has been properly created when a green wizard pops up in the upper right corner, and the hub in the chart will be filled:

      

3. Create a Link between both Hubs named “Shop_Employee”

   1. In the Network Graph section, hit the “+Add Link” button

   2. Set the name of the draft link as “Shop_Employee”

   3. Click on “Save”
      

      

      From the draft link, click on “Create”

      

   4. If the pre-filled information is correct, hit the “Next” button
      

      

   5. Set the 1st Hub Reference Name as “Shop”

   6. Select the related Hub in the dropdown list

   7. Click on “Add Hub Reference”
      

      

      You will notice that the Hub Shop appear in the right table

   8. Repeat the operation for the Hub Employee

   9. Click on “Save”
      

      

   10. You will know that the operation succeeded when the green wizard appear on the upper right corner

   11. And the arrows are automatically created to bind the link and both hubs
       

       

4. Adapt the Mapping

   1. In the Source management section

   2. Edit the staging table “hr_shops” to access the mapping area
      

      

   3. Create a New Mapping for Hubs

   4. Set the mapping name as “ShopBk”

   5. Select the existing hub “Shop”

   6. Hit the checkbox “Invalidate data”

   7. Define “id” as the business key

   8. Click on “Save”
      

      

   9. Create a new satellite (source_info by convention), attached to the hub “Shop”, and the associated mapping (concept_source by convention).

   10. Set the satellite name as “hr_info”

   11. Set the mapping name as “hShop”

   12. Attach it to the mapping of the Hub “ShopBk”

   13. Select columns that are not primary or foreign keys

   14. Click on “Save”
       

       

       
       

   15. Now let’s focus on the mapping for the staging table HR_EMPLOYEE, there is already 1 hub and 1 satellite, let’s add the other hub and let’s create a mapping for the Link.

   16. Create a new mapping in the staging table hr_employee, a hub mapping named “ShopBk”

   17. Select the related hub “Shop”

   18. Select the shop_id as business key ( do not invalidate data since shop_id is not the primary key of this table)

   19. Click on Save
       

       

   20. Finally, let’s create the mapping for the link Shop_Employee

   21. Set the mapping name as “ShopEmployee”

   22. Select the related link in the dropdown list

   23. Adapt the Link Type if necessary

   24. Select the hub shop

   25. Select the hub employee

   26. Click on Save to finish
       

       

       
       

       Your model should now look like this
       

       

5. Create and deploy a new version
   

   

   
   

6. Load data into the datavault by executing the state machine related to the data package employee on the Orchestrator