The Oracle SQL Developer extension for Visual Studio Code requires an advanced parameter setting for connections to work with Duo multi-factor authentication.
Configuring SQL Developer Extension for VS Code to use Duo
- When defining a connection, use a Connection Type of Basic. Provide the following:
- Username: Username for the connection
- Password: It is recommended to leave this blank. You will be prompted for the password when connecting.
- Connection Type: Basic
- Hostname: The host for the database.
- Port: 1521
- Type: Service Name
- Service Name: Database Service for the database you are connecting to.
- Connection information can be found in Oracle: Database Connection Strings
- Then click the Advanced tab and add a parameter, with the following elements:
- Name: oracle.net.authentication_services
- Value: (RADIUS)
- Select Test to test the connection.
- If the test is successful, select Save.