IBM Security Verify

 View Only
  • 1.  Create a Custom Launcher for Oracle SQL Developer Application

    Posted Mon October 05, 2020 01:12 AM

    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



    #Support
    #SupportMigration
    #Verify


  • 2.  RE: Create a Custom Launcher for Oracle SQL Developer Application

    Posted Tue October 06, 2020 09:37 PM

    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?



    #Support
    #SupportMigration
    #Verify


  • 3.  RE: Create a Custom Launcher for Oracle SQL Developer Application

    Posted Fri September 29, 2023 10:08 AM

    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. 



    ------------------------------
    Luobin Xi
    ------------------------------



  • 4.  RE: Create a Custom Launcher for Oracle SQL Developer Application

    Posted Fri September 29, 2023 10:08 AM

    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. 



    ------------------------------
    Luobin Xi
    ------------------------------



  • 5.  RE: Create a Custom Launcher for Oracle SQL Developer Application

    Posted Thu October 05, 2023 03:40 AM

    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
    ------------------------------