Any suggestions for the integration of SQL Developer by PMS .?

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

Any suggestions for the integration of SQL Developer by PMS .?

L3 Networker

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?

2 REPLIES 2

L5 Sessionator

Hi @Luis Aguirre​ 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!

#AutoIt3Wrapper_UseX64=n Opt("MustDeclareVars", 1) AutoItSetOption("WinTitleMatchMode", 1) ; Start of title is matched     ;============================================================ ; 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 & Globals ;=======================================   Global $Username Global $Password Global $Address   Global $ConnectionClientPID = 0   Global Const $DISPATCHER_NAME = "TEST" Global Const $ERROR_MESSAGE_TITLE = "PSM " & $DISPATCHER_NAME & " Dispatcher error message" Global Const $LOG_MESSAGE_PREFIX = $DISPATCHER_NAME & " Dispatcher - "       ;======================================= ; Code ;======================================= Exit Main()   ;======================================= ; Main ;======================================= Func Main()   ; Init PSM Dispatcher utils wrapper ToolTip ("Initializing...")   if (PSMGenericClient_Init() <> $PSM_ERROR_SUCCESS) Then Error(PSMGenericClient_PSMGetLastErrorString()) EndIf   LogWrite("successfully initialized Dispatcher Utils Wrapper")   ; Get the dispatcher parameters FetchSessionProperties()   LogWrite("mapping local drives") if (PSMGenericClient_MapTSDrives() <> $PSM_ERROR_SUCCESS) Then Error(PSMGenericClient_PSMGetLastErrorString()) EndIf   LogWrite("starting client application") ToolTip ("Starting " & $DISPATCHER_NAME & "...")   Local $ProgramFilesDir = EnvGet('ProgramFiles(x86)') ; for 64bit Win it will return a valid path.   ;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.   Local $URL = $ProgramFilesDir &"\Google\Chrome\Application\chrome.exe --start-fullscreen --app=http://" & $Address; $ConnectionClientPID = Run($URL); ;BlockInput(1)   if ($ConnectionClientPID == 0) Then Error(StringFormat("Failed to execute process [%s]", "Chrome" , @error)) EndIf   ; Send PID to PSM as early as possible so recording/monitoring can begin LogWrite("sending PID to PSM") if (PSMGenericClient_SendPID($ConnectionClientPID) <> $PSM_ERROR_SUCCESS) Then Error(PSMGenericClient_PSMGetLastErrorString()) EndIf   ; ------------------ ; Handle login here! ; ------------------   sleep(2000) SiteLogIn()   ; Terminate PSM Dispatcher utils wrapper LogWrite("Terminating Dispatcher Utils Wrapper") PSMGenericClient_Term()   Return $PSM_ERROR_SUCCESS EndFunc   Func SiteLogIn()   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}")     ; BlockInput(0)     EndFunc     ; #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 ; ===============================================================================================================================   Func Error($ErrorMessage, $Code = -1)   ; 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   Local $MessageFlags = BitOr(0, 16, 262144) ; 0=OK button, 16=Stop-sign icon, 262144=MsgBox has top-most attribute set   MsgBox($MessageFlags, $ERROR_MESSAGE_TITLE, $ErrorMessage)   ; If the connection component was already invoked, terminate it if ($ConnectionClientPID <> 0) Then ProcessClose($ConnectionClientPID) $ConnectionClientPID = 0 EndIf   Exit $Code EndFunc   ; #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 & $sMessage, $LogLevel) EndFunc   ; #FUNCTION# ==================================================================================================================== ; Name...........: PSMGenericClient_GetSessionProperty ; Description ...: Fetches properties required for the session ; Parameters ....: None ; Return values .: None ; =============================================================================================================================== Func FetchSessionProperties() ; CHANGE_ME   if (PSMGenericClient_GetSessionProperty("UserName", $Username) <> $PSM_ERROR_SUCCESS) Then Error("UserName paramter is missing") EndIf   if (PSMGenericClient_GetSessionProperty("Password", $Password) <> $PSM_ERROR_SUCCESS) Then Error("Password paramter is missing") EndIf   if (PSMGenericClient_GetSessionProperty("Address", $Address) <> $PSM_ERROR_SUCCESS) Then Error("Address paramter is missing") EndIf   EndFunc  

 

L3 Networker

Hi @Nirmalkumar Dhanaraj​, I try and share my findings

 

Thanks

  • 410 Views
  • 2 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!