Connect Oracle 11g with SQL Developer for TL

Products

• CA Privileged Access Manager - Cloakware Password Authority (PA)
• CA Privileged Access Manager (PAM)

Issue/Introduction

How to configure the Transparent Login to Oracle SQL Developer?
If the Learn Mode does not recognize the fields of the tool, then below there is an example of how to configure it by using the mouse-click and keyboard commands ({TAB}, {ENTER}).
 

Environment

Oracle SQL Developer 18.1.0.095.1630

Resolution

The Oracle SQL Developer tool works with 2 different Windows Titles so we had to create two XML Transparent Login Configutation scripts.

• The first XML Config is for the mouse-click only to click on the "Create a Connection Manually" button.

Is important to know that the mouse click is based on the position of the mouse. If we are going to launch the tool and expand it, then the button may move and we have to ensure that the position is inside the button.

Windows Title: Oracle SQL Developer : Welcome Page

XML Config:
<window id="">
  <click x="529" y="475"/>
</window> 

 

• The second XML Config includes the username, password and hostname for the autologin. And the possition of the fields is moved by the TAB commands and a mouse click to Connect.

Windows Title: New / Select Database Connection

XML Config:
<window id="">
  <send host="true"/>
  <send text="{TAB}"/>
  <send username="true"/>
  <send text="{TAB}"/>
  <sleep time="500"/>
  <send password="true"/>
  <send text="{TAB}"/>
  <send text="{TAB}"/>
  <send text="{TAB}"/>
  <send text="{TAB}"/>
  <send text="{TAB}"/>
  <send text="{TAB}"/>
  <send host="true"/>
  <click x="621" y="394"/>
</window> 

 

• Create the RDP Application Service and enable the Transparent Login. 

a) Click on the "+" Icon and enter the following details:
Windows Title: Oracle SQL Developer : Welcome Page
Transparent Login Configuration: Oracle SQL Developer
b) Click on the "+" Icon and enter the following details:
Windows Title: New / Select Database Connection
Transparent Login Configuration: Oracle SQL Developer 2nd
c) Click on Save.

• Finally create a policy with the service and select the target accounts. In the first Window Title there are no credentials required, however you need to select one in the Policy.

Additional Information

This is a example of how to configure the Oracle SQL Developer. 
Remember that the Window Title MUST match with the window tittle of the tool. Otherwise PAM won't identify it and won't execute the script.