No description, website, or topics provided.
JavaScript
Latest commit b1250b0 Aug 10, 2016 @jamesward use conn pool
Permalink
Failed to load latest commit information.
.gitignore init Aug 2, 2016
Procfile init Aug 2, 2016
README.md auto-create table Aug 2, 2016
app.json init Aug 2, 2016
package.json init Aug 2, 2016
server.js use conn pool Aug 10, 2016

README.md

Salesforce ETL MySQL

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.

Run on Heroku

  1. Deploy the app: Deploy

Run Locally

  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
    

Setup a Salesforce Workflow & Outbound Message

  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