Build a script/tool to retreive data using REST/JSON/Elastic Search and post it to Azure SQL database -- 2

$30-250 USD

Completed

Posted

over 5 years ago

$30-250 USD

Paid on delivery

We currently have a document automation tool that can do lookups in external tables. Some of these tables are on an external Azure database. This works fine.! - One table however has previously been populated with data from yet another external table however this functionality is broken so the data has not been updated in a while. ( no one can find the script that did it ) The external database is this ([login to view URL] ) Danish list of company registration API index: [login to view URL] The tool should be able to connect to the external database described above and retrieve a subset of this data. The data should then be inserted/updated in the Azure database. The script/tool should be able to run as a scheduled task in Windows as well as manually. The script/tool should also be able to retrieve only delta changes in order not to retrieve and update the entire database. (Elastic Search allows for this )

Project ID: 17979784

About the project

1 proposal

Remote project

Active 6 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

Awarded to:

@GenteelSystems

Hi, I would create this application as a console application that can be run either directly using batch file or can be scheduled via Task Scheduler of windows. I will retrieve the data from the external database using the APIs, will have to look into the API docs for that and populate the data in an Azure storage database for which the credentials will be configurable, so that you will only have to change the credentials in your configuration file and the Azure database will be connected automatically. Regards, Naveed Butt

$188 USD in 5 days