SharePoint is a file storage and collaboration service. Fivetran supports syncing files your SharePoint folder to your destination. You can sync multiple files as unique tables to your destination.
NOTE: Use our Microsoft Lists connector to sync your SharePoint lists. We retrieve every list from the site you select and sync each list as a seperate table in the destination.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| Custom data | check | All tables and fields |
| Data blocking | ||
| Column hashing | ||
| Re-sync | check | Connector level |
| History | ||
| API configurable | check | |
| Priority-first sync | ||
| Private networking | ||
| Fivetran data models |
Setup guidelink
Follow our step-by-step SharePoint setup guide to connect your SharePoint account with your destination using Fivetran connectors.
Sync overviewlink
The SharePoint 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. 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 a 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.
Schema informationlink
We use the file name (without the extension) as the destination table name. For example, a file called sample.csv is synced 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 limitationslink
We only support the .xls, .xlsx, and .xlsm Excel file formats.
We don’t sync hyperlink values from a worksheet.