SQL query in px actions doesn´t work
search cancel

SQL query in px actions doesn´t work


Article ID: 186226


Updated On:


CA Identity Manager CA Identity Suite


We want to create a PX policy that inserts a row in an external SQL table for specific events.

we have configured the SQL server database in JBoss datasources and the connection works fine.

We have tried a simple SELECT query in the PX to test the connection. connection and query works fine if is tested in the Data tab.

but, the same query tested in the Actions tab doesn´t work.




Release : 14.X

Component : IdentityMinder(Identity Manager)


While the Data tab is used to gather data (ie select), the Action tab is more for activity oriented - such as Insert, Update etc.

Utilizing insert / update oriented queries from the Action tab is working as expected