For more complex SQL examples see Manual > Administration > Data Actions > SQL

SQL Data Actions require a Connection String to their data source e.g.

Database=ExampleDB; Data Source=exampleserver\exampleinstance; User Id=ExampleUser_RO; Password=ExamplePassword;

It is recommended any service user account is setup with the minimum requirements e.g. only use a read only account if you don't need to write anything back.  Do not use accounts shared with other systems!

Input mappings are available as parameters in the SQL Query e.g. Input Variable Name of Example1 can be used as @Example1 in the SQL Query.