Forum Stats

  • 3,824,917 Users
  • 2,260,439 Discussions
  • 7,896,346 Comments

Discussions

Can sqlcl connect using sql developer exported connections

user603831
user603831 Member Posts: 3 Green Ribbon

Is there a plugin or feature where the exported sql developer json file can be used as source for sqlcl to connect to the db.

Answers

  • User_2DKLA
    User_2DKLA Member Posts: 41 Red Ribbon
    edited May 31, 2022 3:32PM

    Hi,

    Is there a plugin or feature where the exported sql developer json file can be used as source for sqlcl to connect to the db.

    Never heard of.

    AFAIK, SQLcl is supposed to be a stand-alone SQL client, connecting to databases in much the same way as SQL*Plus would... So that would be a custom deviation extension.

    How would you want to use that?

    Regards,

  • user603831
    user603831 Member Posts: 3 Green Ribbon

    I have a lot of test env databases to connect to.

    Today i do that using sqldeveloper.

    I was checking to see if there is a easier way like connecting to database with saved password similar to sql developer exported connection json to be used by SQLcl and connect to same set of databases by using database connection name in the json and the private key when exporting saved passwords..

  • user603831
    user603831 Member Posts: 3 Green Ribbon
    edited May 31, 2022 10:28PM
    "connections": [
    
        {
    
          "info": {
    
            "role": "",
    
            "SavePassword": "true",
    
            "OracleConnectionType": "BASIC",
    
            "RaptorConnectionType": "Oracle",
    
            "Connection-Color-For-Editors": "-16776961",
    
            "sid": "SID",
    
            "NAV_FOLDER": "Security",
    
            "ExportPasswordMode": "Key",
    
            "customUrl": "jdbc:oracle:thin:@JDBCHOST:JDBCPORT:SID",
    
            "oraDriverType": "thin",
    
            "NoPasswordConnection": "TRUE",
    
            "password": "ENCRYPTED_PASSWORD",
    
            "hostname": "JDBCHOST",
    
            "driver": "oracle.jdbc.OracleDriver",
    
            "port": "JDBCPORT",
    
            "subtype": "oraJDBC",
    
            "OS_AUTHENTICATION": "false",
    
            "ConnName": "CONNECTION_NAME",
    
            "KERBEROS_AUTHENTICATION": "false",
    
            "user": "USER_NAME",
    
            "ExportKeyChecksum": "CHECKSUM_VALUE"
    
          },
    
          "name": "CONNECTION_NAME",
    
          "type": "jdbc"
    
        },