Write and Match to SQL

Parameter

Description

Example

Force User Data Source

Always match and write to this data source.

MS SQL 2008

SQL Match Query:

Match a session object with an SQL data source. Use SESSION(attributeName) to insert attribute names into the SQL query.

SELECT USERNAME FROM IDMAPPING WHERE OBJECTID=’SESSION(ObjectId)’

SQL Update Query:

This query will be executed if Match query found a result. Leave blank if no update should be executed. Use SESSION(attributeName) to insert attribute names into the SQL query.

UPDATE Person SET LastName=’SESSION(LastName)’, FirstName=’SESSION(FirstName)’ WHERE Userid=’SESSION(Userid)’

SQL Create Query:

This query will be executed if no Match was found. Leave blank if no create should be executed. Use SESSION(attributeName) to insert attribute names into the SQL query.

IINSERT INTO IDMAPPING (USERNAME, OBJECTID) VALUES(‘SESSION(samaccountname)’, ‘SESSION(objectid)’)

Set isNew Flag (true/false):

If set to true, the isNew flag will be set if the SQL Create query is executed. Default: false.

true

Parameter

Value

Force User Data Source

MS SQL EXPRESS 2005

SQL Match Query:

SELECT * From Person WHERE Userid=’SESSION(Userid)’

SQL Update Query:

UPDATE Person SET LastName=’SESSION(LastName)’, FirstName=’SESSION(FirstName)’ WHERE Userid=’SESSION(Userid)’

SQL Create Query:

INSERT INTO Person (Userid, LastName, FirstName, Password) VALUES (‘SESSION(Userid)’, ‘SESSION(LastName)’, ‘SESSION(FirstName)’,’SESSION(Password)’)

Set isNew Flag (true/false):

[BLANK]