Version: 1.7
Category: Output
Extended Category: SQL
Action Package: Standard Actions
Description
Write attribute values to SQL
|
Parameter |
Description |
Example |
|
SQL Update Query: |
Use SESSION(attributeName) to insert attribute names into the SQL query. |
INSERT INTO ADM_PERSON (sAMAccountName, employeeID, cn, initials, givenName, sn, displayName, mail, telephoneNumber, mobile, userPrincipalName, description, l, department, distinguishedName, title, physicalDeliveryOfficeName, manager, userpassword, company) VALUES (‘SESSION(sAMAccountName)’, ‘SESSION(employeeID)’, ‘SESSION(cn)’, ‘SESSION(initials)’, ‘SESSION(givenName)’, ‘SESSION(sn)’, ‘SESSION(displayName)’, ‘SESSION(mail)’, ‘SESSION(telephoneNumber)’, ‘SESSION(mobile)’, ‘SESSION(userPrincipalName)’, ‘SESSION(description)’, ‘SESSION(l)’, ‘SESSION(department)’, ‘SESSION(distinguishedName)’, ‘SESSION(title)’, ‘SESSION(physicalDeliveryOfficeName)’, ‘SESSION(manager)’, ‘SESSION(userpassword)’, ‘SESSION(company)’) |
|
Force User Data Source |
Always write to this data source. Make sure it is an SQL data source. |
MS SQL |
|
Error attribute name: |
Write error messages to this session attribute. Default is to only log error messages. |
my-error-attribute |
Use Cases
Example 1: Save new data to table ADM_PERSON
This action will update the SQL table “ADM_PERSON” with information from Active Directory.
|
Parameter |
Value |
|
SQL Update Query: |
update dbo.ADM_PERSON set userpassword=’SESSION(userpassword)’, sAMAccountName=’SESSION(sAMAccountName)’, displayName=’SESSION(displayName)’, cn=’SESSION(cn)’, userPrincipalName=’SESSION(userPrincipalName)’, physicalDeliveryOfficeName=’SESSION(physicalDeliveryOfficeName)’ where employeeID=’SESSION(employeeID)’ |
|
Force User Data Source |
MS SQL Express 2005 |
DISCLAIMER
Information provided in this document is for your information only. PhenixID makes no explicit or implied claims to the validity of this information. Any trademarks referenced in this document are the property of their respective owners.The origin of this information may be internal or external to PhenixID. PhenixID makes all reasonable efforts to verify this information.
PhenixID - support.phenixid.se