Boomi Tips: The SQL Lookup

When transforming data through map, there may be situation where you need to query some information from a specific record (i.e. from source) and to map it for the destination.

 

If you need to perform query from a specific instance (i.e. Salesforce), you can do so by utilizing the Connector Call function.

 

connector_call

 

If you are trying to retrieve information from a  database instead, you may not be able to see the Database option available in the connector list!

 

Don’t be panic, as you can still query database table information via the SQL lookup function available in the lookup category:

 

sql_lookupl