Closed

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

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 )

Skills: Azure, Elasticsearch, JSON, RESTful, Scripting

See more: oracle data using velocity, find excel data using, php script pull html data, useful statistical tool analysis data questionnaire, read excel data using, data stock market data using, upload data using tab delimited sql plus, build script asp will give xml sitemap, insert data using file csv sysutil, sending data using gprs, capture data using excel, script cut paste data website excel, build web base app data entry form, reading excel data using, fill form field database data using ajax, run scheduled task logout script, create yammer app using rest api json, rest json data, tool extract data json

About the Employer:
( 2 reviews ) Aarhu, Denmark

Project ID: #17740856

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
hammadabbasi01

Hi, Review my profile.  4 Years of experience as BI/ETL Developer and Oracle Business Intelligence Certified professional. Adept in preparing data for analysis, Creating dashboards deploying dashboards on serv More

$222 USD in 3 days
(0 Reviews)
0.0
$277 USD in 7 days
(0 Reviews)
0.0
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
majdisaibi

Dear Sir! I’m Majdi, Microsoft Certified Solutions Associate in Web Development. I’m also Microsoft Certified Trainer in web technologies. I have a rich experience building modern web applications using modern techn More

$150 USD in 4 days
(0 Reviews)
0.0