Download Data using a Website API and load to SQL 2016

Hello, As an experienced .Net developer and having sound knowledge in ms sql server, i am very much interested to do this job. According to them, their API supports only .Net and they have 8 types of data available in the API. Anyway i can do this job, let's discuss more. Thanks

hi. I have 5+ years of experience in C# development. I have worked a lot with APIs and databases. here is one of my similar project: ---( https://www.freelancer.com/jobs/project-12123049/ )--- I have done many more. I'm very interested in working on this task. let's do it. waiting for your response...

Hi I can download data from job tracker dll and upload to the database. Depends on the fields, we can decided how to avoid duplicate entries. We can schedule the exe to run Thank you

I have built multiple projects based on .net and later using .net core sql server , entity framework , entityframework core , jquery , angular 5 and 6 also built real time apps based on google products

Hi, I can help by developing an app in C # that calls the api get the data and store it in sql server. The app can calculate a value based on the data, so in this way it can know if the data change or not. You can use the windows task scheduler to control the execution of the app. Contact by chat for details Thank you

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

I have 8+ year of experience in web and window application development using c#. I am done many projects in API based mobile applications. I can do this on 7 days.

Hello > I will connect to the website in a secure way. > I will create table if its not exists. > My system will run on daily bases and will do the operations. > Both can be done to drop the old table and create new one. or i can check if data exists then i will not re-insert it in table only new data will be insert. > my system will be fully optimize it will be speedy and secure. > YOU CAN PAY ME AFTER 100% COMPLETION. I am a full time freelancer with over 6 years of experience in .NET technologies. We can chat more if you wish and disuses more. Thanks for reading my proposals. Warm Regards Manzoor

Hello, i can write c# application that extract data daily from this site then save it to sql server database i will deliver source code waiting your answer Thank you

hello sir We can create SQL JOB , which call web page on specified time, then web page can extract data from your specified dll. we can do this job. We have 10 years of experience in asp.net c# and SQL server database. we can do work as per your requirement please inbox me so that we can talk thanks

Hi there - I'm Aly, I've seen your post and I'm interested. I've had much experience in Microsoft .net stack alongside MS SQL Server. I believe I'm aware of the scale of the goal you're trying to achieve here. I'm thinking on having a solution running in the first place, afterwards, we investigate a way to sync data instead of drop-create. I'd like to know more about the API you're targeting and your expectations in regards. Feel free to contact me so we can talk further. Sincerely, Aly El-Haddad

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

Hello? How are you? I have good experiences in "Download Data using a Website API and load to SQL 2016" as you can see my profile for these (.NET, C# Programming, Microsoft SQL Server, SQL). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.

I am an experienced Web and Software Developer, and I am very interested in your job post. I have an excellent experience in MVC,.Net Core, ASP.NET, C#, Linq, Entity Framework, MySQL, MSSQL, REST API, JSON, HTML5, Angular JS, JQuery, Javascript, AWS Lambda, AWS RDS. I believe communication is the key to every successful project. I look forward to discussing project requirements with you.

Hi there, I've read your project description and I think I can help you. I've sevaral years of experience as an c# developer and could start today. Kindly regards, Markus Weitzer

Hi i can easily do this for you, by using power shell for downloading. then using SSIS ETL solution to update the sql table. Depending on how big the download is, I will use either the SCD Transformation or just merge data once in sql staging table to the permanent table. Then the whole solution will be run on schedule from sql server agent job. my fee for this will be 200 USD Thank you

Hi there, I am Data Engineer with experience of working on diverse set of projects. I am fairly comfortable with writing pipelines in C#, Python, SSIS, Pentaho and Spark. I need to know a few things before we proceed, considering the performance metrics of prime importance we should go for a mature ETL tool, so, first, we get scalability and second, we don't need to worry about security etc. As far as the update or incremental load is concerned, we need a timestamp column in API so we fetch updated record. I am OK with writing code as well. I am just exploring our use case. I believe I am your man. Feel free to write back. We can discuss cost and effort required. Thanks and regards, M. A. Munir

More than 10 years of diverse and challenging experience in the field of Information Technology. Core competency in architecture, designing and implementation of software projects. I can do this project very easily. What I will do. Write a C# code for getting all the possible data from API. Embed that code in Secure Webservice. Call the webservice from SQL JOB by creating SP. Thank you! Zeeshan Hameed.

I have been in the Industry for more than 7 years. I have the done the same thing using SSIS packages which is more viable option if there are lot of data is to be handled. Also SSIS package is faster Relevant Skills and Experience I have been in the Industry for more than 7 years. And I have done the same thing using SSIS as well as Using C#.

Will Use Talend/ETL tool to extract data from the website. Will transform in required format and will insert into SQL server database using Talend components.