| D toc |
|---|
| D s ed | ||||
|---|---|---|---|---|
|
| Excerpt | ||||
|---|---|---|---|---|
Through the Create Connection window, you can create and edit connections between the
|
| D s roles |
|---|
This window is available from the following locations:
- From Import Data page: By default, the window displays connections that support import. Deselect the checkbox to display all available connection types.
- From Run Job page: When you add a new connection as part of a publishing action, the window displays connections that support publishing by default.
From the Connections page: All available connections are displayed.
Info NOTE: Some connection types may not be available for your environment.
| Info | ||||
|---|---|---|---|---|
NOTE: In your environment, creation of connections may be limited to administrators only. For more information, please contact your
|
| Tip |
|---|
Tip: Administrators can edit any public connection. |
General Connection Notes:
- After you create a connection, you cannot change its connection type. You must delete the connection and start again.
- Connections can be created, managed, shared, and deleted through the Connections page. See Connections Page.
Database Connection Notes:
- Database connections cannot be deleted if their databases host imported datasets that are in use by the
. Remove these imported datasets before deleting the connection.D s platform Jobs created for datasets sourced from a database cannot be executed on a Spark-based running environment.
Connection Type
| D caption | ||
|---|---|---|
| ||
Connection Type window |
In the Connection Type window, you search or browse for the type of connection to create.
Actions:
- Use the Search bar to perform real-time searches of connection types.
- Click one of the categories to browse for connection types that apply to the listed environment.
- Select the type of connection to continue:
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 |
|---|
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 | ||||
|---|---|---|---|---|
Tip: Click I'm interested to upvote adding the connection type to the
|
For more information on these connections, See Connection Types.
Create Connection
| D caption | ||
|---|---|---|
| ||
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 the | ||||||||||
| 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: Enable SSH Tunneling | If available, the SSH tunneling options allow you to configure SSH tunneling authentication between the
For more information, see Configure SSH Tunnel Connectivity. | ||||||||||
| 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.
| Info |
|---|
NOTE: You can make the connection available to all users by sharing it. See Connections Page. |
| D s also | ||||
|---|---|---|---|---|
|
