Problem Statement:
To implement the OAuth integration for Business Central instead of using Web Access Key as it was getting expired from Microsoft.
Github
Tools and Technologies:
- Azure Active Directory, Azure Data Factory, SQL Server Management Studio, Business Central, Logic App, Azure SQL, Azure Key vault
Summary:
- Previously used Web Access Key of BC to interact with Web Services (Pages, Code units, Queries). Then shifted to the OAuth configuration.
- Created App in Azure Active Directory (Azure AD) and Azure AD app in BC. Created Client Secret from Azure Active directory, and specified endpoints.
- Generated access token using web call to endpoints specified by Microsoft by sending information in Headers in Azure Data Factory (ADF).
- Stored the token in SQL DB and used it to run the complete cycle of ADF Pipelines.