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.
if (this._company == “TechTuesday Company”){
return this._BCWave1_CRONUSUSAInc;
} else {
return this._BCWave1_MyCompany;
}
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.
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
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
- Setup the destination on the Settings tab.
- 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
- Setup the destination on the Settings tab.
- Click the Companies tab, then the Selected tab and uncheck all selected companies.
- Click the Custom tab.
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.
- On the Selected tab, choose another connection from the connections drop down and then click the Add button.
- 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.
- 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