Tutorial Scenario Resolution - Part 3: Advanced Model

For this 3d part, we will focus on the whole model, by integrating both sources and create all entities.

In order to reproduce this model,

1. Integrate the source system CRM

2. Create new hubs and links

3. Adapt the mapping to add hubs, links and satellites

Resolution

1. Integrate CRM source system

   1. Create a source system
      

      

   2. Create data packages
      

      

   3. Create staging tables
      

      

2. Create new entities

   1. 3 new hubs (Customer, Contract & Car)
      

      

   2. 4 new links (Customer_Contract/ Car_Contract/ Contract_Employee/ Employee_Hierarchy)
      

      

      
      Pay attention to the link types*
      

3. Adapt mapping

   1. CRM Source System

      1. Cars
         

         

         

      2. Contracts
         

         

         

         

      3. Customers
         

         

         

      4. Employees
         

         

         

   2. HR Source System

      1. Employees
         

         

         

         

      2. Shops
         

         

         

4. Your model should now look like this
   

   

5. Create a new version a deploy it
   

   

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