OneDrive
Microsoft OneDrive is a file-hosting and synchronization service operated by Microsoft as part of its web version of Office. It allows users to store files and personal data like Windows settings or BitLocker recovery keys in the cloud, share files, and sync files across most devices and operating systems.
The OneDrive connector requires your files to be in a dedicated folder. Weld will sync data from this folder to your destination.
π§ Setup Guide - ELT
Step 1 - Begin Configuration
- In the connector setup form, enter the destination schema name of your choice.
- Click Authorize to give Weld access to your OneDrive files.
- When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.
Step 2 - Connection Settings
- Select the file type:
xlsx
orcsv
. - Enter the folder URL where your files are stored.
- Select if you wish to use any of the options:
- Has header row - will use the first row as column names.
- Stringify all properties - will convert all properties to strings, in case there are any issues with the data types.
Step 4 - Data To Sync
Select which files you would like to sync.
Step 5 - Configure Sync
Select how often you would like the data to sync.
Weld will take over from here and commence syncing data from your OneDrive folder.