Friday, May 9, 2025
HomeProductsExcel Add-insSSL and SSH Support for Direct Oracle Connections in Excel Add-ins 2.5

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

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.

dotConnect Team
dotConnect Teamhttps://www.devart.com/dotconnect/
The dotConnect Team is a group of experienced .NET developers at Devart who specialize in building and supporting dotConnect data providers. They share practical insights, coding tips, and tutorials on .NET development and database connectivity through the Devart blog.
RELATED ARTICLES

Whitepaper

Social

Topics

Products