- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.
05-30-2019 08:05 AM
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?
05-30-2019 02:30 PM
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
06-04-2019 10:49 AM
Hi @Nirmalkumar Dhanaraj, I try and share my findings
Thanks
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!

