Overview
The OneDrive for Business Connector allows you to work with files stored in Microsoft OneDrive for Business cloud storage. It is designed for file-based operations such as reading, writing, copying, moving, and deleting files, and for using OneDrive as a source or destination in ETL and file workflows.
Note: To access artifacts stored in consumer OneDrive accounts, use the Consumer OneDrive connector.
Creating a OneDrive for Business Connection
Step 1. Add a New Connection
-
Open the Connections screen.
-
Click + Create.
-
Search for OneDrive.
-
Select OneDrive for Business.
Step 2. Configure Connection Parameters
Required Parameters
-
Organization Domain
Example: etlworks
-
Files
File name or wildcard pattern.
Example: *.*
Optional Parameters
-
Directory
The folder path within cloud storage that contains files.
Step 3. Authentication
OAuth Authentication
This method uses delegated permissions and acts on behalf of the signed-in user.
-
Works with OneDrive for Business/Office 365
-
Required when 2FA or SSO is enabled for the Microsoft account
Steps:
-
Select OAuth as the authentication method.
-
Click Sign in with Microsoft.
-
Complete the Microsoft authentication flow.
-
Adjust permissions if needed.
Client Secret Authentication (Service Principal / App-Only)
Recommended for background jobs, automation, and service integrations.
This method uses application permissions and does not require user login.
Use this method when:
-
No interactive login is possible
-
The integration runs as a service
-
Tenant-wide or application-level permissions are required
Steps:
- Select Client secret as the Authentication method.
- Enter:
-
-
Client ID (Application ID from Azure App Registration)
-
Client Secret
-
Tenant ID
-
Ensure the Azure App Registration has:
-
-
Application permissions (not Delegated)
-
Admin consent granted
-
Username and Password Authentication
-
Supported only for environments where Microsoft still allows it
-
Disabled by Microsoft for most modern OneDrive for Business environments
Note: OAuth or Client Secret authentication is strongly recommended.
File-Related Connection Options
Add Suffix When Creating Files in Transformation
Automatically appends a suffix to files created by source-to-destination transformations.
Example:
-
Original file: output.csv
-
Suffix: uuid
-
Result: output_uuid.csv
This option applies only to transformation output files.
For copy, move, rename, or archive operations, use file-management options instead.
File Processing Order
Controls the order in which files are processed when using wildcards.
Available options:
-
Disabled – wildcard processing disabled
-
Oldest / Newest – based on modification or creation time
-
Ascending / Descending – alphabetical order
-
Largest / Smallest – file size
Default: Oldest
Delete Behavior: Soft Delete vs Permanent Delete
By default, file deletion in OneDrive uses soft delete.
Soft Delete (Default)
-
Deleted files are moved to the OneDrive recycle bin
-
Files can be restored from OneDrive
-
Safer and recommended for most use cases
Permanent Delete (Optional)
Enable Permanent Delete to bypass the recycle bin:
-
Files are immediately and permanently deleted
-
Files cannot be restored
-
Use with caution
Decryption (PGP)
When used as a source in a source-to-destination transformation, the connector can automatically decrypt files encrypted with PGP.
-
Requires a private key stored in secure key storage
-
Private key password is required
-
All source files are decrypted automatically before processing
Read how to generate a pair of public/private keys.
Compression and Archiving
Expected Compression (Automatic Decompression)
Use Expected Compression when reading compressed files.
Supported values:
-
No Compression
-
Zip
-
GZip
If set to Zip or GZip:
-
Etlworks automatically decompresses the file as it is read
-
Each compressed file must contain a single resource
-
The system always attempts decompression regardless of file extension
Learn more about automatic decompression.
Automatic Archiving When Writing or Copying Files
Etlworks also supports automatic file archiving when writing or copying files.
-
Output files can be automatically archived as ZIP or GZIP
-
Applies to ETL operations and file copy workflows
This functionality is configured using Archive output files options.
Learn more about automatic archiving.