The 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:
NOTE: Before creating connections to Hive or relational datastores, you must create and deploy an encryption key file. See Create Encryption Key File. |
By default, all users are permitted to create connections. As needed, you can disable the ability to create connections for non-admin users.
Steps:
Search for the following parameter, and set it to false
:
"webapp.connectivity.nonAdminManagementEnabled": true, |
Running environment(s): and Spark
Base storage layer: HDFS
Running environment(s): and Spark
Base storage layer: S3
Running environment(s): and Spark
Base storage layer: ADLS or WASB
For more information, see Running Environment Options.
For more information, see Set Base Storage Layer.
These connections are automatically enabled and configured with the product.
Enable: Automatically enabled.
Create New Connection: n/a
These connections pertain to the various big data platforms that are supported by the .
Enable: Configure for Hadoop.
Create New Connection: n/a
Enable: Configure for Hive
NOTE: Additional configuration is required. |
Create New Connection: Create Hive Connections
NOTE: A single public Hive connection is supported. |
Enable: Configure for Hadoop.
Create New Connection: n/a
Enable: Configure for Hive
NOTE: Additional configuration is required. |
Create New Connection: Create Hive Connections
NOTE: A single public Hive connection is supported. |
These connections pertain to cloud platforms with which the can integrate.
Supported Versions: n/a
Supported Environments:
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Supported | Supported | Not supported |
Write | Not supported | Supported | Not supported |
Enable: Enable S3 Access
Create New Connection: n/a
NOTE: A single public connection to S3 is supported. |
Supported Versions: n/a
Supported Environments:
NOTE: S3 must be set as the base storage layer. See Set Base Storage Layer. |
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Not supported | Supported | Not supported |
Write | Not supported | Supported | Not supported |
Enable: Create Redshift Connections
Create New Connection:
Supported Versions: n/a
Supported Environments:
NOTE: S3 must be set as the base storage layer. See Set Base Storage Layer. |
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Not supported | Supported | Not supported |
Write | Not supported | Supported | Not supported |
Enable: Create Snowflake Connections
Create New Connection:
Supported Versions: n/a
Supported Environments:
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Not supported | Not supported | Supported |
Write | Not supported | Not supported | Supported (only if WASB is base storage layer) |
Enable: Enable WASB Access
Create New Connection: n/a
NOTE: A single public connection to WASB is supported. |
Supported Versions: n/a
Supported Environments:
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Not supported | Not supported | Supported |
Write | Not supported | Not supported | Supported (only if ADLS is base storage layer) |
Enable: Enable ADLS Access.
Create New Connection: n/a
NOTE: A single public connection to ADLS is supported. |
These connections pertain to relational database sources.
Enable: For more information, see Enable Relational Connections .
Supported Versions: v10.5.5
Supported Environments:
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Supported | Supported | Supported |
Write | Not supported | Not supported | Not supported |
Create New Connection:
API: API Connections Create v4
jdbc
db2
Supported Versions: 12.1.0.2
Supported Environments:
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Supported | Supported | Not supported |
Write | Supported | Supported | Supported |
Create New Connection:
API: API Connections Create v4
jdbc
oracle
Supported Versions: 9.3.10
Supported Environments:
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Supported | Supported | Not supported |
Write | Supported | Supported | Supported |
Create New Connection:
API: API Connections Create v4
jdbc
postgres
Supported Versions: 12.0.4
Supported Environments:
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Supported | Supported | Supported |
Write | Supported | Supported | Supported |
Create New Connection:
API: API Connections Create v4
jdbc
sqlserver
Supported Versions: 14.10+
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Supported | Supported | Not supported |
Write | Supported | Supported | Supported |
Enable:
Create New Connection:
API: API Connections Create v4
jdbc
teradata
Supported Versions: n/a
Supported Environments:
Operation | Amazon | Microsoft Azure | ||
---|---|---|---|---|
Read | Not supported | Not supported | Supported | |
Write | Not supported | Not supported | Supported
|
Enable: Create SQL DW Connections
Create New Connection:
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 Database version 12 (other versions are not supported)
Supported Environments:
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Not supported | Not supported | Supported |
Write | Not supported | Not supported | Supported |
Enable: Create Azure SQL Database Connections
Create New Connection:
Supported Versions: n/a
Supported Environments:
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Supported | Supported | Supported |
Write | Not supported | Not supported | Not supported |
Create New Connection:
API: API Connections Create v4
jdbc
salesforce
Supported Versions: 10.2.x and later
Supported Environments:
Operation | Amazon | Microsoft Azure | |
---|---|---|---|
Read | Not supported | Not supported | Not supported |
Write | Supported | Supported | Supported |
Create New Connection:
API: API Connections Create v4
jdbc
tableau
These types of integrations enable you to search catalogs for dataset to import.
NOTE: Search connections cannot be created or modified through the user interface or APIs. They are enabled and configured through parameter. |
Search capabilities are available through the application. See Import Data Page.
Enable: For more information on enabling, see Enable Alation Sources.
Create New Connection: No additional configuration is required.
For more information on searching Alation sources, see Using Alation.
Enable: For more information on enabling, see Enable Waterline Sources
Create New Connection: No additional configuration is required.
For more information on searching Waterline sources, see Using Waterline.
For additional connectivity options, please contact .