Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Credentials are stored in a secure database table. 
  • Calls through the SSH tunnel happen with each API request to the platform. When the call has been satisfied, the connection is closed. 
    • For asynchronous calls to the database, the connection is not left open during the asynchronous execution of the request.

Limitations

...

  • This feature

...

D s support

...

  • This feature is not available for some connections.  

  • SSH   key-pair   must be generated in the legacy OpenSSH format. The new OpenSSH format is not supported. Instructions for generating the legacy format are provided below.
Info

NOTE: For security reasons, the port number in use for SSH tunneling is randomized when the connection is brokered. Connections where the port number is specified in the Connect String Options may need to be modified to use SSH tunneling. For more information, see "Host and port information in Connect String Options" below.


Info

NOTE: This feature does not work, if In-VPC connectivity to the data service has been enabled in your project. For more information, see Run Dataprep in Your VPC.


Prerequisites

  • You must have credentials to access the SSH tunneling for each connection type. 
  • On each database server to which you using SSH tunneling to connect:
    • You must whitelist the SSH host, so that the database server will receive connections from it. 
    • For additional security, you can limit access on the SSH host to only the IP address range for
      D s item
      itemService
      , which prevents access to the database server through the SSH host for any system other than 
      D s product
      .
    • For more information, see Whitelist Platform Service.

Configure

...

Supported Connection Types

The following connection types support SSH Tunneling:

Connection Type

Credential Types

Documentation

D s conntype
typecloud_sqlserver

SSH Basic,SSH Key

Microsoft SQL Server Connections

D s conntype
typemongodb

SSH Basic,SSH Key

MongoDB Connections

D s conntype
typemysql

SSH Basic,SSH Key

MySQL Connections

D s conntype
typeoracle
SSH Basic,SSH KeyOracle Database Connections
D s conntype
typepostgres

SSH Basic,SSH Key

PostgreSQL Connections

D s conntype
typesqlserver

SSH Basic,SSH Key

Microsoft SQL Server Connections

D s conntype
typeteradata

SSH Basic,SSH Key

Teradata Connections

Configure

You can enable the SSH tunneling check box and configure the advanced options

Info

NOTE: SSH tunneling is enabled on a per-connection basis. If enabled for a connection type, the SSH options appear under the Advanced options in the connection window.

...

For more information, see Create Connection Window.

Basic Properties

PropertyDescription
SSH tunneling host

If you are using SSH tunneling, please specify the SSH host for tunneling into your infrastructure.

Advanced Credential TypeDepending on the type, you must specify the properties for the credentials to use to connection. See sections below.

SSH Tunneling Basic

PropertyDescription
SSH Tunneling User Name

(optional) Username with which to authenticate to the SSH tunnel.

In some environments, a username may be optional.

SSH Tunneling PasswordPassword for the username

SSH Tunneling with Key

Info

NOTE: Use of an SSH key that requires a passphrase is not supported.


PropertyDescription
SSH Tunneling User Name

(optional) Username with which to authenticate to the SSH tunnel.

In some environments, a username may be optional.

SSH Tunneling SSH Key

Key used to access the SSH tunnel.

Info

NOTE: This key must be generated in legacy OpenSSH format. See below.


Generate SSH key

Please use the following command to generate an SSH key from the node where the database server node:

Code Block
ssh-keygen -t rsa -m PEM

Host and port information in Connect String Options

For security reasons, port and host information may be randomized as part of brokering the connection. If your Connect String Options for a specific connection reference port and host numbers, you must replace them with the following dynamic references:

Info

NOTE: Use of these references in the Connect String Options for an SSH-enabled connection is required.


ItemReference
hostname${host}
port number${port}

 Example:

Code Block
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ${host})(PORT = ${port})))(CONNECT_DATA = (SERVICE_NAME = ORCL)))

Use

When you have configured SSH tunneling properly, all users of the connection use the SSH configuration to access the targeted database.

...

When a connection is shared with credentials, the SSH authentication credentials are also shared. For more information, see Share a Connection.

D s also
labelssh