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.
|Custom Data||check||All tables and fields|
Follow our step-by-step OneDrive setup guide to connect your OneDrive account with your destination using Fivetran connectors.
The OneDrive connector is a Magic Folder connector. 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.
We only sync the files inside the specified folder. We ignore nested folders.
We use the file name (without the extension) as the destination table name. For example, a file called
sample.csv is synced as
If we find files with the same name but with different extensions in the folder, we check the last modified dates of the relevant files and sync only the most recently modified file.