Salesforce Developer Needed

Closed Posted 5 years ago Paid on delivery

$30-250 AUD

Paid on delivery

Closed Paid on delivery

We have a custom object created in salesforce that need to be synced to a mysql database in near-realtime. Write a ruby 2.4 program that periodically pulls data from salesforce objects by using CDC API from salesforce.

Create a table in Mysql that contains the data pulled from salesforce.

To facilitate auditing and troubleshooting, create another table in MySQL to track API calls made along with CDC message results. Those messages need to be played in order (sequence of operation) so that the final result is alligned with the data inside Salesforce object.

Some useful links are as follows:

Salesforce CDC [login to view URL]

Salesforce Bulk Query[login to view URL]

Deliverable

- create a mysql table that contains your source data. Name it SourceTable

- a ruby 2.4 script that uses builk update/insert to load data from SourceTable into Salesforce object.

- a ruby script that makes the CDC api call (to capture the change) and store result in mysql table.

Name that table CDCMessages.

- another ruby script that plays out CDC api messages in sequence and updates the target mysql table. Call that table TargetTable.

- a sql statement to verify that source and target tables are the same

Salesforce.com Salesforce App Development Ruby MySQL

Project ID: #22498834

About the project

12 proposals Remote project Active 5 years 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

12 freelancers are bidding on average $218 for this job

dreammate0621's Profile Picture
dreammate0621

Dear Client! I am very happy to see your project detail. I think it is just my project. :) As you can see in my profile, (my review: https://www.freelancer.com/u/dreammate0621?w=f) I have much experience with 8+years. More

$140 AUD in 7 days
(14 Reviews)
6.4
akhileshgandhi's Profile Picture
akhileshgandhi

Hi, Professional Certified SalesForce Developer can help you with anything related to SalesForce , can start by the time you hire. Do have a strong knowledge of Salesforce Architecture, Design, and Development along More

$140 AUD in 7 days
(5 Reviews)
3.7
ankitsehgal101's Profile Picture
ankitsehgal101

Hi, I am a 2x certified salesforce developer with extensive experience in third party integration into salesforce. I am currently pursuing MIT from Deakin University in Melbourne and working as a part time freelancer. More

$555 AUD in 5 days
(2 Reviews)
2.1
donnyforu's Profile Picture
donnyforu

Hello, Hope you are doing well! I have seen your project detail and wanted to get in touch with you regarding your project. I am a certified salesforce developer with 7+ years of experience working in different skill More

$250 AUD in 5 days
(2 Reviews)
0.8
sunnyvijaysunil's Profile Picture
sunnyvijaysunil

salesforce developer with an experience of 3+years perfection in work and good at understanding any kind of scenarios

$238 AUD in 4 days
(0 Reviews)
0.0
Patidarkapil1418's Profile Picture
Patidarkapil1418

I am having expertise in this field, I can do this for you within due time and honestly. my trailhead badges is 67 I also have a few questions to discuss kindly contact me and we will discuss time and budget thanks

$35 AUD in 1 day
(0 Reviews)
0.0
Post a project like this