英文:
How to use Azure Data Factory to take Business Central data and put into Azure SQL DB?
问题
我正在尝试使用Azure数据工厂（ADF）从Business Central（BC）获取数据并将其发送到Azure SQL DB。
- 在BC门户内，您可以在顶部搜索“Web Services”，然后您将获得一个Web服务/ API URL列表，可以查询以检索您的数据。
- 在Web服务列表中，我一直使用Chart of Accounts端点作为示例。请参见下面的截图：
-
当我使用Chart of Accounts端点的OData V4 URL尝试在ADF中连接时，我收到以下错误消息：
“Web服务访问密钥不再支持作为身份验证方法。请使用OAuth。”
-
据我了解，为了在BC中使用OAuth作为身份验证方法，我需要创建一个Active Directory应用程序？https://learn.microsoft.com/en-us/azure/active-directory/develop/quickstart-register-app
我以前没有创建过Active Directory应用程序，所以不确定我是否以最佳方式进行操作。
简而言之，我只需要将BC数据放入我的数据库中...有没有更好的方法？
英文:
I am trying to use Azure Data Factory (ADF) to take data from Business Central (BC) and send it to the Azure SQL DB.
- Within the BC portal, you can search for 'Web Services' at the top and you will be provided with a list of web services/ API URL's you can query to retrieve your data
- In the list of web services, I have been using the Chart of Accounts endpoint as an example. See screenshots below:
-
When I use the OData V4 URL for the Chart of Accounts endpoint and try to connect in ADF, I am receiving the following error:
Web service access key is no longer supported as authentication. Please use OAuth -
It's my understanding that in order to use OAuth as the authentication method for BC, I need to create an Active Directory App? https://learn.microsoft.com/en-us/azure/active-directory/develop/quickstart-register-app
I have not created an Active Directory App before, so am unsure if I am doing this in the best way.
Simply put, I just need the BC data in my DB... Can I do this a better way?
答案1
得分: 0
认证
您需要使用OAuth2认证来访问Business Central的API/Web服务。
为此，您需要一个Azure应用注册，并且这个应用注册还需要在Business Central中创建，以便分配正确的权限。
查看官方指南 设置Azure Active Directory (Azure AD) 基于身份验证 获取更多信息。
API和Web服务
我还建议您使用API而不是OData Web服务，因为API不太容易变化，如果/当进行更改时，会使用版本控制来确保现有的集成不会失败。
您可以在官方 API参考文档 中找到可用的API和它们的端点。
英文:
Authentication
You need to use OAuth2 authentication to access the Business Central APIs/Web Services.
For this you need an Azure App Registration and this App Registration needs to be created inside Business Central as well to be able to assign the correct permissions.
Check the official guide on Setting up Azure Active Directory (Azure AD) based authentication for more information.
APIs og Web Services
I would also recommend that you use the APIs instead of the OData Web Services as the APIs are less subject to change and if/when changes are made versioning is used to ensure that existing integrations won't fail.
You can find the available APIs and their endpoints in the official API Reference.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论