Version: 1.5
Category: Input
Extended Category: SQL
Action Package: Standard Actions
Description
Add data from a JDBC/ODBC data source.
|
Parameter |
Description |
Example |
|
SQL Query |
SQL query to add attributes from. Use SESSION(attributeName) to insert session attributes |
SELECT * FROM table |
|
SQL Data Source |
Select SQL data source |
HR Database |
|
Require all Session Attributes (true/false) |
All session attributes must exist before running the SQL query. (true/false) |
true |
|
Cache Queries (true/false) |
Cache queries. (true/false) |
true |
|
Store Multiple Matches in Multivalue Attribute (true/false) |
If multiple matches are found, store them in a multivalue attribute. (true/false) Default: false |
true |
|
Escape ‘ in Attribute Value (true/false) |
If ‘ in value from SESSION(attributeName) should be escaped. (true/false) Default: true |
true |
Use Cases
Example 1: Get attribute from SQL
The action can be used to get Username from SQL table.
|
Parameter |
Value |
|
SQL Query |
SELECT username FROM idmapping WHERE objectid=’SESSION(ObjectId)’ |
|
SQL Data Source |
Internal SQL |
|
Require all Session Attributes (true/false) |
true |
|
Cache Queries (true/false) |
[BLANK] |
|
Store Multiple Matches in Multivalue Attribute (true/false) |
[BLANK] |
|
Escape ‘ in Attribute Value (true/false) |
[BLANK] |
This will get the value from the Data Source “Internal SQL” in column “username” from the table “idmapping”. This session attribute can then for example be used to create a user in a LDAP data source.
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