Skip to content
+1-888-319-3663

COMMUNITY FORUM

Running map from SQL

Mike Tsui asked 1 year ago
Is there a way to run the SC mapping from SQL task ?
 
Also possible to group mapping, ie Map 1 – import form text, Map 2 – import from SQL to GP
If map 1 fails, do not run map 2 ?
 
 
Answers
Patrick Roth Staff answered 1 year ago
1. this old blog article talks about how to do exactly this
https://www.eonesolutions.com/tech-tuesday-executing-smartconnect-maps-from-sql/
 
2. you get that by default unless you are doing something odd
map1 executes and it is either a “map failed” or “map success”
so in your case, you’d make a ‘map success’ event to do a “run map” task on the first map which then would run the second map.
since if the map fails the ‘map fail’ event runs and there would no run map task, the second map never gets executed
Mike Tsui replied 1 year ago

That is awesome, thank you so much


If you would like to submit an answer or comment, please sign in to the eOne portal.