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 

 

know_more.png

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!

Attachments

Outcomes