Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Advanced connection options: SSH Tunnels / Kerberos for VS Code?

Simon_DBAFeb 19 2021

Love the extension and Oracle's commitment to VS Code.
Curious though if (independently) the following advanced connection types will be supported like they are with SQL Developer:
Connecting through an SSH tunnel (to an SSH host with port forwarding to the DB Server)?
Kerberos authentication? (Might need an Oracle client for the "strong authentication" options?)
Thoughts on these possibilities?
Thanks!

Comments

Simon_DBA

Actually, upon further testing, connections over an SSH tunnel works fine with this extension if the tunnel is created externally.
Example: ssh -f oracle@dbserver.domain -L 1521:localhost:1521 -N

Then the VS Code setting as:

    "oracledevtools.connections": [ 
        {
            "authenticationType": 2,
            "dBAPrivilege": "None",
            "userID": "SYSTEM",
            "passwordSaved": false,
            "dataSource": "localhost:1521/ORCL",
            "connectionType": 2,
            "databaseHostName": "localhost",
            "databasePortNumber": "1521",
            "databaseServiceName": "ORCL",
            "name": "SYSTEM.ORCL",
            "currentSchema": "",
            "tnsAdmin": "/Users/MyName/Oracle/network/admin"
        }
1 - 1

Post Details

Added on Feb 19 2021
1 comment
1,379 views