Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

PlCreate A Dynamics NAV (Multi-Tenant SQL Server) Data Source

This information applies to Jet Reports2015 Update 1 and higher

Overview

Jet Reports supports direct connections to multi-tenant environments for Dynamics NAV.

Multi-Tenancy

Dynamics NAV 2013 and higher support multi-tenancy (where a single instance of the software runs on a server, serving multiple tenants).

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 the Jet Hub, you can use the Jet Administration Console to configure a connection to a multi-tenant NAV install.  There are two options - depending upon where you NAV data resides.

Where is your data?

  1. Same Domain

    If you NAV 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 NAV 2013 - 2018 Direct SQL Server Multitenant

    add_ds_multitenant_JAC.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.

    add_ds_multitenant_JAC_auth.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:

  2. Different Domain

    If you NAV 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 Report Data Server ("JRDS"), you can define a data source for:

    Dynamics NAV 2013 - 2018 Remote Data Service

    The JRDS is already configured to connect to a specific NAV 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 NAV.  There are two options - depending upon where you NAV data resides.

Where is your data?

  1. Same Domain

    If you NAV 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 NAV 2013 - 2018 Direct SQL Server Multitenant

    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.

    add_ds_multitenant_auth.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:

  2. Different Domain

    If you NAV 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 Report Data Server ("JRDS"), you can define a data source for:

    Dynamics NAV 2013 - 2018 Remote Data Service

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

Published:

PlCreate A Dynamics NAV (Multi-Tenant SQL Server) Data Source

This information applies to Jet Reports2015 Update 1 and higher

Overview

Jet Reports supports direct connections to multi-tenant environments for Dynamics NAV.

Multi-Tenancy

Dynamics NAV 2013 and higher support multi-tenancy (where a single instance of the software runs on a server, serving multiple tenants).

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 the Jet Hub, you can use the Jet Administration Console to configure a connection to a multi-tenant NAV install.  There are two options - depending upon where you NAV data resides.

Where is your data?

  1. Same Domain

    If you NAV 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 NAV 2013 - 2018 Direct SQL Server Multitenant

    add_ds_multitenant_JAC.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.

    add_ds_multitenant_JAC_auth.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:

  2. Different Domain

    If you NAV 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 Report Data Server ("JRDS"), you can define a data source for:

    Dynamics NAV 2013 - 2018 Remote Data Service

    The JRDS is already configured to connect to a specific NAV 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 NAV.  There are two options - depending upon where you NAV data resides.

Where is your data?

  1. Same Domain

    If you NAV 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 NAV 2013 - 2018 Direct SQL Server Multitenant

    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.

    add_ds_multitenant_auth.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:

  2. Different Domain

    If you NAV 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 Report Data Server ("JRDS"), you can define a data source for:

    Dynamics NAV 2013 - 2018 Remote Data Service

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

For an optimal Community experience, Please view on Desktop