Transform Map into multiple tables with Relationships intact

[RobertM2]

Hello,

I have a data source that is running a SQL query that grabs columns for multiple related tables. For example:

SELECT *
FROM Employee E
LEFT JOIN Compensation C
ON (E.ID = C.Employee_ID)
LEFT JOIN Funding] F
ON (E.ID = F.Employee_ID)

We want to be able to transform that import into 3 similar tables in ServiceNow with relationships intact. I see that I can add multiple transforms to any single data source but I have no idea how to make sure the relationships are retained.

Any thought to an approach?

[Brad Tilton · Accepted solution]

It sounds like you may want to look into the Robust Imprt Set Transformers introduced in the Orlando release. You may be able to do something with multiple transforms and scripting some of the fields to retain the relationships if you're not yet on Orlando.

[RobertM2]

Thank you! That definitely looks like we what need in the near future. In the meantime, I ended up importing the 3 tables with 3 separate data sources into "raw" tables. From there I was able to associate them through reference fields in 3 "clean" tables. Its not the ideal method but it does work for our purposes for now.