I'm having an issue taking multiple rows of data from my sql db tables and inputting it into a template located in my action rule. It works when I set max query "select MAX(DBName) from AP_SQLEndpoint where delta=1", but I cant set that because I need the action rule to process for multiple rows from our table.
Background: I'm trying to automate the adding/removing of SQL and Oracle endpoints into IDM. I've successfully tested sending SOAP messages via PX using raw data I manually added to the SOAP Template. Our data team will daily input the required fields to add each new endpoint (serverName, DbName, SID/Service Name, Ports, etc) with the unique delta(1-add 2-remove) into our IDM tables. The PX will run after a pre-existing daily task.
Data Source: 2 more (getServerName) ; (getDelta) - For SQL endpoints
Action Rule: invokes Soap message with the data sources mapped within the template; do I need an Action Rule Condition?
You can use "iterator" data element to retrieve each row. It will work as "for" loop.
Please note PX can only retrieve one column at a time in SQL query.