Business Central (BC) OAuth Integration)
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 […]
Data warehouse for Reporting
Problem Statement: To build a data warehouse for PowerBI reporting purposes having source as Business Central and destination as Azure SQL Database. GitHub Tools and Technologies: Azure Data Factory, Microsoft Azure SQL Database, SQL Server Management Studio, Logic App, Azure Key Vault, Business Central, OData Summary: Designed and Implemented the Data warehouse from scratch using […]
Data Exchange Interface (Future Beauty Labs)
Problem Statement: To build a Data exchange interface that manages the incoming Shipments, Sales, and Purchase Orders from different Woocommerce websites of a Business Central (BC) based client using Azure. GitHub Tools and Technologies: Azure Data Factory, Azure Data Lake, Microsoft Azure SQL Database, SQL Server Management Studio, Logic App, Azure Key Vault, Secure File […]