<?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: Any suggestions for the integration of SQL Developer by PMS .? in PAM Self-Hosted Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/any-suggestions-for-the-integration-of-sql-developer-by-pms/m-p/1371169#M57861</link>
    <description>&lt;P&gt;Hi @Nirmalkumar Dhanaraj​,&amp;nbsp;I try and share my findings &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
    <pubDate>Tue, 04 Jun 2019 17:49:36 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2019-06-04T17:49:36Z</dc:date>
    <item>
      <title>Any suggestions for the integration of SQL Developer by PMS .?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/any-suggestions-for-the-integration-of-sql-developer-by-pms/m-p/1371167#M57859</link>
      <description>&lt;P&gt;I have read and researched that there are some problems in the integration of SQL Developer, and the solution provided by CyberArk is to use Toad, but are there any notes or documentation of this SQL Developer problem?&lt;/P&gt;</description>
      <pubDate>Thu, 30 May 2019 15:05:42 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/any-suggestions-for-the-integration-of-sql-developer-by-pms/m-p/1371167#M57859</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-05-30T15:05:42Z</dc:date>
    </item>
    <item>
      <title>Re: Any suggestions for the integration of SQL Developer by PMS .?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/any-suggestions-for-the-integration-of-sql-developer-by-pms/m-p/1371168#M57860</link>
      <description>&lt;P&gt;Hi @Luis Aguirre​&amp;nbsp;if you try the below AUTOIT based connector, you will come to know the issues. if you are able to fix, please share your findings.. Good Luck!&lt;/P&gt;&lt;CODE&gt;#AutoIt3Wrapper_UseX64=n
Opt("MustDeclareVars", 1)
AutoItSetOption("WinTitleMatchMode", 1) ; Start of title is matched
&amp;nbsp;
&amp;nbsp;
;============================================================
;             PSM AutoIt Dispatcher Skeleton
;             ------------------------------
;
; Use this skeleton to create your own
; connection components integrated with the PSM.
; Areas you may want to modify are marked
; with the string "CHANGE_ME".
;
; Created : July  2015
; Cyber-Ark Software Ltd.
;============================================================
#include "PSMGenericClientWrapper.au3"
;=======================================
; Consts &amp;amp; Globals
;=======================================
&amp;nbsp;
Global $Username
Global $Password
Global $Address
&amp;nbsp;
Global $ConnectionClientPID = 0
&amp;nbsp;
Global Const $DISPATCHER_NAME									= "TEST"
Global Const $ERROR_MESSAGE_TITLE  								= "PSM " &amp;amp; $DISPATCHER_NAME &amp;amp; " Dispatcher error message"
Global Const $LOG_MESSAGE_PREFIX 								= $DISPATCHER_NAME &amp;amp; " Dispatcher - "
&amp;nbsp;
&amp;nbsp;
&amp;nbsp;
;=======================================
; Code
;=======================================
Exit Main()
&amp;nbsp;
;=======================================
; Main
;=======================================
Func Main()
&amp;nbsp;
	; Init PSM Dispatcher utils wrapper
	ToolTip ("Initializing...")
