Hey there,
I understand your dilemma, and it's a bit peculiar that Oracle SQL Developer doesn't offer a custom launcher out of the box from IBM\Thycotic. However, I've got a suggestion for you based on my experience.
To address your issue, you might consider creating a custom script or batch file that encapsulates the command you provided:
java -jar ConnectionHelperClient.jar -ORCL=system/oracle:1521:ORCL
In this script, you can prompt the user for the Database Name, Database Port, and DB SID. Then, use these inputs to construct the command dynamically before executing it. This way, you can tailor your launcher to include the additional options you need. Great explanation for those not in the know: https://andersenlab.de/services/custom-software-development
Once your script is ready, you can map it to your Oracle account in the Thycotic Secret Template Library, and it should provide the flexibility you're looking for.
I hope this solution proves helpful to you. Feel free to ask if you need more guidance or have any further questions.
------------------------------
Alex Ahsras
------------------------------
Original Message:
Sent: Sun October 04, 2020 09:12 PM
From: Community Support Admin
Subject: Create a Custom Launcher for Oracle SQL Developer Application
Dear Experts,
I need to create a custom launcher for Oracle SQL Developer application, as this is not available out of the box from IBM\Thycotic.
I have the latest version of SQL developer which supports creating a DB connection using command line interface with help of Connection Helper addon of SQL Developer.
I am successfully able to create a connection using following command
java -jar ConnectionHelperClient.jar -ORCL=system/oracle:1521:ORCL
Also I am able to launch SQL Developer application using Secret Server Web Console, for that I have created a custom launcher in Secret Server and set up environment variables on my client workstation. This is working fine.
I have downloaded a custom template for oracle account from thycotic secret template library, but when I try to attach my SQL Developer custom launcher to this template it gives me only following 3 options for mapping
- Domain
- Username
- Password
But for the above mentioned command to work, I require some other mapping options like, Database Name, Database Port and DB SID
How can I add these options on Secret Template Edit Launcher Configuration page
Kindly help me get through this
#Support
#SupportMigration
#Verify