EONE BLOG

Tech Tuesday: Multi-Tenant Destinations


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

Leave a Comment





RECENT POSTS


Employee Spotlight: Robert Dehn
Dynamics 365 Business Central Integration Bootcamps in Summer 2020 - Hosted Online
Join eOne at Business Building Conference 2020!
Tech Tuesday: Business Central Item Image Web Service
2020 Popdock & SmartConnect Bootcamps (Updated)

POPULAR POSTS


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

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.