Through the Create Connection window, you can create and edit connections between |
This window is available from the following locations:
From the Connections page: All available connections are displayed.
NOTE: Some connection types may not be available for your environment. |
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:
Jobs created for datasets sourced from a database cannot be executed on a Spark-based running environment.
Connection Type window |
In the Connection Type window, you search or browse for the type of connection to create.
Actions:
Import only
- Connection can be used only to import data into the platform.Publish only
- Connection can be used only to publish data from the platform to the connection target.
Import and publish
- Connection can be used to import data and to publish your outputs.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 |
For more information on these connections, See Connection Types.
Create Connection Window |
Property | Description | |||
---|---|---|---|---|
Host | Host 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:
| |||
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.
| |||
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:
| |||
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.
| |||
Test Connection | When the above properties are specified, click Test Connection to validate that | |||
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. | |||
Connection Name | Display name of the connection, which appears in the application.
| |||
Connection Description | User-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. |