Help with importing from SQL to RIADA Insights

unknown

Given a SQL table such as:

Row | Name     | Contract |

-----------------------------

1      | Thing 1 | ABC        |

2      | Thing 2  | ABC         |

3      | Thing 2 | XYZ         |

 

How can I import it into RIADA to create objects that would look like:

Object 1:

Attribute Name: Thing 1

Attribute Contracts: ABC

 

Object 2:

Attribute Name: Thing 2

Attribute Contracts: ABC, XYZ

 

The Contracts attribute would be an object reference with an unlimited cardinality. I tried using the IQL for Object Mapping of "Contract Name" IN (${$CONTRACT{0}})  but no object gets mapped. I have done plenty of mapping before, just never where I'm trying to add multiple values from multiple SQL rows into a single attribute on an object.

 

 

Alexander Sundström_x0imga

HI!

Without having the full picture, is Contract Name where the value ABC and XYZ is stored for the different objects? If the are used as the Label you could use Label = instead

Also in your case, I think the end result for Thing 2 is that just XYZ is imported. To import multiple objects they values has to be piped, like ABC||XYZ 

Do you have the objects for ABC and XYZ created in Insight?

I guess you've already looked at the documentation, but it's available at https://documentation.riada.se/insight/latest/insight-manager-s-guide/import-and-synchronization/general-import-concepts

Feel free to attach some screenshof of the two objects types, what object that exist there, and the attribute configuration for those object types, and also for the object type mappings in the import.

Cheers!
Alexander