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

1. Domain
2. Username
3. 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

What SQL Developer application are you working with that the launcher will be created for? example PL/SQL Developer

Will you have to SSH into a server then execute the SQL commands?

Hi!

I have an identical issue when configuring the PL SQL Developer as a custom launcher on Delinea. 

May I know if you successfully built the launcher? 

Thanks for your answers. 

Hi,

I have the same issue when configuring the PL SQL Developer as a custom launcher on Delinea. 

May I know if you successfully built the launcher? How did you do it?

Thanks for your answers. 

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.