I am trying to use Azure Data Factory (ADF) to take data from Business Central (BC) and send it to the Azure SQL DB.
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?
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.