Connecting with Dynamics 365 Business Central using data pipeline

[elpaloo]

I'm trying to connect Dynamics 365 Business Central with my Fabric workspace. I know that it is possible to receive data from Business Central using dataflow gen2, but i'm wondering if there is any chance to receive data from BC into data pipeline not dataflow gen2?

[elpaloo]

Hello guys,

Thanks a lot for the documentation links. I read it all, and now I'm trying to create a connection, but I prefer to do it without Dataverse. An OData connection seems to be the proper way. I have one thing to consider:

1. When I create a connection with the "Manage connections and gateways" tab in settings, the connection uses OAuth 2.0 authorization. However, I cannot use it in the Copy activity in the data pipeline. Creating a connection to the source in the Copy activity tab only offers Anonymous or Basic authorization, and it gives me an "Invalid credentials" error (In the "Manage connections and gateways" tab in settings, the test connection was successful). Maybe I need to create a gateway to Dynamics 365? Do you have any ideas?

[Anonymous]

Hi @elpaloo ,

Thanks for your reply. I assume you are following the same - Data source management - Microsoft Fabric | Microsoft Learn

I just want to know are you not able see the connection in Copy Activity that was created at Manage Connections and gateway ?

[elpaloo]

Yes, you right. 

What's more, only OAuth 2.0 gives me opportunity to connect. Basic authorization throw an error "Invalid credentials" (I'm using the same credentials as in OAuth 2.0) 

Maybe I should configure Business Central? Maybe BC won't let me in 

[Anonymous]

Hi @elpaloo ,

At pesent we only supporting these connection modes only.

If you are looking for more options. Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this helps. Please let me know if you have any further queries.

Thank you

[elpaloo]

I don't get it. I found this in documentation:

Is it means that Business central supports OAuth 2.0 instead of Basic authorization but Fabric does not support it? 

[Anonymous]

Hi @elpaloo ,

At present the supported authentication types of OData Connection.

Docs to refer - Set up your OData connection - Microsoft Fabric | Microsoft Learn

Please share the doc that you are refering, so I can help you better.

Hope this is helpful. Do let me know incase of further queries.

[elpaloo]

Okey, Data pipeline supports Basic or Anonymous authorization but when you get Business Central documentation you can see:

Web Services Authentication - Business Central | Microsoft Learn
Is it mean that Business Central must be authorized via OAuth 2.0 but Fabric does not have such authorization option in Copy activity?

Thanks a lot for your help! 

[Anonymous]

Hi @elpaloo ,

Yes, your understanding is correct. Currently Copy Activity doesnot support OAuth 2.0

However, your suggestion is definitely valuable! We use customer feedback like yours to prioritize future features. The more users who request the ability to customize backgrounds, the higher it moves on our list.

Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

I hope this information helps. If you have any further queries please do let us know.

[Anonymous]

Hi @elpaloo ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

[NandanHegde]

As long as there are APIs to extract data from a system, you can use Copy activity to copy data from them.

https://stackoverflow.com/questions/76411322/how-to-use-azure-data-factory-to-take-business-central-...

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extract-da...

Azure data factory is similar to Fabric data pipelines

[elpaloo]

It should be similar, but in copy data activity, rest connector does not support any valueable authorization (only Anonymous). So there is no chance to extract data from Business Central to Fabric 😞

[Anonymous]

Hi @elpaloo ,

Thanks for using Fabric Community.
You can also have a look into below links along with the links shared by @NandanHegde .
I hope these links might you.

Docs to refer -
First Post: Export Your Dynamics Data to Microsoft Fabric or Azure Synapse – Part 1 of 4
Second Post: Setup Synapse link or Fabric link - Part 2 of 4 (dynamics.com)
Third Post: Build your data warehouse as lakehouse on Dynamics 365 data in Microsoft Fabric - Part 3 of 4
Fourth Post: Update your Dynamics 365 lakehouse with incremental data updates using Change Data Feed - Part 4 of ...

Additional Links:
Solved: how Do I connect Dynamics 365 with Microsoft Fabri... - Microsoft Fabric Community

Hope this is helpful.

[Anonymous]

Hi @elpaloo ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks