Page tree

Trifacta Dataprep


Contents:

On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

Contents:


Cloud Dataprep by TRIFACTA® INC. 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. 

Default Connections

These connections are automatically enabled and configured with the product.

Upload

Enable: Automatically enabled.

Create New Connection: n/a

Relational DBs

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

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 Cloud Dataprep by TRIFACTA INC. to any relational source of data, such as Oracle, you must add the Trifacta Service to your whitelist for those resources.

NOTE: Relational datasources must be available on a public IP address that is accessible from the deployment of Cloud Dataprep Premium by TRIFACTA INC..

For more information, see Getting Started with Cloud Dataprep.

MySQL


Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

Supported Versions: 5.7 and 8.0 Community

  • Read: Supported
  • Write: Supported

Create New Connection:

UI: Create MySQL Connections

API: API Reference

  • Type: jdbc
  • Vendor: mysql

Oracle


Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

Supported Versions: 12.1.0.2

  • Read: Supported
  • Write: Supported

Create New Connection: 

UI: Create Oracle Connections

PostgreSQL


Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

Supported Versions: 9.3.10

  • Read: Supported
  • Write: Supported

Create New Connection:

UI: Create PostgreSQL Connections

SQL Server


Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

Supported Versions: 12.0.4

  • Read: Supported
  • Write: Supported


Create New Connection:

UI: 

Applications

Cloud Dataprep by TRIFACTA INC. can be configured to connect to the following applications.


Salesforce

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.


Supported Versions: n/a

Supported Environments:

  • Read: Supported
  • Write: Not supported

Create New Connection: 

UI:


Microsoft SharePoint


Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

Supported versions: n/a

  • Read: Supported
  • Write: Supported

Create New Connection:

UI: Create SharePoint Connections



Cloud Dataprep by TRIFACTA INC.

BigQuery

Enable: Automatically enabled.

Create New Connection: n/a

Google Cloud Storage

Enable: Automatically enabled.

Create New Connection: n/a


This page has no comments.