I want to convert complex excel to database solution .can someone suggest cost effective azure solution for this .

Question

I want to convert complex excel with multiple columns into a database solution . so that instead of updating excel everytime and keep adding columns user can directly access tables in database and update the respective tables .Also some of the columns value needs to be dynamically update from the csv files stored in datalake .Can some one please suggest cost effective solution for this use case .

Answer 1

Hi @Shubhangi Sonawane (External)

Thanks for the Question and using Microsoft Q&A.

As per my understanding, your requirement is to convert complex Excel files with multiple columns into a database solution, here are some cost-effective Azure options:

Azure SQL Database: This fully managed relational database service offers high availability, automated backups, and robust security features. You can use tools like the ESF Database Migration Toolkit to migrate your Excel data to Azure SQL Database.

Azure Data Lake Storage: Store your CSV files in Azure Data Lake Storage, a scalable and secure solution. Use Azure Data Factory to dynamically update your database tables with data from the CSV files.

Azure Synapse Analytics: An integrated analytics service that combines big data and data warehousing. You can create a data pipeline to ingest data from your Excel files and store it in a database.

Please refer these Documentations that might help you:

https://learn.microsoft.com/en-us/azure/azure-sql/database/?view=azuresql

https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-introduction

https://learn.microsoft.com/en-us/azure/synapse-analytics/

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.