SQL Server Query

SQL server connector can do a basic query by using the follow connection strings and querys as below ConnectionString EG:

Data Source=sql.instance.server.net;Initial Catalog=Instance1;User ID=userTest;Password=1234@!*THN

Sql Query EG:

Select * FROM Table1 where Field1 = 'hello'

the setup can then opt-in to update the table with a specific value in a target field. This can be useful for marking off lines that have been collected. In order to do this the “Update Table” dropdown should be marked as Yes, then input the “Update Table Name” of the table you wish to update. “Identifier Field” can be used to “match” the queried data with the response (the field names on the query result and the update table must match). “Update Field” is used to select the column you wish to update, and “Update Value” will be the string value that the connector uses to populate the update with.