5. Mapping of complex and hierarchical object

Introduction

To arrange interfaces in order means a hierarchical interface. It is a structure in which interfaces are ranked according to levels of importance.

• We enhance the Skyvva mapping tool to hierarchical tree view and map data of parent/child in one shut.
• A Skyvva tree mapping is a visual method for displaying hierarchical data related to the parent interface and child interface.
• Skyvva tree mapping feature is built to reduce the complexity of manual work.

What Is Mapping?

• Mapping is one of the most useful and important features of SKYVVA.
• It is basically a data transformation tool.
• It's UI is in graphical form.
• Mapping is a term to map source data fields to their related target data fields. It depends on the key concept. To check the fields in the UI/Front end forms and mapped consistently with the corresponding DB table.
• In order to figure out how the data needs to be formatted or mapped. It must also explain the primary key in the source system.
• We can do mapping in two ways i.e, Inbound and Outbound mapping.
• In Outbound mapping, we have only one mode available which is Internal mapping or Mapping in SFDC.
• In Inbound mapping, we have 3 modes available which are Internal mapping, External mapping, and Hybrid mapping.

What is Hierarchical Mapping?

Hierarchical mapping is a mapping in which you can map all different parts of data from different sObject into the tree target structure. We can do it in two ways:-

• Hierarchical mapping by using vlookup .
• Hierarchical mapping by using Foreign key.

Advantage

• Reduce the complexity of manual work.
• hierarchical data related to parent interface and child interface can see in one shut.
• We have to create a message type for Istructure. We can easily get a hierarchical Istructure using message type. Also, It is reusable in another interface.

Pre-requisite

• Create  Integration -> Go to integration tab -> fill name field -> Save it.
• Create one inbound interface. I,e Account. (Create account interface only, child interface will be automatically created in it )

Follow the steps given below To see the hierarchical data in the mapping tool some basic configuration is needed. 1.1  Create MetaData Providers -> New MetaData Providers

1.2 Create IStructure Repository click on New IStructure Repository

1.3  Create 2 New Message Type (account, contact) click on New Message Type Account Interface:

Contact Interface:

1.4  Click on Message Types Related tab then click on Message Type field entry ->New button:-

• New Button Navigate to:-

* Follow the same steps for contact Interface. Create an Interface which Lookup to MetaData

• How to create Metadata, Repository, and Message type

• Enter the Interface detail page, which you had just create, and mapping with the flat field that includes Account and Contact with sObject tree and then make VlookUp account with Contact.
• Check this tutorial to learn How formula in mapping works. #article/using-formula

• The following screen display that the Interface is automatically chained with contact after done mapping and VLOOKUP.

• Integrate the data to Salesforce

• Monitor the result in Message Monitoring Board

And the below screenshot shows a result in detail of Account