Find Jobs
Hire Freelancers

Download Data using a Website API and load to SQL 2016

$30-250 USD

Closed
Posted about 5 years ago

$30-250 USD

Paid on delivery
Write C# Code to download all Data possible from Moraware [login to view URL] and upload it to a SQL 2016 Write Code to download all data 1. Connect securely to website 2. If the table does not exist, create the table Upload all data to SQL 3. This download will execute daily. Investigate what is the best way to do this. SQL job? 4. Investigate if there is any way to download only changes of data. Otherwise, If there are tables already, drop the tables and download the data. 5. Want to ensure performance and security [login to view URL] [login to view URL]
Project ID: 18563111

About the project

33 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

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
33 freelancers are bidding on average $219 USD for this job
User Avatar
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
$300 USD in 7 days
5.0 (416 reviews)
8.2
8.2
User Avatar
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...
$250 USD in 6 days
5.0 (166 reviews)
7.6
7.6
User Avatar
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
$277 USD in 5 days
4.9 (110 reviews)
7.4
7.4
User Avatar
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
$250 USD in 3 days
5.0 (38 reviews)
7.2
7.2
User Avatar
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
$155 USD in 3 days
5.0 (103 reviews)
6.3
6.3
User Avatar
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
$250 USD in 4 days
4.9 (48 reviews)
6.4
6.4
User Avatar
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.
$266 USD in 7 days
5.0 (23 reviews)
6.0
6.0
User Avatar
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
$166 USD in 5 days
4.7 (44 reviews)
6.0
6.0
User Avatar
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
$120 USD in 3 days
4.9 (81 reviews)
5.4
5.4
User Avatar
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
$277 USD in 3 days
4.9 (11 reviews)
5.1
5.1
User Avatar
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
$160 USD in 2 days
4.9 (26 reviews)
5.1
5.1
User Avatar
Hello, I read your requirements and understand very-well and ready to start work from now. Thank you
$250 USD in 5 days
5.0 (2 reviews)
4.5
4.5
User Avatar
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.
$155 USD in 3 days
5.0 (10 reviews)
4.2
4.2
User Avatar
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.
$250 USD in 10 days
5.0 (5 reviews)
4.0
4.0
User Avatar
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
$250 USD in 3 days
5.0 (8 reviews)
4.1
4.1
User Avatar
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
$222 USD in 3 days
5.0 (2 reviews)
3.1
3.1
User Avatar
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
$155 USD in 3 days
4.9 (3 reviews)
2.0
2.0
User Avatar
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.
$194 USD in 4 days
5.0 (2 reviews)
2.0
2.0
User Avatar
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#.
$166 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Suffolk, United States
0.0
0
Member since Jan 21, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.