&amp;nbsp;
	if (PSMGenericClient_Init() &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then
		Error(PSMGenericClient_PSMGetLastErrorString())
	EndIf
&amp;nbsp;
	LogWrite("successfully initialized Dispatcher Utils Wrapper")
&amp;nbsp;
	; Get the dispatcher parameters
	FetchSessionProperties()
&amp;nbsp;
	LogWrite("mapping local drives")
	if (PSMGenericClient_MapTSDrives() &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then
		Error(PSMGenericClient_PSMGetLastErrorString())
	EndIf
&amp;nbsp;
	LogWrite("starting client application")
	ToolTip ("Starting " &amp;amp; $DISPATCHER_NAME &amp;amp; "...")
&amp;nbsp;
	Local $ProgramFilesDir = EnvGet('ProgramFiles(x86)') ; for 64bit Win it will return a valid path.
&amp;nbsp;
   ;If not $ProgramFilesDir Then $ProgramFilaesDir = @ProgramFilesDir ; for 32bit Win this will "repair" the broken return from above.
	  If not $ProgramFilesDir Then $ProgramFilesDir = @ProgramFilesDir ; for 32bit Win this will "repair" the broken return from above.
&amp;nbsp;
    Local $URL = $ProgramFilesDir &amp;amp;"\Google\Chrome\Application\chrome.exe --start-fullscreen --app=http://" &amp;amp; $Address;
    $ConnectionClientPID = Run($URL);
	;BlockInput(1)
&amp;nbsp;
	if ($ConnectionClientPID == 0) Then
		Error(StringFormat("Failed to execute process [%s]", "Chrome" , @error))
	EndIf
&amp;nbsp;
	; Send PID to PSM as early as possible so recording/monitoring can begin
	LogWrite("sending PID to PSM")
	if (PSMGenericClient_SendPID($ConnectionClientPID) &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then
		Error(PSMGenericClient_PSMGetLastErrorString())
	EndIf
&amp;nbsp;
	; ------------------
	; Handle login here!
	; ------------------
&amp;nbsp;
	sleep(2000)
	SiteLogIn()
&amp;nbsp;
	; Terminate PSM Dispatcher utils wrapper
	LogWrite("Terminating Dispatcher Utils Wrapper")
	PSMGenericClient_Term()
&amp;nbsp;
	Return $PSM_ERROR_SUCCESS
EndFunc
&amp;nbsp;
Func SiteLogIn()
&amp;nbsp;
   sleep(1000)
	  WinActivate("Login | Splunk - Google Chrome")
	  ;send($TargetUsername)
	  ClipPut(" ")
	   sleep(2000)
	   ClipPut($Username)
	  sleep(200)
	  Send("^v")
	  sleep(200)
	  ClipPut(" ")
	  sleep(50)
	  send("{TAB}")
	  ;send($TargetPassword)
	  sleep(250)
	  ClipPut($Password)
	  sleep(250)
	  Send("^v")
	  ClipPut(" ")
	  sleep(100)
	  send("{ENTER}")
&amp;nbsp;
&amp;nbsp;
	; BlockInput(0)
&amp;nbsp;
&amp;nbsp;
EndFunc
&amp;nbsp;
&amp;nbsp;
; #FUNCTION# ====================================================================================================================
; Name...........: Error
; Description ...: An exception handler - displays an error message and terminates the dispatcher
; Parameters ....: $ErrorMessage - Error message to display
; 				   $Code 		 - [Optional] Exit error code
; ===============================================================================================================================
&amp;nbsp;
Func Error($ErrorMessage, $Code = -1)
&amp;nbsp;
	; If the dispatcher utils DLL was already initialized, write an error log message and terminate the wrapper
	if (PSMGenericClient_IsInitialized()) Then
		LogWrite($ErrorMessage, True)
		PSMGenericClient_Term()
	EndIf
&amp;nbsp;
	Local $MessageFlags = BitOr(0, 16, 262144) ; 0=OK button, 16=Stop-sign icon, 262144=MsgBox has top-most attribute set
&amp;nbsp;
	MsgBox($MessageFlags, $ERROR_MESSAGE_TITLE, $ErrorMessage)
&amp;nbsp;
	; If the connection component was already invoked, terminate it
	if ($ConnectionClientPID &amp;lt;&amp;gt; 0) Then
		ProcessClose($ConnectionClientPID)
		$ConnectionClientPID = 0
	EndIf
&amp;nbsp;
	Exit $Code
EndFunc
&amp;nbsp;
; #FUNCTION# ====================================================================================================================
; Name...........: LogWrite
; Description ...: Write a PSMWinSCPDispatcher log message to standard PSM log file
; Parameters ....: $sMessage - [IN] The message to write
;                  $LogLevel - [Optional] [IN] Defined if the message should be handled as an error message or as a trace messge
; Return values .: $PSM_ERROR_SUCCESS - Success, otherwise error - Use PSMGenericClient_PSMGetLastErrorString for details.
; ===============================================================================================================================
Func LogWrite($sMessage, $LogLevel = $LOG_LEVEL_TRACE)
	Return PSMGenericClient_LogWrite($LOG_MESSAGE_PREFIX &amp;amp; $sMessage, $LogLevel)
EndFunc
&amp;nbsp;
; #FUNCTION# ====================================================================================================================
; Name...........: PSMGenericClient_GetSessionProperty
; Description ...: Fetches properties required for the session
; Parameters ....: None
; Return values .: None
; ===============================================================================================================================
Func FetchSessionProperties() ; CHANGE_ME
&amp;nbsp;
	if (PSMGenericClient_GetSessionProperty("UserName", $Username) &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then
		Error("UserName paramter is missing")
	EndIf
&amp;nbsp;
	if (PSMGenericClient_GetSessionProperty("Password", $Password) &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then
		Error("Password paramter is missing")
     EndIf
&amp;nbsp;
      if (PSMGenericClient_GetSessionProperty("Address", $Address) &amp;lt;&amp;gt; $PSM_ERROR_SUCCESS) Then
		Error("Address paramter is missing")
	EndIf
&amp;nbsp;
EndFunc
&amp;nbsp;&lt;/CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 30 May 2019 21:30:32 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/any-suggestions-for-the-integration-of-sql-developer-by-pms/m-p/1371168#M57860</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-05-30T21:30:32Z</dc:date>
    </item>
    <item>
      <title>Re: Any suggestions for the integration of SQL Developer by PMS .?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/any-suggestions-for-the-integration-of-sql-developer-by-pms/m-p/1371169#M57861</link>
      <description>&lt;P&gt;Hi @Nirmalkumar Dhanaraj​,&amp;nbsp;I try and share my findings &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Tue, 04 Jun 2019 17:49:36 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/any-suggestions-for-the-integration-of-sql-developer-by-pms/m-p/1371169#M57861</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-06-04T17:49:36Z</dc:date>
    </item>
  </channel>
</rss>

