Find Jobs
Hire Freelancers

ETL of Zoopla data into an existing SQL Server DB

£20-250 GBP

Kapalı
İlan edilme: 6 yıldan fazla önce

£20-250 GBP

Teslimde ödenir
I need the property (i.e. real estate) listing data that is available via Zoopla (they provide a general API) for specific geographical areas to be loaded into an existing SQL Server Database. The property listing update process will need to run automatically (e.g. twice a day) and will upload all new property listings for the area and any listings that have been amended since the last successful data upload. An initial upload process will also be required of all existing listings (approx. 4000). Zoopla provide an API (which I would expect you to use), however I would also like the “Last Sale” data that is available on the website (e.g. towards the right of this web page: [login to view URL] it says “Last sale £34,000 on 6th Feb 1998”). I am unsure if this bit of data is available through the API or not. Error logging will be required, so if the upload process fails then it is easy to determine the reason why. If one property listing has an error in the data, this should not stop the other property listings from being uploaded. I am a Business Analyst, former database developer, so hopefully will be able to provide a good specification and do any required work on the database side if needed.
Proje No: 15206478

Proje hakkında

22 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 6 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
22 freelancers are bidding on average £183 GBP for this job
Kullanıcı Avatarı
I am an expert in delivering custom scripts and tools Relevant Skills and Experience proven track record on this site Proposed Milestones £166 GBP - milestone
£166 GBP 3 gün içinde
4,9 (152 değerlendirme)
7,5
7,5
Kullanıcı Avatarı
hello, i read your project carefully and i easily can do this task done ready to start work now thanks Relevant Skills and Experience have a look to my reviews thanks Proposed Milestones £266 GBP - 266
£266 GBP 7 gün içinde
4,8 (195 değerlendirme)
7,4
7,4
Kullanıcı Avatarı
Hi, I went through your requirement and feel comfortable to do this job. I have good experience in website design & development. Please initiate chat to discuss further. Relevant Skills and Experience PHP, Word press, Magneto, CSS, HTML Proposed Milestones £150 GBP - Complete Milestone
£150 GBP 3 gün içinde
4,9 (100 değerlendirme)
6,1
6,1
Kullanıcı Avatarı
Hi, its pretty simple for me but I have few questions to ask, knock me for further discussion, PLEASE DON'T AWARD PROJECT BEFORE DISCUSSION. Thank You! Relevant Skills and Experience API, Data Scraping, PHP, Powershell, Software Architecture Proposed Milestones £150 GBP - milestone
£150 GBP 3 gün içinde
4,9 (87 değerlendirme)
6,3
6,3
Kullanıcı Avatarı
hello we have expertise in a website . we have developed we have 100 of website ping me on chat I will be explained more about my experience I do not have much space to write Relevant Skills and Experience I have 10 years of experience of website development and mobile application. I have very good knowledge of how to make complete software requirement of the specification Proposed Milestones £150 GBP - 3 milestone will be in the project please tell me best time when we can discuss project
£150 GBP 3 gün içinde
5,0 (43 değerlendirme)
6,2
6,2
Kullanıcı Avatarı
The last sale date and price may not be available via the api but I can scrape this from the page itself. Relevant Skills and Experience Development experience
£170 GBP 15 gün içinde
4,9 (40 değerlendirme)
6,3
6,3
Kullanıcı Avatarı
Hi antipodean friend, ** No, the last sale is not included in API. Could be part of "Zoopla Estimates" or "Property Historic Listings", but those require justification by request. Scraping listing by listing will be tedious but doable - at an extra charge. ** Bid is for my time to get familiar with Zoopla API enough to map to your SQL Server schame, and to create the PHP/PS script to run regularly (scheduled task/cron). Store date watermark locally. Relevant Skills and Experience PHP developer mainly while freelancing, but use Powershell extensively at fulltime job. SQL Server go-to man in my team (enterprise databases & performance), this is a trivial exercise though. Proposed Milestones £200 GBP - complete task
£200 GBP 5 gün içinde
5,0 (67 değerlendirme)
6,2
6,2
Kullanıcı Avatarı
hi i am expert in sql n servers and kindly check my feedback n lets discuss here Relevant Skills and Experience ready to start now Proposed Milestones £388 GBP - work
£388 GBP 5 gün içinde
5,0 (81 değerlendirme)
5,8
5,8
Kullanıcı Avatarı
Please send me details ,.................,........... Stay tuned, I'm still working on this proposal.
£150 GBP 3 gün içinde
4,9 (50 değerlendirme)
5,8
5,8
Kullanıcı Avatarı
hello,dear. It's my pleasure meeting you. I have read your requirements and I fully went through it. I am confident and I am sure that I can do your project. Please contact me for further discussing. Thanks for your interests.. ProjectName:ETL of Zoopla data into an existing SQL Server DB Relevant Skills: API, Data Scraping, PHP, Powershell, Software Architecture,
£150 GBP 1 gün içinde
4,4 (19 değerlendirme)
4,9
4,9
Kullanıcı Avatarı
Hello, I am expert in web scrapping. I and I am certified web scrapper expert. I have completed 100+ projects web scraping -- for web scraping projects. Relevant Skills and Experience I have 7 years+ experience in data mining, website scraping, screen scraping , software architecture, power shell, php, api. I am sure i can do your project with my perfection. Proposed Milestones £20 GBP - initial milestone
£20 GBP 3 gün içinde
4,2 (7 değerlendirme)
5,0
5,0
Kullanıcı Avatarı
Hi Dear We have a team expert in Extraction , Transformation & Loading. We have done many projects for many clients. We have develop many ETLs that execution job automatically. Relevant Skills and Experience We are certified from SQL l server integration services , Ta-lend , Oracle Data Integrator. We will not only give you system as well give you automation so that all things executed automatically. Proposed Milestones £250 GBP - Mailstone waiting your response
£250 GBP 3 gün içinde
5,0 (5 değerlendirme)
3,6
3,6
Kullanıcı Avatarı
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html Relevant Skills and Experience I have 7 years and 9 months experience in SQL and 5 years experience in SSRS, SSIS. Proposed Milestones £149 GBP - ETL of Zoopla data Please let me know more details and when we will start. Sky pe: jikenjd
£149 GBP 10 gün içinde
5,0 (3 değerlendirme)
2,8
2,8
Kullanıcı Avatarı
I have extensive experience in PHP,Wordpress. Based on your requirements I would be happy to assist you and assure you for quality work within reasonable amount of time Relevant Skills and Experience PHP, ECOMMERCE, HTML, CSS, JAVASCRIPT, ORACLE, MY SQL, WORDPRESS, WEBSITE DEVELOPMENT, WEB DESIGNING, GRAPHIC DESIGNING, LOGO DESIGNING Proposed Milestones £60 GBP - 1 £90 GBP - 2
£150 GBP 3 gün içinde
5,0 (2 değerlendirme)
0,8
0,8
Kullanıcı Avatarı
Hello Sir, I am Showmik. I am highly interested at your proposed work. I think, I am the best person for this job. I wont let you down if you give me the chance. Relevant Skills and Experience API, Data Scraping, PHP, Powershell, Software Architecture Proposed Milestones £150 GBP - SQL - Back end
£150 GBP 5 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hi, I am Rose.I am having more than 10 years of experience in this field. I can complete this work in 2 days. I am looking for long term good business relationship here. Let me know. Thanks Stay tuned, I'm still working on this proposal.
£166 GBP 2 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Yes, I can use the API to get the listing and store then in the SQL. Last Sale data point is not available through API. Will write a code to scrap the website directly to get that piece of data. Relevant Skills and Experience Have done similar projects, loaded API data in SQL. Proposed Milestones £100 GBP - On awarding the Project £100 GBP - On completion of the the loading of the API data in SQL Server £50 GBP - On population of the Last Sale data in SQL Server. Additional Services Offered £50 GBP - Can optimize SQL Server Object-- the cost is for per code/stored proc. You will provide the SQL Server Environment where the code can be developed and tested.
£250 GBP 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   UNITED KINGDOM bayrağı
United Kingdom
0,0
0
Eyl 19, 2017 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.