Establishing a Connection
Connecting with the OneDrive Connection Manager
Adding a new OneDrive connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the OneDrive Connection Manager from the Add SSIS Connection Manager window.
Alternatively, you can create a new connection directly using the OneDrive Source or the OneDrive Destination. You can set the connection properties in the OneDrive Connection Manager window.
Authenticating to OneDrive
OneDrive uses the OAuth authentication standard. To authenticate using OAuth, you will need to create an app to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties. See Using OAuth Authentication for an authentication guide.
Authenticating using MSI Authentication
If you are running OneDrive on an Azure VM, you can leverage Managed Service Identity (MSI) credentials to connect:
- AuthScheme: Set this to AzureMSI.
The MSI credentials will then be automatically obtained for authentication.