Automate flow of data from SharePoint (Excel file) to SQL database using Azure
Budget: £30 – £100 GBP
I have an excel file saved on SharePoint which is updated throughout the day. I need a process for taking the data (from the second sheet of the workbook) and pushing it to my SQL database.
I have already set up Azure blob storage, data factory, logic apps and sql server/database.
The challenge I'm facing is that the headers of the data are not aligned. For example, the dates are merged across 2 columns (please see attached).
I need either all columns migrating to a single SQL table or going to 2 separate tables (1 for % complete and 1 for Revenue)
Please let me know your thoughts
I have already set up Azure blob storage, data factory, logic apps and sql server/database.
The challenge I'm facing is that the headers of the data are not aligned. For example, the dates are merged across 2 columns (please see attached).
I need either all columns migrating to a single SQL table or going to 2 separate tables (1 for % complete and 1 for Revenue)
Please let me know your thoughts
Related categories:
Microsoft Azure