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.


πŸ”§ Setup Guide - ELT

Step 1 - Begin Configuration

  1. In the connector setup form, enter the destination schema name of your choice.
  2. Click Authorize to give Weld access to your OneDrive files.
  3. When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.

Step 2 - Connection Settings

  1. Select the file type: xlsx or csv.
  2. Enter the folder URL where your files are stored.
  3. 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.

Was this page helpful?