SQL Lookups

From Starfish ETL
Jump to navigation Jump to search

Server-Side Lookup Function Fields can be used to obtain data from other tables within the Destination database. Below is an example of a lookup returning an AccountID based on a Account-name lookup. The Account name is provided by the Origin field “Account”. Note how variables can be used within the SQL statement itself. The Variable code will be replaced with the actual value at run-time.

Server-Side lookups are also useful for generating ID’s. The example below calls a SalesLogix stored procedure to generate an ID for the Account table.