Connect Oracle 11g with SQL Developer for TL

Document ID : KB000092745
Last Modified Date : 23/04/2018
Show Technical Document Details
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
Instructions:
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
Firs Screen
XML Config:
<window id="">
  <click x="529" y="475"/>
</window> 
XML TL Config1
  • 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
User-added image
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> 
User-added image
  • 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.
User-added image
  • 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.