Introduction
Organizations are increasingly moving their workloads to the cloud, but they still need to access their on-premises applications. Azure AD Application Proxy allows external users to access these applications securely without a VPN connection. If you are interested in finding the difference between on-prem AD and Azure AD, check this article. The purpose of this article is to…
How to use stored procedure in ADF - Azure Data Factory
April 27, 2023
Data transformation is an important step in the data processing pipeline. In order to prepare raw data for analysis, it needs to be cleaned, shaped, and structured. In Azure SQL Database, one of the methods for transforming data is through the use of stored procedures. In this article, we will explore how to use stored procedure in Azure Data Factory (ADF) to transform data in Azure SQL…
How to use Wrangling data flows in Azure Data Factory
April 27, 2023
Data transformation is an essential step in the data engineering process. In order to prepare raw data for analysis, it must be cleaned, shaped, and structured in order to be ready for analysis. As far as transforming data in Azure Data Factory is concerned, there are two main approaches: Mapping data flows and Wrangling data flows. The purpose of this article is to demonstrate how we can use…
How to use mapping data flows in Azure Data Factory
April 27, 2023
The mapping data flow tool provided by Azure Data Factory is a powerful graphical tool for transforming data. With this tool, you can visually design and execute data transformations on data stored in various data stores, such as Azure Blob Storage, Azure SQL Database, and other data stores, such as Google Sheets.
When creating data flows, it is possible to design the data transformation…
Introduction
Microsoft’s Azure Data Factory (ADF) is a cloud-based data integration service. The platform provides users with the ability to construct, schedule, and manage data pipelines that transfer and transform data between different sources and destinations. A key component of any data integration process is data transformation, which involves converting data from its original…
