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 r0821

D toc

D s product
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

D s product

Running environment(s):

D s photon
and Spark

Base storage layer: HDFS

Amazon AWS

Running environment(s):

D s photon
and Spark

Base storage layer: S3

Microsoft Azure

Running environment(s):

D s photon
and Spark

Base storage layer: ADLS Gen1, ADLS Gen2, 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

D s product
.

Apache Hadoop HDFS - Cloudera

Enable: Configure for Hadoop.

Create New Connection: n/a

Apache Hadoop HDFS - Hortonworks

Enable: Configure for Hadoop

Create New Connection: n/a

Hive

Enable: Configure for Hive

Info

NOTE: Additional configuration is required.

Create New Connection:

Info

NOTE: A single public Hive connection is supported.

API: API Reference

  • Type: hive
  • Vendor: hive

For more information, see Create Hive Connections.

Cloud Platforms

These connections pertain to cloud platforms with which

D s product
can integrate.

Amazon S3 (layer)

This connection type refers to using S3 as the base storage layer.

Supported Versions: n/a

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported
WriteNot supportedSupportedNot supported
Enable:   Enable S3 Access

Create New Connection: n/a

Amazon S3 (user)

This connection type is users to create connections to specific S3 buckets.

Supported Versions: n/a

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadNot supportedSupportedNot supported
WriteNot supportedNot supportedNot supported

Create New Connection: S3 Connections

API: API Reference

  • Type: remotefile
  • vendor: aws


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

AmazonMicrosoft Azure
ReadNot supportedSupportedNot supported
WriteNot supportedSupportedNot supported

Enable: Create Redshift Connections

Create New Connection: 

UI: Create Redshift Connections

API: API Reference

  • Type: redshift
  • vendor: redshift

Snowflake

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

AmazonMicrosoft Azure
ReadNot supportedSupportedNot supported
WriteNot supportedSupportedNot supported
Operation

D s product

AmazonMicrosoft Azure
ReadNot supportedSupportedNot supported
WriteNot supportedSupportedNot supported


Enable: Create Snowflake Connections

Create New Connection: 

UI: Create Snowflake Connections

API: API Reference

  • Type: snowflake
  • vendor: snowflake

AWS Glue

Supported Versions:  n/a

Supported Environments:

Info

NOTE: S3 must be set as the base storage layer, and the platform must be integrated with EMR. See Set Base Storage Layer.

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported
WriteNot supportedNot supportedNot supported

Enable: Enable AWS Glue Access

Create New Connection: 

UI: Create Connection Window


Microsoft Azure WASB

Supported Versions: n/a

Supported Environments:

Operation

D s product

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 Gen1

Supported Versions: n/a

Supported Environments:

Operation

D s product

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

Enable: Enable ADLS Gen1 Access.

Create New Connection: n/a

Info

NOTE: A single public connection to ADLS Gen1 is supported.

Microsoft Azure ADLS Gen2

Supported Versions: n/a

Supported Environments:

Operation

D s product

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

Enable: Enable ADLS Gen2 Access

Create New Connection: n/a

Info

NOTE: A single public connection to ADLS Gen2 is supported.

Databricks Tables

Supported Versions: n/a

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadNot supportedSupportedSupported
WriteNot supportedSupportedSupported

Enable: Create Databricks Tables Connections

Create New Connection:  Create Databricks Tables Connections

Tip

Tip: It's easier to create a connection of this type through the UI. Typically, only one connection is needed.


API: API Reference

  • Type: jdbc
  • Vendor: databricks

Relational DBs

These connections pertain to relational database sources.

Info

NOTE: Unless otherwise noted, authentication to a relational connection requires basic authentication (username/password) credentials.

Enable: For more information, see Enable Relational Connections.

DB2

  • DB2 for Windows and Unix/Linux

Supported Versions: v10.5.5

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteNot supportedNot supportedNot supported

Create New Connection: 

UI: Create DB2 Connections

API:API Reference

  • Type: jdbc
  • Vendor: db2

MySQL

Supported Versions: 5.7 and 8.0 Community

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteSupportedSupportedSupported

Create New Connection:

UI: Create MySQL Connections

API: API Reference

  • Type: jdbc
  • Vendor: mysql

Oracle

Supported Versions: 12.1.0.2

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported
WriteSupportedSupportedSupported

Create New Connection: 

UI: Create Oracle Connections

API: API Reference

  • Type: jdbc
  • Vendor: oracle

PostgreSQL

Supported Versions: 9.3.10

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteSupportedSupportedSupported

Create New Connection:

UI: Create PostgreSQL Connections

API:API Reference

  • Type: jdbc
  • Vendor: postgres

SQL Server

Supported Versions: 12.0.4

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteSupportedSupportedSupported


Create New Connection:

UI: 

API: API Reference

  • Type: jdbc
  • Vendor: sqlserver

Teradata

Supported Versions: 14.10+

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported
WriteSupportedSupportedSupported


Enable: 

Create New Connection:

UI: Create Connection Window

API:API Reference

  • Type: jdbc
  • Vendor: teradata

SQL DW

Supported Versions: n/a

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadNot supportedNot supportedSupported
WriteNot supportedNot supported

Supported

Info

NOTE: Additional configuration is required.

Enable: Create SQL DW Connections

Create New Connection: 

UI: Create Connection Window

API: API Reference

Azure SQL Database

Info

NOTE: This database connection is a specialized version of a SQL Server connection.

Info

NOTE: For Azure deployments, some additional configuration properties must be applied. See Configure for Azure .

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

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedNot supportedSupported
WriteSupportedNot supportedSupported

Enable: Create Azure SQL Database Connections

Create New Connection: 

UI: Create Connection Window

API: Not supported

MongoDB

Supported Versions: n/a

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteNot supportedNot supported

Not supported


Enable: MongoDB Connections

Create New Connection: 

UI: Create Connection Window

API:

Code Block
"vendor": "mongodb",
"vendorName": "MongoDB",
"type": "jdbc"

MongoDB Atlas

Supported Versions: n/a

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteNot supportedNot supported

Not supported


Enable: MongoDB Connections

Create New Connection: 

UI: Create Connection Window

API:

Code Block
"vendor": "mongodb_atlas",
"vendorName": "MongoDB Atlas",
"type": "jdbc"

Applications

D s product
can be configured to connect to the following applications.


Salesforce

Supported Versions: n/a

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteNot supportedNot supportedNot supported

Create New Connection: 

UI:

API:API Reference

Info

NOTE: If you are using OAuth 2.0 authentication for this type, you cannot create connections via API.


  • Type: jdbc
  • Vendor: salesforce

SFTP

Supported versions: n/a

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteSupportedSupportedSupported

Create New Connection:

UI: Create SFTP Connections

API:

  • Type: jdbc
  • Vendor: sftp

Microsoft SharePoint

Supported versions: n/a

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadSupportedSupportedSupported
WriteSupportedSupportedSupported

Create New Connection:

UI: Create SharePoint Connections

API:

  • Type: jdbc
  • Vendor: sharepoint

Tableau Server

Supported Versions: 10.5.x and later

Supported Environments:

Operation

D s product

AmazonMicrosoft Azure
ReadNot supportedNot supportedNot supported
WriteSupportedSupportedSupported

Create New Connection:

UI: Create Tableau Server Connections

API: API Reference

  • Type: jdbc
  • Vendor: tableau



Other Connections

For more information on other connectivity options, please contact

D s support
.