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

Closed Posted 5 years ago Paid on delivery
Closed 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 )

Azure Elasticsearch JSON RESTful Scripting

Project ID: #17740856

About the project

8 proposals Remote project Active 5 years ago

8 freelancers are bidding on average $177 for this job

khanicha

You cvould utilize the powershell script and set the script execution using Windows Task Scheduler. Other alternative is by writing an CLI small apps which will download the RESTful service and store to Azure SQL as we More

$150 USD in 3 days
(2 Reviews)
3.5
deytps86

Hi I work in hadoop/Bigdata technologies that include spark kafka Cassandra mongodb elk stack etc Can we talk? Thanks

$250 USD in 3 days
(3 Reviews)
3.2
MBDotNet

Sure thing. I am an Expert in Microsoft Technology and a proven Azure Architect. Happy to help you on this cool task.

$183 USD in 3 days
(1 Review)
2.5
HalosysIndia

Hello, we can help you with your project. My name is Kabir, I'm an IT consultant at Mobiloitte. I'm responsible for discussing the job details. I carefully read your requirement and I confidently say your requireme More

$155 USD in 3 days
(0 Reviews)
0.0
dineshrajputit

Hi, I have 7 years of experience and working on hadoop, spark, nosql, java, cloud... Done end to end data warehouse management projects on aws cloud with hadoop, hive, spark and presodb. Worked on multiple etl projec More

$30 USD in 1 day
(0 Reviews)
0.0