Master Data Mapping Tool for Salesforce Connector in Integration Hub

Master Data Mapping Tool for Salesforce Connector in Integration Hub

This tool allows the user to map the already existing Account, Contact, Lead, and product data in Salesforce and SAP Business one. This is needed in case the same Account or Contact or Lead or product master already exists in both applications and you would like to map their internal code to prevent data duplicity between the applications. 

To display the Master Data Mapping Tool window, choose Administration --> Integration Hub --> Master Data Mapping Tool.

Use the following steps to import the mapping data using the master data mapping tool:

1.     Select a template from the Template dropdown list.

2.     Select the Account, Contact, Lead, or Product from the Master Data Type dropdown list.

3.     Choose the Download from App button to download the data from Salesforce.

4.     To check the data download status, choose the Status button.

5.     Once the data download is complete, choose the Prepare Template button to generate the Microsoft Excel-based template for the selected master i.e. Account or Contact or Lead or product. The application downloads the data from Salesforce.

6.     Open the template and provide the relevant information:

            o   For the Customer template, you need to provide the SAP B1 Card Code (Customer Code)

            o   For the Lead template, you need to provide the SAP B1 Card Code (Lead Code)

            o   For Contact, you need to provide the SAP B1 Card Code and SAP B1 Contact ID (Customer Code and Contact ID)

            o   For the Product template, you need to provide the SAP B1 Item Code

7.     Choose the Browse button to navigate to the template path.

8.     Choose the Validate button to check the correctness and completeness of the data in the selected template.

9.     Choose the Upload button to import the data.

    • Related Articles

    • Products Master Data – Salesforce in the Integration Hub

      The System supports the integration of existing product data from Business One to Salesforce. Product add & update operations are supported from SAP Business One to Salesforce.  The Item Code in SAP Business One is mapped with Stock Keeping Unit ...

    • Customer Master Data – Salesforce in the Integration Hub

      The customer master data integration is bidirectional between Salesforce and SAP Business One. Customer Information like Name, E-mail, Billing, Shipping Address and Contacts, and other details are integrated from Salesforce to SAP Business One and ...

    • Lead – Salesforce in the Integration Hub

      The integration of Lead is bidirectional between SAP Business One and Salesforce. The Lead integration is bidirectional between Salesforce and SAP Business One. Lead Information like Name, E-mail, Billing and Shipping Address, and other details are ...

    • Salesforce integration with SAP Business One

      Salesforce is a cloud computing service as a software (SaaS) company that specializes in customer relationship management (CRM). Salesforce's customer relationship management software instantly streamlines and automates enterprise’s business ...

    • Synchronization of Salesforce in the Integration Hub

      The following two methods are available for synchronization between SAP Business One and Salesforce: Manual Synchronization:  Whenever a user needs the integration to be done on the immediate basis (instead of waiting till the Scheduler services to ...