Page tree

Release 8.7



Contents:

   

Contents:


Trifacta® Self-Managed Enterprise Edition supports the following types of connections. Use the links below to create new connections. 

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:

  1. You can apply this change through the Admin Settings Page (recommended) or trifacta-conf.json. For more information, see Platform Configuration Methods.
  2. Search for the following parameter, and set it to false:

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

Create Connection

  1. Click Connections in the left nav bar. 
  2. 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 REST 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

Apache Hadoop HDFS - Hortonworks

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

Trifacta Self-Managed Enterprise Edition

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported
WriteNot supportedSupportedNot 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 Trifacta Support.

This page has no comments.