Connection Types
You can create the following types of connections from the Dataprep by Trifacta platform. You can use the given links to create connection.
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.
Tip
You can create connections to datasources hosted on Cloud SQL. Search for Cloud SQL for the available connection types, or select the Cloud SQL version of the connection type of interest. Required configuration information is very similar.
Early Preview: Early Preview connections are read-only connection types that get you connected to your data, so that you can begin exploring and importing as soon as possible. For more information, see Early Preview Connection Types.
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.
REST API connectivity:
Build connections to API endpoints that can be accessed by the Trifacta Application. For more information, see REST API Connections.
CRM ERP
These connections enable you to access data in your CRM or ERP systems.
Databases
General relational connectivity:
Relational connectivity is available for the following product editions:
Note
Availability of individual connection types may vary. Please see the documentation for the specific connection type for details.
Note
This feature may not be available in all product editions. For more information on available features, see Compare Editions.
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 the Dataprep by Trifacta platform to any relational source of data, such as Oracle, you must add the Alteryx Service to your whitelist for those resources.
Note
Relational datasources must be available on a public IP address that is accessible to the Dataprep by Trifacta platform.
For more information, see Whitelist Platform Service.
Tip
Click the Cloud SQL version of a connection type to create a connection to your Cloud SQL instance of the selected database.
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.
Cloud Storage
Enable: Automatically enabled. For more information, see Google Cloud Storage 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
BigQuery
Enable: Automatically enabled. For more information, see BigQuery Connections.
Create New Connection: n/a