Configuring a connection between Jet Analytics and your Business Central tenant is accomplished through two distinct steps:
- Importing the Jet Reports Queries into Business Central
- Configuring Jet Analytics for use with Business Central
Let's look at the configuration process...
Importing the Jet Reports Queries into Business Central
From the Dynamics home page, click Sign in
Enter your Dynamics 365 credentials
From your Dynamics 365 Home page, start your Business Central
Once within Dynamics 365 Business Central, click the Search icon
Search for Extension Management
From the Installed Extensions window...
Click Upload Extension from the Manage section of the toolbar.
From the Upload and Deploy Extension dialog, click the pull-down arrow for Select .app file.
Navigate to the installation files for Jet Analytics and to the folder containing the Jet Report Queries .app file
On the Upload and Deploy Extension dialog, ensure that the Deploy to option is set to Current Version, select the language being used with your Business Central, and check the box to Accept the disclaimer.
When Business Central completes the installation process, the Jet Reports Queries extension will be available:
Finally you'll need to make sure all the Web Services entries are entered into Business Central.
Attached to the bottom of this article is an Excel workbook:
Open that file and use it to create the entities in Web Services.
From the Web Services windows in Business Central, select the New option at the top.
Next, select Query for the Object Type.
Next, type in the Object ID. This will automatically find the object and preview it for you. Press Tab to have it auto-populate the field.
Once that populates, you will need to type in the Service Name. This needs to exactly match what's on the spreadsheet. Even case has to match.
When entering in the Service Name field, it needs to match exactly what is in the spreadsheet. These fields are case sensitive and cannot accept spaces or special characters other than underscores. Mistyping these will result in synchronizations issues in the Jet Data Manager application.
Finally click the Publish box.
Once you've inputted all the queries it should look similar to the screenshot below.
Configuring Jet Analytics for use with Business Central
Once the Jet Reports Queries extension has been imported into your Business Central tenant....
We next need to identify a user account which has a web services access key allowing external applications to communicate with Business Central.
Here we see the Web Service Access Key which has been assigned to this user.
We also need to get the URL for our Business Central tenant. This URL is displayed when you first select Business Central from our Dynamics 365 Home page:
Start the Jet Data Manager.
If you have not already installed a Business Central project, go to the CubeStore and do so.
Open the Business Central project you want to use
Create or Edit a new CData Data Source
For the settings in the Authentication section, enter the four pieces of information we gathered from Business Central:
- Company Name
- The Organization URL that we copied to a text document
- The User to which a Web Service Access Key has been assigned
- The Web Service Access Key we copied to the text document
If you do not have the Business Central provider already in your provider list, please see this artcile for instructions.
Click the Test Connection button
Synchronize your Data Source
Once the synchronization is complete, you can see all the Business Central data to which you have access
You are now ready to begin using Jet Analytics with your Business Central data.