Suggest an Idea

[dgoehler]

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

[Carl_Hunter]

+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 

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

[Carl_Hunter]

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]

Any update to this one? Can you help @Michael_Tarallo 

[Alastair_Ometis]

this is exactly what we need! +1

[Carl_Hunter]

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]

@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]

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]

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

[Carl_Hunter]

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 

[JordyWegman]

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

Jordy