<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users in PAM Self-Hosted Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345844#M39055</link>
    <description>&lt;P&gt;PSM SQL Developer.&lt;/P&gt;&lt;P&gt;when launch connect from PVWA credential is not populating automatically&lt;/P&gt;</description>
    <pubDate>Wed, 29 Apr 2020 19:22:51 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2020-04-29T19:22:51Z</dc:date>
    <item>
      <title>Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345835#M39046</link>
      <description>&lt;P&gt;I have SQL developer used by the Oracle team via PSM with no issues.  I am on-boarding Sybase team as well and they also want to use SQL Developer. There's jtdc.jar file which I have add in the SQL Developer Preferences to enable the sybase tab for connections to Sybase databases. But after adding the jar file, the Sybase tab is only visible to me. No other user including PSM Shadow users are able to see that tab. &lt;/P&gt;&lt;P&gt;Has anyone faced this issue before?&lt;/P&gt;</description>
      <pubDate>Thu, 12 Mar 2020 11:04:52 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345835#M39046</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-03-12T11:04:52Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345836#M39047</link>
      <description>&lt;P&gt;Could you check the file access permission of jtdc.jar?&lt;/P&gt;</description>
      <pubDate>Thu, 12 Mar 2020 12:27:52 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345836#M39047</guid>
      <dc:creator>Cloud</dc:creator>
      <dc:date>2020-03-12T12:27:52Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345837#M39048</link>
      <description>&lt;P&gt;Permissions are okay. Its not just the PSM Shadow Users , but other users who have same privileges as mine, are not able to see the Sybase tab, unless they add the jtdc.jar file in their session which is very strange to me.&lt;/P&gt;</description>
      <pubDate>Thu, 12 Mar 2020 12:59:11 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345837#M39048</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-03-12T12:59:11Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345838#M39049</link>
      <description>&lt;P&gt;Ok, it turned out that if you're doing any changes in the configuration in SQL developer, it will save it for that particular user only in the&lt;/P&gt;&lt;P&gt; C:\Users\&amp;lt;userid&amp;gt;\AppData\Roaming\SQL Developer   so that's why the Sybase tab was not visible to all the users.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;after identifying the above, I was able to tweak my AutoIt code, to copy the required configuration to the PSMShadowUser profile when connecting for the first time and it worked.&lt;/P&gt;</description>
      <pubDate>Fri, 27 Mar 2020 12:00:25 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345838#M39049</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-03-27T12:00:25Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345839#M39050</link>
      <description>&lt;P&gt;Hello @Ratul Gandhi​&amp;nbsp;&lt;/P&gt;&lt;P&gt;when I launch my connect for the PSM-Oracle Developer it does not populate credentials but give me this:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;"NO TNS  entries found in ….TNS_ADMIN=c:\oracle\instantclient…"&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;And I have to manually connected to the db I want&lt;/P&gt;&lt;P&gt;Is this normal or I missing something&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 29 Apr 2020 16:40:35 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345839#M39050</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-29T16:40:35Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345840#M39051</link>
      <description>&lt;P&gt;@Tesi Iloh​&amp;nbsp; In the SQL Developer tool, what "Connection Type" are you choosing?&lt;/P&gt;&lt;P&gt;This link might help you: &lt;A alt="https://stackoverflow.com/questions/47928570/where-to-find-tnsnames-ora-in-sql-developer" href="https://stackoverflow.com/questions/47928570/where-to-find-tnsnames-ora-in-sql-developer" target="_blank"&gt;https://stackoverflow.com/questions/47928570/where-to-find-tnsnames-ora-in-sql-developer&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 29 Apr 2020 17:27:20 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345840#M39051</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-29T17:27:20Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345841#M39052</link>
      <description>&lt;P&gt;Thanks for your quick responds, I use "PSM-SQLPlus" connection.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Wed, 29 Apr 2020 18:56:35 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345841#M39052</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-29T18:56:35Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345842#M39053</link>
      <description>&lt;P&gt;Sorry connection type is "Basic"&lt;/P&gt;</description>
      <pubDate>Wed, 29 Apr 2020 19:03:21 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345842#M39053</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-29T19:03:21Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345843#M39054</link>
      <description>&lt;P&gt;sorry can you please confirm - you're having issues in SQL Plus or SQL Developer?&lt;/P&gt;</description>
      <pubDate>Wed, 29 Apr 2020 19:12:21 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345843#M39054</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-29T19:12:21Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345844#M39055</link>
      <description>&lt;P&gt;PSM SQL Developer.&lt;/P&gt;&lt;P&gt;when launch connect from PVWA credential is not populating automatically&lt;/P&gt;</description>
      <pubDate>Wed, 29 Apr 2020 19:22:51 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345844#M39055</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-29T19:22:51Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345845#M39056</link>
      <description>&lt;P&gt;And this is the version am using "sqldeveloper-19.2.1.247.2212-x64" &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks.&lt;/P&gt;</description>
      <pubDate>Wed, 29 Apr 2020 19:40:12 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345845#M39056</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-29T19:40:12Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345846#M39057</link>
      <description>&lt;P&gt;I think as long as you have all the information required for the connection, it should not ask you TNS file.&lt;/P&gt;&lt;P&gt;Are you supplying all the details in the connection prompt like - username, password, hostname, Servicename or SID?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;And are you using the PSM plugin from the marketplace or have you developed on your own?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Also, when you open the SQLDeveloper from inside the PSM server do you still get the same error while connecting?&lt;/P&gt;</description>
      <pubDate>Thu, 30 Apr 2020 06:47:53 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345846#M39057</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-30T06:47:53Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345847#M39058</link>
      <description>&lt;P&gt;I use your script, modified two or three things&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;There is no PSM Developer plugin in the market place&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;When I launch sqldeveloper.exe directly from the server same issue, which is expected&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Thu, 30 Apr 2020 13:20:57 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345847#M39058</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-30T13:20:57Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345848#M39059</link>
      <description>&lt;P&gt;I guess you should check with your Database team about the error.&lt;/P&gt;</description>
      <pubDate>Thu, 30 Apr 2020 20:42:24 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345848#M39059</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-30T20:42:24Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345849#M39060</link>
      <description>&lt;P&gt;Thanks but I was curious to see what fix your own.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I see other thread here that ran into the same problem.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;</description>
      <pubDate>Thu, 30 Apr 2020 21:45:13 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345849#M39060</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-30T21:45:13Z</dc:date>
    </item>
    <item>
      <title>Re: Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345850#M39061</link>
      <description>&lt;P&gt;Here is the script that I use, which most people here use:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;#AutoIt3Wrapper_UseX64=n&lt;/P&gt;&lt;P&gt;Opt("MustDeclareVars", 1)&lt;/P&gt;&lt;P&gt;AutoItSetOption("WinTitleMatchMode", 1) ; Match prefix&lt;/P&gt;&lt;P&gt;;============================================================&lt;/P&gt;&lt;P&gt;;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;PSM AutoIt SQL Developer Dispatcher&lt;/P&gt;&lt;P&gt;;============================================================&lt;/P&gt;&lt;P&gt;#include "PSMGenericClientWrapper.au3"&lt;/P&gt;&lt;P&gt;;=======================================&lt;/P&gt;&lt;P&gt;; Consts &amp;amp; Globals&lt;/P&gt;&lt;P&gt;;=======================================&lt;/P&gt;&lt;P&gt;Global Const $DISPATCHER_NAME&amp;nbsp;&amp;nbsp;= "SQL Developer"&lt;/P&gt;&lt;P&gt;Global Const $CLIENT_EXECUTABLE&amp;nbsp;&amp;nbsp;= "D:\sqldeveloper\sqldeveloper.exe"&lt;/P&gt;&lt;P&gt;Global Const $ERROR_MESSAGE_TITLE&amp;nbsp;&amp;nbsp;= "PSM " &amp;amp; $DISPATCHER_NAME &amp;amp; " Dispatcher error message"&lt;/P&gt;&lt;P&gt;Global Const $LOG_MESSAGE_PREFIX = $DISPATCHER_NAME &amp;amp; " Dispatcher - "&lt;/P&gt;&lt;P&gt;Global $TargetUsername&lt;/P&gt;&lt;P&gt;Global $TargetPassword&lt;/P&gt;&lt;P&gt;Global $TargetAddress&lt;/P&gt;&lt;P&gt;Global $TargetPort&lt;/P&gt;&lt;P&gt;Global $TargetDatabase&lt;/P&gt;&lt;P&gt;Global $ConnectionClientPID = 0&lt;/P&gt;&lt;P&gt;;=======================================&lt;/P&gt;&lt;P&gt;; Code&lt;/P&gt;&lt;P&gt;;=======================================&lt;/P&gt;&lt;P&gt;Exit Main()&lt;/P&gt;&lt;P&gt;;=======================================&lt;/P&gt;&lt;P&gt;; Main&lt;/P&gt;&lt;P&gt;;=======================================&lt;/P&gt;&lt;P&gt;Func Main()&lt;/P&gt;&lt;P&gt;; Init PSM Dispatcher utils wrapper&lt;/P&gt;&lt;P&gt;ToolTip ("Initializing...")&lt;/P&gt;&lt;P&gt;LogWrite("successfully initialized tooltip")&lt;/P&gt;&lt;P&gt;if (PSMGenericClient_Init() &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then&lt;/P&gt;&lt;P&gt;Error(PSMGenericClient_PSMGetLastErrorString())&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;LogWrite("successfully initialized Dispatcher Utils Wrapper")&lt;/P&gt;&lt;P&gt;; Get the dispatcher parameters&lt;/P&gt;&lt;P&gt;FetchSessionProperties()&lt;/P&gt;&lt;P&gt;LogWrite("mapping local drives")&lt;/P&gt;&lt;P&gt;if (PSMGenericClient_MapTSDrives() &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then&lt;/P&gt;&lt;P&gt;Error(PSMGenericClient_PSMGetLastErrorString())&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;LogWrite("starting client application")&lt;/P&gt;&lt;P&gt;ToolTip ("Starting " &amp;amp; $DISPATCHER_NAME &amp;amp; "...")&lt;/P&gt;&lt;P&gt;$ConnectionClientPID = Run($CLIENT_EXECUTABLE)&lt;/P&gt;&lt;P&gt;if ($ConnectionClientPID == 0) Then&lt;/P&gt;&lt;P&gt;Error(StringFormat("Failed to execute process [%s]", $CLIENT_EXECUTABLE, @error))&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;; Send PID to PSM as early as possible so recording/monitoring can begin&lt;/P&gt;&lt;P&gt;LogWrite("sending PID to PSM")&lt;/P&gt;&lt;P&gt;if (PSMGenericClient_SendPID($ConnectionClientPID) &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then&lt;/P&gt;&lt;P&gt;Error(PSMGenericClient_PSMGetLastErrorString())&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;; ------------------&lt;/P&gt;&lt;P&gt;;Block all input for the remainder of the SQL Developer application interaction&lt;/P&gt;&lt;P&gt;&amp;nbsp;LogWrite("Starting Customized Plugin Code...")&lt;/P&gt;&lt;P&gt;Local $hWnd&lt;/P&gt;&lt;P&gt;$hWnd = WinWaitActive("[REGEXPTITLE:(Oracle SQL Developer.*|Confirm Import Preferences|Oracle Usage Tracking)]", "", 10)&lt;/P&gt;&lt;P&gt;&amp;nbsp;; Check if the "Confirm Import Preferences" dialog is displayed&lt;/P&gt;&lt;P&gt;&amp;nbsp;If (WinGetTitle($hWnd) == "Confirm Import Preferences") Then&lt;/P&gt;&lt;P&gt;&amp;nbsp;; Get rid of it&lt;/P&gt;&lt;P&gt;&amp;nbsp;Send("!n")&lt;/P&gt;&lt;P&gt;&amp;nbsp;; Wait for the main window again&lt;/P&gt;&lt;P&gt;&amp;nbsp;$hWnd = WinWaitActive("[REGEXPTITLE:(Oracle SQL Developer.*|Oracle Usage Tracking)]", "", 10)&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;&amp;nbsp;; The "Oracle Usage Tracking" dialog may appear after the main window becomes active - we need to wait a bit and check again.&lt;/P&gt;&lt;P&gt;&amp;nbsp;Sleep(400)&lt;/P&gt;&lt;P&gt;$hWnd = WinWaitActive("[REGEXPTITLE:(Oracle SQL Developer.*|Oracle Usage Tracking)]", "", 10)&lt;/P&gt;&lt;P&gt;&amp;nbsp;; Check if the "Oracle Usage Tracking" dialog is displayed&lt;/P&gt;&lt;P&gt;If (WinGetTitle($hWnd) == "Oracle Usage Tracking") Then&lt;/P&gt;&lt;P&gt;; Get rid of it&lt;/P&gt;&lt;P&gt;Send("{SPACE}")&lt;/P&gt;&lt;P&gt;Sleep(400)&lt;/P&gt;&lt;P&gt;Send("{ENTER}")&lt;/P&gt;&lt;P&gt;; Wait for the main window again&lt;/P&gt;&lt;P&gt;$hWnd = WinWaitActive("Oracle SQL Developer", "", 10)&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;;if ($hWnd == 0) Then&lt;/P&gt;&lt;P&gt;;Error("SQL Developer initialization timed out")&lt;/P&gt;&lt;P&gt;;EndIf&lt;/P&gt;&lt;P&gt;;Sleep(1000)&lt;/P&gt;&lt;P&gt;;Send("!w")&lt;/P&gt;&lt;P&gt;;Send("!f")&lt;/P&gt;&lt;P&gt;;Send("{ENTER}")&lt;/P&gt;&lt;P&gt;;Sleep(3000)&lt;/P&gt;&lt;P&gt;;$hWnd = WinWaitActive("Oracle SQL Developer", "", 10)&lt;/P&gt;&lt;P&gt;;if ($hWnd == 0) Then&lt;/P&gt;&lt;P&gt;;Error("SQL Developer initialization timed out")&lt;/P&gt;&lt;P&gt;;EndIf&lt;/P&gt;&lt;P&gt;Send("{ENTER}")&lt;/P&gt;&lt;P&gt;WinWaitActive("Oracle SQL Developer : Start Page")&lt;/P&gt;&lt;P&gt;WinSetState("Oracle SQL Developer", "", @SW_MAXIMIZE)&lt;/P&gt;&lt;P&gt;Send("{ENTER}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;MouseClick("left", 15, 117)&lt;/P&gt;&lt;P&gt;$hWnd = WinWaitActive("New / Select Database Connection", "", 5) ; Should not take more than a second to appear&lt;/P&gt;&lt;P&gt;if ($hWnd == 0) Then&lt;/P&gt;&lt;P&gt;Error("Failed to click on connection button")&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;Send("PSM UC [" &amp;amp; $TargetUsername &amp;amp; "@" &amp;amp; $TargetAddress &amp;amp; "]")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send($TargetUsername)&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(1000)&lt;/P&gt;&lt;P&gt;Send($TargetPassword, 1)&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send($TargetAddress)&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send($TargetPort)&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{SPACE}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send("{TAB}")&lt;/P&gt;&lt;P&gt;Sleep(100)&lt;/P&gt;&lt;P&gt;Send($TargetDatabase)&lt;/P&gt;&lt;P&gt;Send("!o")&lt;/P&gt;&lt;P&gt;;-- if we get the overwrite dialog, send 'Yes'&lt;/P&gt;&lt;P&gt;Sleep(500)&lt;/P&gt;&lt;P&gt;If WinActive("Connection Name in use") Then&lt;/P&gt;&lt;P&gt;Send("!y")&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;; ------------------&lt;/P&gt;&lt;P&gt;; Terminate PSM Dispatcher utils wrapper&lt;/P&gt;&lt;P&gt;LogWrite("Terminating Dispatcher Utils Wrapper")&lt;/P&gt;&lt;P&gt;PSMGenericClient_Term()&lt;/P&gt;&lt;P&gt;Return $PSM_ERROR_SUCCESS&lt;/P&gt;&lt;P&gt;EndFunc&lt;/P&gt;&lt;P&gt;;==================================&lt;/P&gt;&lt;P&gt;; Functions&lt;/P&gt;&lt;P&gt;;==================================&lt;/P&gt;&lt;P&gt;; #FUNCTION# =============================================================================&lt;/P&gt;&lt;P&gt;Func Error($ErrorMessage, $Code = -1)&lt;/P&gt;&lt;P&gt;; If the dispatcher utils DLL was already initialized, write an error log message and terminate the wrapper&lt;/P&gt;&lt;P&gt;if (PSMGenericClient_IsInitialized()) Then&lt;/P&gt;&lt;P&gt;LogWrite($ErrorMessage, True)&lt;/P&gt;&lt;P&gt;PSMGenericClient_Term()&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;Local $MessageFlags = BitOr(0, 16, 262144) ; 0=OK button, 16=Stop-sign icon, 262144=MsgBox has top-most attribute set&lt;/P&gt;&lt;P&gt;MsgBox($MessageFlags, $ERROR_MESSAGE_TITLE, $ErrorMessage)&lt;/P&gt;&lt;P&gt;; If the connection component was already invoked, terminate it&lt;/P&gt;&lt;P&gt;if ($ConnectionClientPID &amp;lt;&amp;gt; 0) Then&lt;/P&gt;&lt;P&gt;ProcessClose($ConnectionClientPID)&lt;/P&gt;&lt;P&gt;$ConnectionClientPID = 0&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;Exit $Code&lt;/P&gt;&lt;P&gt;EndFunc&lt;/P&gt;&lt;P&gt;; #FUNCTION# ====================================================================================================================&lt;/P&gt;&lt;P&gt;; Name...........: LogWrite&lt;/P&gt;&lt;P&gt;; Description ...: Write a PSMWinSCPDispatcher log message to standard PSM log file&lt;/P&gt;&lt;P&gt;; Parameters ....: $sMessage - [IN] The message to write&lt;/P&gt;&lt;P&gt;;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;$LogLevel - [Optional] [IN] Defined if the message should be handled as an error message or as a trace messge&lt;/P&gt;&lt;P&gt;; Return values .: $PSM_ERROR_SUCCESS - Success, otherwise error - Use PSMGenericClient_PSMGetLastErrorString for details.&lt;/P&gt;&lt;P&gt;; ===============================================================================================================================&lt;/P&gt;&lt;P&gt;Func LogWrite($sMessage, $LogLevel = $LOG_LEVEL_TRACE)&lt;/P&gt;&lt;P&gt;Return PSMGenericClient_LogWrite($LOG_MESSAGE_PREFIX &amp;amp; $sMessage, $LogLevel)&lt;/P&gt;&lt;P&gt;EndFunc&lt;/P&gt;&lt;P&gt;; #FUNCTION# =============================================================================&lt;/P&gt;&lt;P&gt;; Name...........: PSMGenericClient_GetSessionProperty&lt;/P&gt;&lt;P&gt;; Description ...: Fetches properties required for the session&lt;/P&gt;&lt;P&gt;;================&lt;/P&gt;&lt;P&gt;Func FetchSessionProperties()&lt;/P&gt;&lt;P&gt;if (PSMGenericClient_GetSessionProperty("Username", $TargetUsername) &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then&lt;/P&gt;&lt;P&gt;Error(PSMGenericClient_PSMGetLastErrorString())&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;if (PSMGenericClient_GetSessionProperty("Password", $TargetPassword) &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then&lt;/P&gt;&lt;P&gt;Error(PSMGenericClient_PSMGetLastErrorString())&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;if (PSMGenericClient_GetSessionProperty("Address", $TargetAddress) &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then&lt;/P&gt;&lt;P&gt;Error(PSMGenericClient_PSMGetLastErrorString())&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;if (PSMGenericClient_GetSessionProperty("Port", $TargetPort) &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then&lt;/P&gt;&lt;P&gt;$TargetPort =&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;if (PSMGenericClient_GetSessionProperty("Database", $TargetDatabase) &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then&lt;/P&gt;&lt;P&gt;Error(PSMGenericClient_PSMGetLastErrorString())&lt;/P&gt;&lt;P&gt;EndIf&lt;/P&gt;&lt;P&gt;EndFunc&lt;/P&gt;&lt;P&gt;;Func _Quit()&lt;/P&gt;&lt;P&gt;;MsgBox("","Quitting","Something's wrong")&lt;/P&gt;&lt;P&gt;; Exit&lt;/P&gt;&lt;P&gt;;EndFunc&lt;/P&gt;</description>
      <pubDate>Thu, 30 Apr 2020 21:48:41 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/enabling-sql-developer-with-sybase-jar-jtdc-jar-for-psm/m-p/1345850#M39061</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-04-30T21:48:41Z</dc:date>
    </item>
  </channel>
</rss>

