Microsoft OneDrive Connections
Create a connection to your Microsoft OneDrive instance from the Dataprep by Trifacta
Limitations
Single Sign-On (SSO) is not supported.
Column names are not validated on publishing.
The Microsoft OneDrive connection uses OneDrive APIs. As a result, transaction management and rollbacks are not supported.
Prerequisites
The logged-in user must have required access to the specific Folders within OneDrive.
Configure
To create this connection, on the Connections page select Create Connection and then search for Microsoft OneDrive. Then select the Microsoft OneDrive card. Go to the Connections Page for more information.
Modify the following properties as needed:
Property | Description |
|---|---|
Default Column Data Type Inference | Set to |
OAuth 2.0 client | Use OAuth 2.0 authentication to access OneDrive. Note that for OAuth 2.0 authentication, additional configuration is required. See OAuth 2.0 for OneDrive. |
Authenticate | After you've defined the credentials, select Authenticate to validate them. |
Connection Name | Display name of the connection |
Connection Description | Description of the connection, which appears in the application. |
Using Microsoft OneDrive Connections
This section describes how you interact through Dataprep by Trifacta with yourOneDrive files.
Uses of Microsoft OneDrive
The Dataprep by Trifacta can use OneDrive for the following tasks:
Import CSV and Excel files by reading from OneDrive.
Export CSV and Excel files to OneDrive with your job results.
Before You Begin Using Microsoft OneDrive
Read Access: Your OneDrive administrator must configure read permissions.
Write Access: You can write and publish jobs results to OneDrive.
Storing Data in OneDrive
Your OneDrive administrator should provide database access for storing datasets. Users should know where shared data is located and where personal data can be saved without interfering with or confusing other users.
Note
.Dataprep by Trifacta does not modify source data in OneDrive. Datasets sourced from OneDrive are read without modification from their source locations.
Reading from OneDrive
You can create an Alteryx dataset from a file stored in OneDrive. To start, choose between files and folders organized under My Files or Shared with Me. Then, navigate to the file that you want.
For more information, go to Database Browser.
Data Validation issues:
No validation is performed for the connection and any required permissions during job execution. So, you can be permitted to launch your job even if you do not have sufficient connectivity or permissions to access the data. The corresponding publish job fails at runtime.
Known Issues
If you’ve recently granted or revoked access to a OneDrive asset, you might not notice the change immediately in the Microsoft OneDrive Connection. Please try again later.
Reference
Supported versions: n/a
Read: Supported
Write: Supported