Follow these steps to ingreate Salesforce Customers with NetSuite Accounts using Dell Boomi.
Log into Dell Boomi with your username and password.
Click Browse Process Library in the Boomi Window > Select Salesforce Accounts to NetSuite Customer Full Example > Click Install.
The example looks like this:
Click Start - Salesforce Org > Enter your Salesforce credentials
(User Name and Password) > Save and Close.
Note: You have to enter the Salesforce password along with the Token ID.
Example: SalesforceTokenID (Generated from salesforce account).
Click Account Query (here, we are going to add the parameters that we are passing on to NetSuite).
Select required fields which we need to map data from Salesforce to NetSuite.
Click Filters do AND operations with the respective parameter (here, I am going to take Name and ID) and select operator for those parameters > Save and Close.
Click on Parameter > Assign parameters with value.
Note: ID is generated from the Salesforce account.
How to fetch the ID:
- Log into the Salesforce Account
- Click on Developer Console (one window will visible)
- Write a query on there (select ID from Account where name='ENV_DIP_NETSUITE_CUST_SALESFORCE_JUN12' )
- Click on execute.
- ID will generate (take ID from account and put it into Dell Boomi account).
- Click OK and save.
Click on NetSuite
- Enter User Name, Password, Token ID, Account ID, Consumer Key, Consumer Secret, Token Secret, Application ID, and Version.
- Click Save and Test the connections.
- Once the test is successful, click Save and Close.
Note: Here, the URL and Version should be the same.
Click Subsidiary and assign values to it.
In the subsidiary part, select Filters and assign a Filter and Operator to it > Save and Close.
Assign parameter to subsidiary.
Click on NS Subsidiary and check parameter.
Click on SFDC Account to NS > Map all of the data from Salesforce to NetSuite.
Set the Subsidiary value wherein you want to pull data from Salesforce to NetSuite > Save and Close.
Click on NetSuite and assign credentials to it.
Click Customer Upsert and fill all data as required.
Click Save and Test data (a successful message will display) > check the NetSuite Customer List Page (data has generated).
Input (Salesforce Account Data):
Output (Salesforce Account Data):
Go to the Account Query link > Select operator (in comma-separated list) > Save and Close.
Go to parameter link > Select Name > Assign 2 or 3 Name of Account (Salesforce Account) > Save and Close.
Save and Test the data > Multiple records will be created in the NetSuite account.
Check out our other NetSuite blogs for how-to guides and tips.