Skip to content


Tech Tuesday: Multi-Tenant Destinations

Last week multi-tenant options were added to 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

Leave a Comment


Tech Tuesday: Popdock - Joining the tale of two States
Meet eOne Solutions at Directions EMEA 2023!
Connect with eOne Solutions at SuiteWorld 2023!
What is a Data Lake/Data Lake Management?
The Challenges & Benefits of Ad Hoc Reporting


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release Salesforce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.