Find Jobs
Hire Freelancers

Data synchronization scheduled task between several cloud business applications

$750-1500 USD

Closed
Posted about 8 years ago

$750-1500 USD

Paid on delivery
Overview Our company has several business applications running in the cloud: Sharepoint lists and libraries (Office365) together with Mailchimp and Freshdesk, functioning as CRM repository. These applications all store customer details (companies and contacts) separately which results in data duplication and inconsistency. Therefore, we need some background task that can keep that data synchronized and up-to-date. All the company applications are hosted in the cloud and have public (accessible from the internet) Web APIs which can be used to programmatically snychronize data: Freshdesk: [login to view URL] Mailchimp: [login to view URL] Sharepoint: [login to view URL] Desired outcomes • The company employee should update a customer record in one application, and that change should be reflected in other applications (say, every 60 minutes or less). • The company IT admin should be able to define sync rules between various applications. This admin interface can be a Sharepoint list app or even a text config file with documented syntax. Implementation remarks and details When syncing data between 2 sources, the admin can define: • The data sources: o Sharepoint list url o Mailchimp list id o Freshdesk contacts or companies • Replication type: o master-slave, defining what data source is master and what is slave o peer-to-peer, defining what data source is master in case of replication conflict i.e. same record has been changed in both apps. • What fields need to be synced (based on the data sources selected) • What fields are to be considered keys that identify the mapping between data sources • If there are no fields that can be used as keys, there should be a way to make a first time data reconciliation where a field from one data source is copied another and serves as key for future replications Preferred Technology C# .Net sync task application, scheduling realized via Azure WebJobs or Scheduler (no on-premise server). All testing should be done on developer accounts, not on the company data. We can supply test data, but the developer should signup for free trial accounts of applications listed above. Deliverables all source code and functional sync application with admin interface (either Sharepoint list or text config file, see above).
Project ID: 9532658

About the project

24 proposals
Remote project
Active 8 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
24 freelancers are bidding on average $1,640 USD for this job
User Avatar
Hi, I’ve had a good look at your project description and I’m very interested in providing a solution. I have 4+ hands on experience on developing quality web solutions as well as desktop standalone solutions. I used to develop systems using latest adaptive technology such as 1. .NET/ASP.NET - MVC4,MVC5 - Entity Framework - SQL - C# (for .NET solutions) 2. JQuery/Javascript/HTML5 - Angular.js/Bootstrap etc (for designing and front end implementations) I want to start work immediately and awaiting for your positive response on skp id "agilepksolutions" so I can show you some of my Quality Development Work as well as we can discuss project in details. Thank you.
$1,184 USD in 20 days
5.0 (114 reviews)
8.1
8.1
User Avatar
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Regards, Eyad
$3,289 USD in 60 days
5.0 (59 reviews)
7.9
7.9
User Avatar
Hope you are doing great. I have checked the given detail of this project and I am interested to provide you my services. I have more than 7 years in providing professional website development services and worked with almost every type of project. So this is an easy one for me as well. What I need is to finalize clear requirements (that play a big role in success of every project) and that needs your few minutes to discuss over the project with me. Let me know your availability and let’s get this project done!
$1,666 USD in 20 days
5.0 (11 reviews)
5.6
5.6
User Avatar
Hi, Please feel free to discuss the project with me...................................................................................................... Thanks, Murtaza
$1,500 USD in 30 days
5.0 (12 reviews)
4.7
4.7
User Avatar
Hello, As per your post, i have understood your requirement. We provide IT development solutions to enterprise, mid – sized companies and even start ups across the globe; with heavy focus on DOT NET, MS Dynamics CRM, SharePoint, Salesforce, Parature, USD and Cloud based solutions.  We are a team of dedicated professionals who have expertise in developing solutions for Microsoft Dynamics CRM, O365, Cloud Computing, Mobile Apps etc. We have extensive experience in different verticals like finance, manufacturing, healthcare etc. and specialize in building custom web & e-commerce applications, social media apps and m-commerce/mobile applications. We I hope you will provide us the opportunity to work for you long term basis. I thank you for your time and considerations. I look forward to hear from you . Regards.
$1,526 USD in 10 days
4.2 (13 reviews)
4.9
4.9
User Avatar
Hi, Im Microsoft Certified Solution Developer with expert skills in C#. NET development and API usage. My Skype ID is sbakhmetyev
$1,333 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have done several of the same project. This time round I promise to produce my best top quality. Please contact me via chats
$888 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi guys, I was doing some quick analysis over your project, I think this sync project is doable but I would suggest some changes on your approach (high level) to keep it simple and maintainable: -To have one main Customer Database (SQL DB) with Companies and Contacts tables to maintain the most updated information there. -To have 2 task on the sync process -Task 1 will pull the information for each external data (Freshdesk , Mailchimp and Sharepoint, based on a search that will filter the data and take those records that where updated recently after the last run where UpdateDate>=LastRunDate that way you will get the delta) and could update/insert the information on the main Customer Database, a LastUpdatedExternalData flag can be define to know what was the last external entity that updated the record) -Task 2 will push the information into the external data from the main Customer Database (you could decide either to update/insert or just update information over the external data the search criteria should be the same where UpdateDate>=LastRunDate + the LastUpdatedExternalData<> currentExternalData that is being processed) I would like to comment that I have several years on the field, using agile SDLC, working with background process and I could guarantee al my development have high quality not only about coding but also about to give you some suggestions related to design and implementation. Please let me know if you have any question. Thanks, Carlos.
$5,555 USD in 90 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Data sync is a complicated process. A couple of questions ? How frequent the sync job will run ? Do you need a retry process ? Do you need a volume control such as only sync the first 1000 of data retrieved ? .. there are quite a lot to consider ...
$1,444 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, we work from website development to software development, mobile programming, android ans iOS apps, game development, SQL-Server, MySql, Ms Access, Oracle, Object Oriented Programming, Shell Scripting, Computer Graphics and algorithms development. I assure you best quality work. I am waiting to listen from you soon.
$3,000 USD in 60 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CROATIA
Rijeka, Croatia
0.0
0
Member since May 13, 2015

Client Verification

Other jobs from this client

Write some Software
$30-250 USD
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.