Azure Automation: Automate data loading from email attachments using Azure Logic Apps

Azure Automation: Automate data loading from email attachments using Azure Logic Apps

This article will describe the process to automate data loading from email attachments into Azure SQL Database using Azure Logic Apps.

This article will explore Azure automation for automatic data loading into Azure SQL Databases using the Azure Logic App.

Introduction

Suppose you have an Azure SQL Database for product catalog for your online shopping portal. You receive a CSV file in a specific mailbox and format for various products. You require to import data from these CSV files into Azure SQL Database.

In the following high-level diagram, we can visualize the overall process. In this process, you can use the following steps to achieve the requirements.

  • Manually extract the attachment from the email and save it to a local directory
  • Browse to the Azure portal, navigate to the storage account container and upload the file into the INPUT folder
  • Import data into Azure SQL Database tables

If we do this task manually, it might be a cumbersome process to execute daily. Therefore, you can look for automation using various ways.

  • You can use ETL packages using the SQL Server Integration Services
  • Azure Data factory

However, in these cases, it is a slightly complicated process to extract attachment from the email (on email arrival) and save it to the storage container automatically.

In the article, Automatic Scale up and down Azure SQL database with Logic Apps, we explored azure logic apps usage for automatically scaling resources for your azure databases.

We will cover the solution in a series of two articles. We will learn how you can use Azure Logic Apps for simulating the problem we defined earlier.

In this first part, we will implement the following things:

  • Azure Logic apps to read an email, get its attachment
  • Save the attachment into the Azure Storage container blob
  • Send email confirmation once the attachment is uploaded to the Azure container

azure sql azure azure automation

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

How to set up Azure Data Sync between Azure SQL databases and on-premises SQL Server

In this article, you learn how to set up Azure Data Sync services. In addition, you will also learn how to create and set up a data sync group between Azure SQL database and on-premises SQL Server.

Azure Automation: Automate Azure SQL Database indexes and statistics maintenance

This article will show how to automate Azure SQL Database index and statistics maintenance.

Demo: Configure Azure SQL with Azure CLI | Azure SQL for beginners (Ep. 17)

In this video, see how to configure your Azure SQL connectivity leveraging the Azure CLI and PowerShell notebooks in Azure Data Studio. For the full Azure SQ...

Azure Automation: Create database copies of Azure SQL Database

This article will describe Azure Automation to create a database copy of an Azure SQL Database.