Devart is glad to announce support of SSH connections in the Direct mode in dotConnect for Oracle 9.12 and SSIS Data Flow Components 1.14. Now you can connect both to on-premises Oracle and Oracle Database Cloud — a Database as a Service (DBaaS) solution from Oracle — via secure SSH protocol in the Direct connection mode.
Our products support public key and password SSH authentication and offer a number of connection string parameters to specify SSH user name and password or a private key and passphrase, acceptable ciphers, SSH host and port.
Note that in order to use SSH, you need to add the “ssh://” prefix to the Host (or Server) connection string parameter and specify the necessary SSH settings. In SSIS Data Flow Components, you may specify them on the Advanced tab of the connection manager editor.
You are welcome to download the updated version of our SSIS Data Flow Components and dotConnect for Oracle and send feedback.
