jamesward / salesforce-etl-mysql Goto Github PK

This sample application shows a simple way to use a Node.js app along with Workflow on Salesforce to do Extract, Transform, and Load (ETL) from Salesforce to MySQL.

1. Deploy the app:

1. Create a local MySQL database named demo

2. Install the Node.js dependencies:

    npm install
   

3. Run the local dev server:

    npm run dev
   

4. Start an ngrok tunnel:

    ngrok http 5000
   

1. Create a new Workflow
2. Select the Contact object
3. Give the rule a name
4. Select created, and every time it's edited
5. In the Rule Critera select forumla evaluates to true and enter True in the formula field
6. In Immediate Workflow Actions select New Outbound Message
7. Give the Outbound Message a name, enter the Endpoint URL for either your Heroku app (e.g. https://foo.herokuapp.com/) or your ngrok endpoint for local testing (e.g. https://1234.ngrok.io/)
8. Select the Email, FirstName, and LastName fields