Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0642

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

D s product
rtrue
 and remote storage.

As needed, you can select the Import Only checkbox to display connections that support reading only from sources.

Info

NOTE: From the Import Data page, you can only create or edit connections to sources from which

D s product
can read. Publish-only connections must be created through the Connections page, from which you can create any supported connection type.

Info

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

D s item
itemadministrator
.

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
    D s product
    . Remove these imported datasets before deleting the connection.
  • Jobs created for datasets sourced from a database cannot be executed on a Spark-based running environment.

Connection Type

 

D caption
typefigure
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.

      Info

      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.
Info

NOTE: Some connection types may not be available. For a connection of this type has been created, its connection card is disabled.

For more information on these connections, See Connection Types.

Create Connection

D caption
typefigure
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:

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

To connect using SSL, click this checkbox.

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

  • SSL connections are not supported for SQL Server or Hive.

  • SSL connections are required for Redshift and SQL DW.

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

Info

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.
User Name

Username to access the database. This value is encrypted for security.

Password

Password for the specified user. This value is encrypted for security.

Test Connection

When the above properties are specified, click Test Connection to validate that the

D s platform
can connect to the database.If the connection test 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.

Connection Name

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

Info

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. For more information, see Verify Operations.

Info

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