Connection Types

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

These connections pertain to relational database sources.

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.

For more information, see Getting Started with Cloud Dataprep.

MySQL

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

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: 

• Create SQL Server Connections
• Create Connection Window

Applications

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

• Create Salesforce Connections

Microsoft SharePoint

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