Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Create A Multi-Tenant Business Central (Dynamics 365 SQL Server) Data Source


This information applies to Jet Reports 2019R2 and higher

Overview

Jet Reports supports direct connections to multi-tenant environments for Dynamics 365 Business Central.

 

Multi-Tenancy

Dynamics 365 Business Central supports multi-tenancy (where a single instance of the software runs on a server, serving multiple tenants).

d365bc-multi-tenancy.png

Jet Administration Console

If your organization uses the Jet Service Tier to provide centralized data source settings to the Jet Excel add-in and/or Jet Hub, you can use the Jet Administration Console to configure a connection to a multi-tenant BC install.  There are two options - depending upon where you D365 BC data resides.

 

Where is your data?

  1. Same Domain

    If you BC data is located on a server which is on the same network domain as your installation of Jet Reports, you can create a new data source for:

    Dynamics Business Central Direct SQL Server Multitenant

    bc-multi01.png

    Click OK

    In the Authentication section, you'll need to confirm which user account will be used to access both the Application and the Tenant.

    bc-multi02.png

     

    In addition to the application server setting in the Connection section, configure the correct Server, Database, and Company for the specific tenant you want this data source to access:

    bc-multi03.png

  2. Different Domain

    If you BC data is located on a server which is on a different network domain than your installation of Jet Reports and  your system administrator has created a Jet Remote Data Server ("JRDS"), you can define a data source for:

    Dynamics 365 Business Central Remote Data Service

    bc-multi04.png 

    The JRDS is already configured to connect to a specific BC Tenant.  You will just have to specify the connection and authentication information provided to you by your system administrator - then you're done.


 

Jet Reports Data Source Settings

Even if your organization does not use the Jet Service Tier, you can use the Jet Excel add-in to configure a data source for use with multi-tenant Business Central.  There are two options - depending upon where you BC data resides.

 

Where is your data?

  1. Same Domain

    If you BC data is located on a server which is on the same network domain as your installation of Jet Reports, you can create a new data source for:

    Dynamics 365 Business Central Direct SQL Server - Multitenant

      bc-multi05.png

    Click Add

    In the Authentication section, you'll need to confirm which user account(s) will be used to access both the Application and the Tenant.

    bc-multi06.png

     

    In addition to the application server setting in the Connection section, configure the correct Server, Database, and Company for the specific tenant you want this data source to access:

    bc-multi07.png

  2. Different Domain

    If you BC data is located on a server which is on a different network domain than your installation of Jet Reports and  your system administrator has created a Jet Remote Data Server ("JRDS"), you can define a data source for:

    Dynamics 365 Business Central Remote Data Service

    bc-multi08.png

    The JRDS is already configured to connect to a specific Business Central Tenant.  You will just have to specify the connection and authentication information provided to you by your system administrator - then you're done.

 

 
Was this article helpful?
0 out of 0 found this helpful

Comments