Ramp Up Video #3: Fighting Crime with SnapLogic
 |
 |
This title is only half-joking. Today’s Ramp Up video delves into how to use the Open Source SnapLogic data integration application to build a system that lets you screen the contacts from your CRM system against the SDN List for assistance with achieving OFAC compliance. In this video we’ll build a pipeline that:
- Consumes an XML feed of the data from the Federal SDN suspected criminal list
- Grabs contacts out of a SugarCRM instance running remotely on Amazon EC2
- Compares the contacts from the CRM system against the names on the list
- Presents the records that are potential matches
- Can have another system like Salesforce or Quickbooks easily “snapped in”
This tutorial is intended to give you the motivation and instruction you need to get started quickly with SnapLogic. This application is a powerful tool that can be used to mash up data from databases, spreadsheets, webservices, applications and many other different sources. In the next forty minutes we’ll use the JumpBox for SnapLogic and the JumpBox for SugarCRM to demonstrate the creation of this system from start to finish. You’ll learn the fundamentals of SnapLogic and pick up some development tips that are also applicable in other situations.
Below is the video, a time-coded table of contents, the widget to launch your own private instance and a zip file with all the assets used in the tutorial. Leave a comment below if you have questions about the tutorial or the JumpBox aspects. And for in-depth SnapLogic questions consider joining their extremely responsive mailing list found here.
|
Download a zip file of the following files used in the video here:
|
*Tip: To view video at full-resolution in hi-def, make sure the 
button is on and click the 
button to expand the screen.
[...] to address. The challenge involves fighting crime and frozen bank accounts. Curious what it is? Watch the video to find [...]
Really boring video, it also shows your system is only for geeks that will read thru XMLs, and maybe that geek already has a library that does what you do with this app.
¿Who are you directing to?
¿Is it old Cobol dinosaur programmer that you need to explain what an FTP is?
Anyway,
goodluck!
(btw: I came here from TC, so the plug worked)
[...] JumpBox team also created a great example of using SnapLogic to check contacts in SugarCRM against the Specially Designated Nationals (SDN) list published by [...]