Quick & Easy ETL from Salesforce to MySQL with Workflow & Heroku

While sometimes unfortunate it is often necessary to have data silos that share data. The Extract, Transform, and Load (ETL) pattern has been around for a long time to address this need and there are tons of solutions out there. If you just need a quick and easy way to copy new & updated records in Salesforce to an external data source, a simple Heroku app and Salesforce Workflow might be the quickest and easiest solution. I’ve put together a sample Node.js application for this: https://github.com/jamesward/salesforce-etl-mysql

Check out a demo:

This sample app uses a Salesforce Workflow that sends created and updated Contact records to an app on Heroku, which inserts or updates those records in a MySQL database. A simple transform JavaScript function makes it easy to customize this app for your own use case. To setup this app for your own uses, check out the instructions in the GitHub repo: https://github.com/jamesward/salesforce-etl-mysql

Let me know how it goes!

This Week: Europe JUG Tour and SAP / Adobe Nanoconference

The last few weeks my wife and I have been tromping around the Alps (and we climbed Mont Blanc!) Now it’s time to get back to work. This week I’m visiting a few Java User Groups to talk about the usual topics: Adobe AIR and Flex

Here is the schedule:
July 7 – Zurich Java User Group
July 8 – Paris Java User Group
July 9 – Amsterdam NLJUG
July 10 – Warsaw JUG
July 11 – London Java Meetup Group

Also on July 11 I will be at the Adobe RedMonk SAP Enterprisey Nanoconference with James Governor of RedMonk.

Hope to see you somewhere along the way!

Thinking in Flex Presentation from JavaPolis 2007 is Online

The Thinking in Flex keynote which Bruce Eckel, Christoph Rooms, and I did at JavaPolis 2007 has been posted! Check it out!

Let me know what you think.

BTW: Don’t you love that Parleys.com is a Flex app?!? And they also have an Adobe AIR version of their app which works pretty well on Linux. (To install the Parleys AIR app on Linux install Adobe AIR for Linux and then get the Parleys .air file.)

James Ward is a Sell-Out

I’ve gone commercial. Kinda. I just bought jamesward.com and it is now my primary domain name instead of jamesward.org. I liked the .org URL but it’s a less familiar URL to non-geeks. You say .com and everyone knows what you mean. The .org will still work – redirects right to here.

So I’m a sell-out. Gone .com. Good news is that you still won’t see any ads on my site.

Let me know if you have any problems with the new domain.

Help me fix my blog [solved]

One of the “problems” with using Flex so much is that I get used to having a simple, predictable layout mechanism. I seem to have forgotten how to do just about anything in HTML. So can someone help me fix the Digg, Reddit, and Share This stuff below? I’ve tried and tried and can’t figure out how to get the dang things to align correctly. Ideally they would align to the bottom of a div or something. Gosh it’s really embarrassing admitting publicly that I can’t do HTML anymore. But since you have already seen how bad this blog looks, you probably already guessed that. :) Oh well. Please help.

Eckel Flex eSeminar; Buni Joins java.net; Twitter Addiction

Yesterday was an exciting day! Bruce Eckel and I hosted an eSeminar about Flex & Java. We had a few technical difficulties, but overall it was very good. You can watch the recording here:

Bruce and I have a few more eSeminars coming up, find out more info here:

Also yesterday the Open Source Buni Meldware Communication Suite joined the Java.net community. This is a great step forward for the project, which uses Flex for it’s Webmail client. More info from Andy Oliver:

And lastly, while at the Adobe Engage conference, I gained a Twitter addiction. Please help me indulge my addiction and add me as a friend: