Last week multi-tenant options were added to Smartconnect.com destinations. This will allow you to have one integration run to several different destinations. This is available for Business Central/NAV, Dynamics 365 Customer Engagement/CRM, Microsoft SQL Server, NetSuite, and Salesforce.

The setup for multi-tenant can be found on the Target tab while setting up an integration process. There will be a new sub-tab called Companies, Organizations, or Databases depending on the target type. In this example, I am going to be using Business Central, so I will refer to it as companies. This tab will also have two sub-tabs which will allow you to select which companies you want to send all the records to or setup a custom definition script to send only specific records to specific companies. For the multi-tenant to work correctly, every target destination needs to have the same objects available.

Setup for sending all records to multiple destinations

  1. Setup the destination on the Settings tab.
  2. Click the Companies tab, then the Selected tab to select any other companies available from this connector.

Setup for sending records to multiple destinations using a custom definition

  1. Setup the destination on the Settings tab.
  2. Click the Companies tab, then the Selected tab and uncheck all selected companies.
  3. Click the Custom tab.

Here you can define which records in your source go to which destination company using javascript. The example script below will integrate any records where the company field in my source equals “Techtuesday Company” to my Cronus USA, Inc. company in Business Central. All the other records will fall into the else statement and integrate into the My Company in Business Central. To help write the script, you can see the source column names and destination company names next to the javascript code:

if (this._company == “TechTuesday Company”){
return this._BCWave1_CRONUSUSAInc;
} else {
return this._BCWave1_MyCompany;
}

Adding Additional Connections

Multi-tenant can also integrate to different connector instances, but they must be the same type of connector as the main destination and the same objects need to exist in the destination. This means that if you have companies in a completely different Business Central instance, you can use it here as a destination.

  1. On the Selected tab, choose another connection from the connections drop down and then click the Add button.
  2. This will append all the companies available from that connector and mark the default company. If you plan to use the custom definition, you will want to uncheck the default company.
  3. You can now use this connector instance in the same way as the above two methods.

You will notice when you run your integration now, you will have a higher record count if using the selection method because all the records are going to every destination. If you have used the custom definition, your record count will match the number of records from the source.

If you have any more questions about SmartConnect or anything else, feel free to email us at sales@eonsolutions.com