Through the Create Connection window, you can create and edit connections between the and remote storage.
NOTE: From the Import Data page, you can only create or edit connections to sources from which can read. Publish-only connections must be created through the Connections page, from which you can create any supported connection type.
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 Hadoop-based running environment.
NOTE: Please execute jobs from database connections on the running environment. Other running environments are not supported for these sources.
Connection Type window
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.
NOTE: Publish-only connections must be created through the Connections page. See Connections Page.
Import and publish- Connection can be used to import data and to publish your outputs.
NOTE: Some connection types may not be available. For example, you can create only one global Hive connection. If it has been created, the Hive connection card is disabled.
For more information on these connections, See Connection Types.
Create Connection Window
|Host||Host of the database.|
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. For example, if a configuration file includes the following:
You enter the following here:
For more information, see CLI for Connections.
To connect using SSL, click this checkbox.
No additional Connect String Options are required for supported database vendors.
|Service Name||(Oracle only) Name of the service. For example, enter |
|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.|
Username to access the database. This value is encrypted by the for security.
Password for the specified user. This value is encrypted by the for security.
When the above properties are specified, click Test Connection to validate that the can connect to the database.
If the connection fails, your administrator may need to install a keyfile. See Enable Relational Connections.
|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.
The default setting for this parameter is defined at the global level. For more information, see Configure Type Inference.
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. For more information, see Verify Operations.
NOTE: You can make the connection available to all users by sharing it through the Connections page. See Connections Page.