Automate flow of data from SharePoint (Excel file) to SQL database using Azure Factory

£30-100 GBP

Closed

Posted

about 2 years ago

£30-100 GBP

Paid on delivery

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

Microsoft Azure

Project ID: 33440251

About the project

7 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

7 freelancers are bidding on average £111 GBP for this job

@devendrathakur12

Hello, Greetings! I read your job description completely and I found my skills relevant to your project. About 8+ years of professional experience in IT which includes work experience in Big Data, Hadoop ecosystem related technologies. ✅ Well versed in Installation, Configuration, Supporting and Managing of Big Data and Underlying infrastructure of Hadoop Cluster. ✅ Strong experience with big data processing using Hadoop technologies Apache Spark, Apache Flink, Databricks Notebooks, DeltaLake, Hive, Pig, and Yarn. ✅ Good experience with NoSQL databases HBase, MongoDB, and a good understanding of Cassandra. ✅ Good experience with Azure Synapse Analytics & Azure Data Factory I would love to know more about your project, send me a message so I can have more details and we can start working on it as soon as possible. Thank you

£120 GBP in 7 days

4.4

(2 reviews)

2.0

@chirag9700

Hello, How are you? I have read your project description carefully and I have rich experience in this type of work. Let me tell you about my expertise. I am Microsoft Expert. I have more than 3+ years of experience in PowerApps and PowerBI. Also 7 years of experience in SharePoint, .NET and O365 technologies. Looking forward to discuss your requirement further. Regards, Chirag.

£100 GBP in 7 days

5.0

(1 review)

0.6

@rashidamjad

Hi there, I can work with your description of Automate flow of data from SharePoint (Excel file) to SQL database using Azure that you have provided including Microsoft Azure . I am a full stack developer with 4+ years of experience in both front-end and back-end development and have a good team of developers that have a fine experience in every niche available in Software Development in the market. I am a full time freelancer and believe that I can pull it off once awarded and provided with detailed requirements from your side. Hoping to hear from you soon take care. Regards Rashid Amjad

£250 GBP in 8 days

0.0

(0 reviews)

0.0

@elbatouriB

Hi i am a software engineer whit 3 years of experience, As Software/Data engineer your current situation is something that occurs much to me. I can fulfill your request in absolutely no time.

£60 GBP in 1 day