Connection Types
You can create the following types of connections from the Designer Cloud Powered by Trifacta platform. You can use the given links to create connection.
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.
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:
You can apply this change through the Admin Settings Page (recommended) or
trifacta-conf.json. For more information, see Platform Configuration Methods.Search for the following parameter, and set it to
false:"webapp.connectivity.nonAdminManagementEnabled": true,
Save your changes and restart the platform.
Create Connection
Click Connections in the left nav bar.
In the Connections page, click Create.
Actions:
Search: Enter a search string in the search bar to locate connections of interest.
Tip
Search scans the selected category. For broadest search results, select the All types tab.
I'm interested: Click I'm interested to upvote adding the connection type to the Trifacta Application. Help chart the future direction of connectivity!
For more information, see Create Connection Window.
Connection Categories
In the Create Connection window, connections are organized according to the following categories.
Applications
Connect to data storage for your web-based applications.
CRM ERP
These connections enable you to access data in your CRM or ERP systems.
Databases
These connections pertain to relational database sources.
Note
Unless otherwise noted, authentication to a relational connection requires basic authentication (username/password) credentials.
Enable: For more information, see Relational Access.
File-API
You can create connections to the listed file-based datastores or to other API-based storage.
Marketing
You can create connections to the datastores for popular marketing solutions.
Connections to Base Storage Layer
Connections of these type are automatically created for you.
Apache Hadoop HDFS - Cloudera
Enable:Configure for Hadoop.
Create New Connection: n/a
Amazon AWS
Running environment(s):Trifacta Photon and Spark
Base storage layer: S3
Microsoft Azure
Running environment(s):Trifacta 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.
Amazon S3 (layer)
This connection type refers to using S3 as the base storage layer.
Supported Versions: n/a
Supported Environments:
Operation | Designer Cloud Powered by Trifacta Enterprise Edition | Amazon | Microsoft Azure |
|---|---|---|---|
Read | Supported | Supported | Not supported |
Write | Not supported | Supported | Not supported |
Enable: S3 Access
Create New Connection: n/a
Default Connections
These connections are automatically enabled and configured with the product.
Upload
Enable: Automatically enabled.
Create New Connection: n/a
Other Connections
Hive
Enable:Configure for Hive
Note
Additional configuration is required.
Create New Connection:
Note
A single public Hive connection is supported.
For more information, see Hive Connections.
Custom connections
For more information on other connectivity options, please contact Alteryx Support.