Page tree

 

Contents:


Trifacta® Wrangler Pro 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. 

Supported Environments

Trifacta Wrangler Pro

Running environment(s): Trifacta Photon and Spark

Base storage layer: S3

Default Connections

These connections are automatically enabled and configured with the product.

Upload

Enable: Automatically enabled.

Create New Connection: n/a

Cloud Platforms

These connections pertain to cloud platforms with which Trifacta Wrangler Pro can integrate.

Amazon S3

Supported Versions: n/a

  • Read: Supported
  • Write: Supported

Create New Connection: n/a

NOTE: A single public connection to S3 is supported.

Amazon Redshift

Supported Versions:  n/a

  • Read: Supported
  • Write: Supported

Enable: Create Redshift Connections

Create New Connection: 

UI: Create Redshift Connections


Relational DBs

These connections pertain to relational database sources.

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

If you are connecting Trifacta Wrangler Pro to any relational source of data, such as Redshift or Oracle, you must add the Trifacta Service to your whitelist for those resources. For more information, see Getting Started with Trifacta Wrangler Pro.

DB2



  • DB2 for Windows and Unix/Linux

Supported Versions: v10.5.5

  • Read: Supported
  • Write: Supported.

Create New Connection: 

UI: Create DB2 Connections

MySQL


Supported Versions: 5.7 and 8.0 Community

  • Read: Supported
  • Write: Supported

Create New Connection:

UI: Create MySQL Connections

Oracle


Supported Versions: 12.1.0.2

  • Read: Supported
  • Write: Supported

Create New Connection: 

UI: Create Oracle Connections

PostgreSQL


Supported Versions: 9.3.10

  • Read: Supported
  • Write: Supported

Create New Connection:

UI: Create PostgreSQL Connections

SQL Server


Supported Versions: 12.0.4

  • Read: Supported
  • Write: Supported


Create New Connection:

UI: 

Azure SQL Database

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

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

Supported Environments:

Operation

Trifacta Wrangler Pro

AmazonMicrosoft Azure
ReadSupportedNot supportedSupported
WriteSupportedNot supportedSupported

Enable: Create Azure SQL Database Connections

Create New Connection: 

UI: Create Connection Window

Applications

Trifacta Wrangler Pro can be configured to connect to the following applications.


Salesforce


Supported Versions: n/a

Supported Environments:

  • Read: Supported
  • Write: Not supported.

Create New Connection: 

UI:



Tableau Server

Supported Versions: 10.5.x and later

  • Read: Supported
  • Write: Not supported.

Create New Connection:

UI: Create Tableau Server Connections



This page has no comments.