Through the Create Connection window, you can create and edit connections between  and remote storage.


This window is available from the following locations:

NOTE: In your environment, creation of connections may be limited to administrators only. For more information, please contact your .


Tip: Administrators can edit any public connection.

General Connection Notes:

Database Connection Notes:

Connection Type

 

Connection Type window

In the Connection Type window, you search or browse for the type of connection to create.

Actions:

Tip: Early Preview connection types provide read-only access to the designated datastore. These limited-support connection types provide early access so that you can get started using your data. For more information, see Early Preview Connection Types.

Tip: Click I'm interested to upvote adding the connection type to the . Help chart the future direction of connectivity!

For more information on these connections, See Connection Types.

Create Connection

Create Connection Window
PropertyDescription
HostHost of the database.
Port

Port by which to access the database host.

Default values are pre-populated based on the connection type you selected.

Connect String Options

(optional) If access to the database requires special connection string options, you may paste or enter them here.

You only need to provide the parameter and string value. Example:

";transportMode=http;httpPath=cliservice"
Enable SSL

To connect using SSL, click this checkbox.

If this checkbox is not present, SSL connections for this database type are not supported or are required:

No additional Connect String Options are required for supported database vendors.

NOTE: The database must be configured to receive SSL connections.

Service Name(Oracle only) Name of the service. For example, enter orcl here.
Database(PostgreSQL only) Name of the database to connect. The name of the default database is the username, so you should change this value in most cases.
Credential Type

Depending on the type of datastore to which you are connecting, you may have multiple methods of providing credentials for authentication:

  • Basic - Username and password credentials are provided as part of the connection definition.

  • OAuth 2.0 - Connection accesses the datastore using OAuth 2.0 authentication.

NOTE: OAuth 2.0 authentication requires additional configuration. For more information, see Enable OAuth 2.0 Authentication.

NOTE: For each type of connection that uses OAuth 2.0, you must create a client app and a client in the . See Create OAuth2 Client.

NOTE: When you create the connection in this window for an OAuth 2.0 connection, you must click Authenticate, which uses the OAuth 2.0 client to connect to the app. This step is required.

User Name

(basic credential type) Username to access the database. This value is encrypted for security.

Password
(basic credential type) Password for the specified user. This value is encrypted for security.
OAuth 2.0 Client

(OAuth 2.0 credential type) Select the OAuth 2.0 client to use to connect to the datastore.

NOTE: You must create a separate connection for each OAuth 2.0 client that is available in the drop-down list.

Test Connection

When the above properties are specified, click Test Connection to validate that can connect to the database.

Advanced Options: Default Column Data Type Inference

You can choose to enable or disable type inferencing for individual connections, when the connection is created or edited.

Advanced Options: SSH tunneling

If available, the SSH tunneling options allow you to configure SSH tunneling authentication between the and your database.

NOTE: SSH tunneling is available on a per-connection basis. It may not be available for all connections.

For more information, see Configure SSH Tunnel Connectivity.


Connection Name

Display name of the connection, which appears in the application.

NOTE: This value must be unique among all connections.

Connection DescriptionUser-friendly description for the connection, which appears in the application.

When you've finished, click Ok to save the connection.

After you have created your connection, run a simple job on data sourced from it. 

NOTE: You can make the connection available to all users by sharing it. See Connections Page.