Qlik Community

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

Microsoft Dynamics 365 Business Central Connector for Qlik Sense Cloud

dgoehler
Partner - Contributor III
Partner - Contributor III

Microsoft Dynamics 365 Business Central Connector for Qlik Sense Cloud

<It would be nice if there would be also a connector for Microsoft ERP System Dynamics 365 Business Central in Qlik Sense Cloud. This is API: https://docs.microsoft.com/en-us/dynamics-nav/api-reference/v2.0/

For Dynamics 365 Business Central Cloud Azure Active Directory Authentication would be necessary. Basic Authentication is currently also possible but will be turned off in 2022 (https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features-...). For Dynamics 365 Business Central OnPrem Basic and Azure Active Directory Authentication are supported. Most Customers have only setup Basic Authentication.

Tags (1)
43 Comments
Carl_Hunter
Partner - Creator III
Partner - Creator III

+1 to this.

Doing some work on Business Central today, and when configuring the web services for pulling data into Qlik, as per @dgoehler's idea, I noticed a warning notification stating Web Service Access Key (i.e. basic auth) is being depreciated. OAuth will be required either via the ODATA connector, or, more simply, the REST Connector 

Carl_Hunter_1-1615484061903.png

 

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features-... 

 

Carl_Hunter
Partner - Creator III
Partner - Creator III

Commenting on this for visibility. A very good idea. Power BI has an out the box connector to BC. Qlik should close the gap in this area

Carl_Hunter
Partner - Creator III
Partner - Creator III

Any update to this one? Can you help @Michael_Tarallo 

BigAlMcDonald
Partner - Contributor III
Partner - Contributor III

this is exactly what we need! +1

Carl_Hunter
Partner - Creator III
Partner - Creator III

Is there any update to this one Qlik? Feels like good ideas just fall into a black hole on the ideation forum, which is disappointing 😕, even more so with 22 votes!

Business Central is a v popular ERP system, and one of the main Microsoft SaaS solutions... 

JordyWegman
Partner - Master
Partner - Master

@Carl_Hunter, do I read here that you got this to work with OData?

I've got this working with Power BI a.t.m., but have to do it also for Qlik Sense Enterprise SaaS now. Though my Business Central version is on premises, but the idea should be the same.

Jordy

Climber

AlexOmetis
Partner - Specialist
Partner - Specialist

We have this working with OData using the to-be-deprecated "Web Service Access Key" and the REST connector (using OData endpoints) in QS on-prem and SaaS. 

URLs to use are things like https://api.businesscentral.dynamics.com/v2.0/{GUID}/Production/ODataV4/Company('{Company_Name}')/Cu....

You need to create / publish the OData feeds for the relevant items in the Web Services part of BC to make these work. 

JordyWegman
Partner - Master
Partner - Master

Thanks @AlexOmetis , I'll have a look once I have access.

Carl_Hunter
Partner - Creator III
Partner - Creator III

Hi @JordyWegman, yeah as per @AlexOmetis just use the REST Connector and point at the v4 Odata endpoints which you'll configure from within Business Central. Web service key is the only Auth method supported by Qlik Sense, hence this idea for Qlik to sort this out. Send me a message on here if need any further assistance Jordy 🙂 

Just at add fuel to the fire, Microsoft have released a new BC Connector which also has the new common API endpoints, as well as the 'legacy' Odata feeds. Wondering if anyone from Qlik will acknowledge this idea? @Jamie_Gregory 

See here > https://powerbi.microsoft.com/en-us/blog/power-bi-june-2021-feature-summary/#post-16112-_Toc74044971 

Screenshot_20210627-203310_Chrome.jpg

JordyWegman
Partner - Master
Partner - Master

Thanks @Carl_Hunter for the addition! I'll let you know if we get this to work or not.

Jordy