Use existing import set with a separate transform map?

[leochavez]

We currently have an LDAP import process in place to processes user data, but takes some time to run.   As with most organizations more data was required and so we added another attribute, but the data contained within this particular attribute requires extensive processing (string parsing and DB queries), essentially tripling the import run time.   To mitigate this, I created a separate transform map that processes the new attribute data. Looks good so far.

While scheduling a data import, I saw an option to run 'after parent runs'.   Great option for my situation, but this is where my mind began to wonder..... if the data used by both imports are the same, is there was a way to utilize an existing import set (albeit processed), reducing MID Server/LDAP workloads and whatnot.

I'm sure I could hack together a bit of code that would locate the import set via the 'sys_import_set' table, update the state to 'Loaded', at which point a scheduled data import could take over.....or something along those lines.

All that said, is this possible?   Is there a way an existing import set can be reused by another transform map without having to script around it?

[Michael Fry1]

Isn't that the same as having 2 transform maps, with different order numbers, on the same data source?

[leochavez]

Hi Michael,

So assigning different order numbers to each transform map, but keeping the data sources and the import set table the same, would have each transform map using the same import set but would run in order provided?

- Leo

[Michael Fry1 · Accepted solution]

Yes - Enter the order in which to apply transform maps in the event that more than one map fits the conditions. ServiceNow runs transform maps from lowest to highest Order. Creating New Transform Maps - ServiceNow Wiki

[leochavez]

Hi Michael,

I will read through the documentation you noted and (hopefully) consolidate my work a bit.

Thank you for keeping the KISS design principle alive and well.  

- Leo