Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

D toc

The 

D s platform
rtrue
 supports the following types of connections. Use the links below to enable connection to each type and, where applicable, to create new connections to individual instances of the same type.

Notes:

  • HDFS and Hive connections can be configured as part of platform configuration.
  • Database connections should be configured after you have completed the platform configuration and have validated that it is working for locally uploaded files.
Info

NOTE: Before creating connections to Hive or relational datastores, you must create and deploy an encryption key file. See Create Encryption Key File.

 

Configure

Disable Creating Connections for Non-Admins

By default, all users are permitted to create connections. As needed, you can disable the ability to create connections for non-admin users.

Steps:

  1. D s config
  2. Search for the following parameter, and set it to false:

    Code Block
    "webapp.connectivity.nonAdminManagementEnabled": true,
  3. Save your changes and restart the platform.

Supported Environments

NameSupported Environment

D s product
productee

Running environment(s): Photon and Spark

Base storage layer: HDFS

Amazon

Running environment(s): Photon and Spark

Base storage layer: S3

Microsoft Azure

Running environment(s): Photon and Spark

Base storage layer: ADLS or WASB

For more information, see Running Environment Options.

For more information, see Set Base Storage Layer.

Default Connections

These connections are automatically enabled and configured with the product.

Upload

Enable: Automatically enabled.

Create New Connection: n/a

Big Data

These connections pertain to the various big data platforms that are supported by the

D s platform
.

Apache Hadoop HDFS - Cloudera

Enable: Configure for Hadoop.

Create New Connection: n/a

Hive - Cloudera

Enable: Configure for Hive

Info

NOTE: Additional configuration is required.

Create New Connection: Create Hive Connections

Info

NOTE: A single public Hive connection is supported.

Apache Hadoop HDFS - Hortonworks

Enable: Configure for Hadoop.

Create New Connection: n/a

Hive - Hortonworks

Enable: Configure for Hive

Info

NOTE: Additional configuration is required.

Create New Connection: Create Hive Connections

Info

NOTE: A single public Hive connection is supported.

Cloud Platforms

These connections pertain to cloud platforms with which the

D s platform
can integrate.

Amazon S3

Supported Versions: n/a

Supported Environments:

Operation

D s product
productee

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported
WriteNot supportedSupportedNot supported

Enable: Enable S3 Access

Create New Connection: n/a

Info

NOTE: A single public connection to S3 is supported.

Amazon Redshift

Supported Versions: n/a

Supported Environments:

Info

NOTE: S3 must be set as the base storage layer. See Set Base Storage Layer.

Operation

D s product
productee

AmazonMicrosoft Azure
ReadNot supportedSupportedNot supported
WriteNot supportedSupportedNot supported

Enable: Create Redshift Connections

Create New Connection: 

Microsoft Azure WASB

Supported Versions: n/a

Supported Environments:

Operation

D s product
productee

AmazonMicrosoft Azure
ReadNot supportedNot supportedSupported
WriteNot supportedNot supportedSupported (only if WASB is base storage layer)

Enable: Enable WASB Access

Create New Connection: n/a

Info

NOTE: A single public connection to WASB is supported.

Microsoft Azure ADLS

Supported Versions: n/a

Supported Environments:

Operation

D s product
productee

AmazonMicrosoft Azure
ReadNot supportedNot supportedSupported
WriteNot supportedNot supportedSupported (only if ADLS is base storage layer)

Enable: Enable ADLS Access.

Create New Connection: n/a

Info

NOTE: A single public connection to ADLS is supported.

Relational DB

These connections pertain to relational database sources.

Oracle

Supported Versions: 12.1.0.2

Supported Environments:

Operation

D s product
productee

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported
WriteNot supportedNot supportedNot supported

Enable: Enable Relational Connections

Create New Connection: 

PostgreSQL

Supported Versions: 9.3.10

Supported Environments:

Operation

D s product
productee

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported
WriteNot supportedNot supportedNot supported

Enable: Enable Relational Connections

Create New Connection:

SQL Server

Supported Versions: 12.0.4

Supported Environments:

Operation

D s product
productee

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteNot supportedNot supportedNot supported


Enable:
 Enable Relational Connections

Create New Connection:

Teradata

Supported Versions: 14.10+

Supported Environments:

Operation

D s product
productee

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported
WriteNot supportedNot supportedNot supported

Enable: 

Create New Connection:

SQL DW

Supported Versions: n/a

Supported Environments:

Operation

D s product
productee

AmazonMicrosoft Azure
ReadNot supportedNot supportedSupported
WriteNot supportedNot supportedNot supported

Enable: Create SQL DW Connections

Create New Connection: 

SQL DB

Info

NOTE: This database connection is a specialized version of a SQL Server connection and is available only in Microsoft Azure deployments. Some additional configuration properties must be applied. See Configure for Azure.

Supported Versions: Azure SQL DB version 12 (other versions are not supported)

Supported Environments:

Operation

D s product
productee

AmazonMicrosoft Azure
ReadNot supportedNot supportedSupported
WriteNot supportedNot supportedNot supported

Enable: Create SQL DB Connections

Create New Connection: 

Applications

Tableau Server

Supported Versions: 10.2.x and later

Supported Environments:

Operation

D s product
productee

AmazonMicrosoft Azure
ReadNot supportedNot supportedNot supported
WriteSupportedSupportedSupported


Enable:
 Enable Relational Connections

Create New Connection:

Search Integrations

These types of integrations enable you to search catalogs for dataset to import.

Info

NOTE: Search connections cannot be created or modified through the user interface, command line interface, or APs. They are enabled and configured through parameter.

Search capabilities are available through the application. See Import Data Page.

Alation

Enable: For more information on enabling, see Enable Alation Sources.

Create New Connection: No additional configuration is required.

For more information on seraching Alation sources, see Using Alation.

Waterline

Enable: For more information on enabling, see Enable Waterline Sources

Create New Connection: No additional configuration is required.

For more information on seraching Alation sources, see Using Waterline.

Other

Supported

Connections

The following connections are available. Additional Custom configuration is required.

For more information on enabling customizing these connectors for your environment, please contact

d-s-supportproserv
.

JDBC relational connections

  • Databricks Spark SQL
  • MongoDB
  • DataStax Enterprise
  • IBM DB2
  • IBM DB2 for Windows, Linux / Unix
  • IBM DB2 for z/OS
  • IBM Informix
  • MySQL
  • Pivotal Greenplum
  • Progress OpenEdge
  • SAP Sybase

Cloud connections

  • FinancialForce
  • Force.com Applications
  • Salesforce