This example shows how to use Pentaho Kettle Data Integration (which we will refer to just as “Kettle”) to:
Kettle is a free, open source ETL software. The tool’s abilities can be separated into 4 phases: Extract, Transform, Load, and Automate.
.kjb), transformations can be run on a scheduled basis.
The plug-in uses DataSync under the hood to update the dataset. Users familiar with this tool will be ahead of the curve with this plug-in.
Before continuing on, please follow the link, download, and configure the plug-in within your Pentaho Kettle instance.
Design > Input > Salesforce Input
Gotcha: The default date formatter can sometimes incur errors. Try pressing play on the workflow after connecting to the Salesforce object. If the log file mentions a date error, try adjusting the format in the Input.
In this example I have connected to 3 different objects. Now I need to rename fields, filter out others, join the objects, and create a field for the Socrata platform to geocode.
Now that you have downloaded and configured the Socrata plug-in (link provided above) you should see the Socrata Output in the list of Outputs.
Use Socrata geocoding: check yes if one or more columns are type Location