OneDrive
OneDrive is a cloud-based file storage service provided by Microsoft. Fivetran supports syncing files from your OneDrive account to your destination. You can sync multiple files as unique tables to your destination.
NOTE: To sync files from OneDrive in a SharePoint server, see our SharePoint connector documentation.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | check | |
| Data blocking | ||
| Column hashing | ||
| Re-sync | check | |
| API configurable | check | |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step OneDrive setup guide to connect your OneDrive account with your destination using Fivetran connectors.
Sync overview
The OneDrive connector syncs each file as a unique table in your destination. For more information, see Magic Folder Mode.
We sync all files in the OneDrive folder to your destination, even if someone without a Fivetran account uploaded them. Anyone with write access to the folder can drop files into that folder; Fivetran automatically syncs the files from your OneDrive folder to your destination.
We retrieve all the files from the folder that you specify into your destination.
Each file is synced as a separate table in the destination. For spreadsheet files, we sync each worksheet in the spreadsheet as a unique table in your destination.
We don't sync empty worksheets. We don't sync an Excel worksheet if the entire first row of the worksheet is empty. We don't sync a column if its first row is empty.
We only sync the files inside the specified folder. We ignore nested folders.
The OneDrive connector doesn't support incremental syncs. To detect changes in the files of your cloud folder, we use the last modified date of the files. After the initial historical sync, we re-import only the recently modified files in every sync. For information about the sync strategy, see our Cloud Collaboration connectors documentation.
Schema information
We use the file name (without the extension) as the destination table name. For example, we sync a sample.csv file as SAMPLE table.
For spreadsheet files, we use a combination of the file name and worksheet name as the destination table name. For example, two worksheets called Sheet1 and Sheet2 in a spreadsheet My Workings are synced as MY_WORKINGS_SHEET_1 and MY_WORKINGS_SHEET_2 tables. We use the values present in the first row of the worksheet as the column names in the destination table.
For more information about the schema and table naming rule set, see our naming conventions documentation.
If we find files of the same name but with different extensions in the folder, we check the last modified dates of the files and sync only the least recently modified file.
Sync limitations
We don’t support syncing all Microsoft Excel file formats. You can sync files with .xls, .xlsx, and .xlsm formats.
We don’t sync hyperlink values from a worksheet.
We don't sync worksheets with pivot tables.