Can sqlcl connect using sql developer exported connections

user603831

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.

User_2DKLA

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

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

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

    },