CA PAM::. How to use Query_Database operator - Process Example

Document created by TMACUL Champion on Feb 9, 2017Last modified by TMACUL Champion on Feb 11, 2017
Version 2Show Document
  • View in full screen mode

HowItWorks.jpgCA PAM - How to use Query_Database operator


itpam--Select from Database Operator--ICO--OTH (v4)



01. Database Properties


  • Input Source (Specifies that the user can choose to submit SQL statement as an in-line expression (the default) or data variable. Select either Inline Text or Expression from the drop-down list)
    • Expression
  • Expression (Only available when Expression is selected as the Input Source. Specifies the generic SQL statement as an expression. Use this field to provide a variable.)
    • select count(0) from ca_contact


02. Database Server Login


  • Username
  • Password



03. Connection Wizard


  • database Type
  • Server Host
  • Server Port
  • Database name
  • Driver Name
  • SQLServer Instance Name
  • Connection URL






Oficial Documentation:

Select from Database Operator - CA Process Automation - 4.2.2 - CA Technologies Documentation 



CA PAM::. How to read a XML file - applyXPath Function 

Summary CA Process Automation 

Summary CA Service Management Community 

Service Desk Manager 15 days Implementation 

CABI:: Summary - BOXI for CA SDM 

Summary CA SDM Scoreboard 




Was useful, please leave your feedback!