SSL and SSH Support for Direct Oracle Connections in Excel Add-ins 2.5

July 23rd, 2020

Devart is glad to announce the release of Excel Add-ins 2.5 with support for secure SSL and SSH connections to Oracle in the Direct mode. Now you can connect both to on-premises Oracle and Oracle Database Cloud — a Database as a Service (DBaaS) solution from Oracle — via secure SSL/TLS and SSH protocols in the Direct connection mode.

The SSL protocol can be enabled by adding the “tcps://” prefix to the Host connection parameter. You can either specify the necessary SSL certificate in the Advanced connection parameters as a base64 encoded string or store it in Oracle Wallet and specify the wallet location.

For the SSH protocol, Excel Add-in for Oracle supports public key and password SSH authentication. You can specify authentication type, SSH user name and password or a private key and passphrase, acceptable ciphers, SSH host and port, etc. in the Advanced parameters when setting up a connection to Oracle. To enable SSH for a connection, you need to add the “ssh://” prefix to the Host (or Server) connection string parameter.

You are welcome to download the updated version of our Excel Add-ins and send feedback.

Comments are closed.

Your subscription could not be saved. Please try again.
Confirm your email by clicking the link in your inbox!

Subscribe to our blog

to get the latest posts delivered to your inbox